MySQL使用查询结果创建表_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原創
- 2016-06-01 13:45:021749瀏覽
bitsCN.com
MYSQL不支持:
Select * Into new_table_name from old_table_name;
替代方法:
1
Create table new_table_name (Select * from old_table_name);
select * into new_table_name from old_table_name;
2
SELECT * INTO OUTFILE 'a.txt' FROM table_name;
LOAD DATA INFILE '/database/mysql/a.txt' INTO TABLE new_table_name;
作者“ylqmf的专栏”
bitsCN.com陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn