编辑代码

CREATE IF NOT EXIST  DATABASE mytest;
use mytest;
CREATE TABLE Student (
	id int primary key auto_increment,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);
INSERT INTO Student VALUES (null, '张三', '李四家隔壁', '杭州');
SELECT * FROM Student;

-- CREATE TABLE Student_aa  SELECT * FROM Student where 1=2;
-- INSERT  INTO Student_aa SELECT * FROM Student;
-- SELECT * FROM Student_aa;

-- ALTER TABLE Student
-- ALTER TABLE Student MODIFY COLUMN `id` primary key auto_increment;
ALTER TABLE Student DROP name;
SELECT * FROM Student_aa;