mysql 数据表的复制案例
复制表的结构
CREATE TABLE copy LIKE author;
复制表的结构外加数据
CREATE TABLE copy2 SELECT * FROM author;
只复制部分数据和结构
CREATE TABLE copy3 SELECT id,au_name FROM author WHERE nation='中国';
只复制部分结构不要数据,即数据的条件恒不成立
CREATE TABLE copy4 SELECT id,au_name FROM author WHERE 0;
相关推荐
yangkang 2020-11-09
lbyd0 2020-11-17
sushuanglei 2020-11-12
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
腾讯soso团队 2020-11-06
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
gaobudong 2020-11-04
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30