MariaDB [monty]> INSERT INTO bar SELECT * FROM view_foo;
|
Query OK, 1 row affected (1.623 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [monty]> select * from view_foo;
|
+------+-------+
|
| id | fname |
|
+------+-------+
|
| 1 | Greg |
|
+------+-------+
|
1 row in set (0.001 sec)
|
|
MariaDB [monty]> select * from bar;
|
+------+-------+
|
| id | fname |
|
+------+-------+
|
| 1 | Greg |
|
+------+-------+
|
1 row in set (0.067 sec)
|
|
MariaDB [monty]> INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t;
|
Query OK, 1 row affected (1.284 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [monty]> select * from bar;
|
+------+-------+
|
| id | fname |
|
+------+-------+
|
| 1 | Greg |
|
| 1 | Greg |
|
+------+-------+
|
2 rows in set (0.018 sec)
|
|