目录
准备
mysql -uroot -p123123
#登录
create database class;
use class;
create table test (id int not null,name char(20) not null,cardid varchar(18) not null unique key,primary key (id));
insert into test (id,name,cardid) values (1,'wangyi','111111');
insert into test (id,name,cardid) values (2,'wanger','222222');
insert into test (id,name,cardid) values (3,'wangsan','333333');
select * from test;
一、克隆表
将数据表的数据记录生成到新的表中
create table TEST01 like TEST;
select * from TEST01;
desc TEST01;
insert into TEST01 select * from TEST;
select * from TEST01;
方法二
create table TEST02 (select * from TEST);
select * from TEST02;
二、清空表
删除表内的所有数据</