MariaDB [test]> create view v1(a) as  values (3), (7), (1);                                                                                                                                                

MariaDB [test]> show create view v1;                                                                                    

+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+

| View | Create View                                                                                | character_set_client | collation_connection |

+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+

| v1   | CREATE ALGORITHM=UNDEFINED DEFINER=`` SQL SECURITY DEFINER VIEW `v1` AS values (3),(7),(1) | utf8                 | utf8_general_ci      |

+------+--------------------------------------------------------------------------------------------+----------------------+----------------------+

MariaDB [test]> select * from v1;

+---+

| 3 |

+---+

| 3 |

| 7 |

| 1 |

+---+