MySQL-将查询到的sql导入一张新表(新表未创建)
语法:
create table ex_table_A select * from table_A;
ex_table_A 是新创建的表的表名
[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.35 MySQ...
原创
2021-11-18 13:59:12 ·
1156 阅读 ·
0 评论