MariaDB [(none)]> create database db;
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> use db;
|
Database changed
|
MariaDB [db]> create view v1 as select 1;
|
Query OK, 0 rows affected (0.10 sec)
|
|
MariaDB [db]> create view if not exists v1 as select 1;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
MariaDB [db]> show warnings;
|
+-------+------+---------------------------+
|
| Level | Code | Message |
|
+-------+------+---------------------------+
|
| Note | 1050 | Table 'db' already exists |
|
+-------+------+---------------------------+
|
1 row in set (0.00 sec)
|