CREATE TABLE stu_info (id int PRIMARY KEY, name char(20));
创建表格
INSERT INTO stu_info(id,name) VALUES(3,'wang'),(4,'liu');
添加插入内容
show tables;
显示数据表
UPDATE stu_info SET `name`='zhang' WHERE id = 1;
修改id为1的表的值;
DELETE FROM stu_info WHERE id = 1;
删除id=1的行
DELETE FROM stu_info WHERE id < 3;
删除id小于3的表格
ALTER TABLE stu_info ADD age INT AFTER id;
在id位置的后边儿插入一行age
创建表:create table 表名 (字段设定列表);
删除表:drop table 表名;
修改表:alter table t1 rename t2
查询表:select * from 表名;
清空表:delete from 表名;