SQL增删改查

人生如戏，妆颜上戏台，一颦一笑由己更有命；世事如棋，提子入棋局，一纵一横由人更由天。

创建表

CREATE TABLE teacher(id INT,
name VARCHAR(100) NOt NULL,
age INT(10) NOT NULL,
sex VARCHAR(10) NOT NULL,
kaill VARCHAR(20) NOT NULL,
PRIMARY KEY(id)
);

展示表列

show columns from table_name;

查询

SELECT * from student_info_table;

插入

INSERT INTO student_info_table (`id`,`student_id`,`name`,`age`,`sex`,`birth`,`address`,`major_id`,`detail`,`like`,`internship_code`)
VALUES (7,1602012007,'小莎',24,"女","1998-4-1","云南普洱",208,'喜欢宅家','测试',222333);

修改

UPDATE  student_info_table SET id = 7 where `like` = '温柔';

删除

DELETE FROM student_info_table WHERE id = 7;

删除表

drop table table_name;