1.插入记录
语法:INSERT [INTO] tb_name [(col_name,……)] VALUES(val,……);
INSERT INTO user(username,age,salary) VALUES('笑笑','18',10000.00);
2.查询记录
语法:SELECT expr,…… FROM tb_name;
SELECT * FROM user;
3.建表时添加主键约束(主键约束的字段不能为空、不能重复)
CREATE TABLE tb1(
id INT PRIMARY KEY,
username VARCHAR(20),
age INT
);
4.建表时添加自动编号(必须与主键配合使用)
CREATE TABLE tb2(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(20),
age INT
);
5.向数据库表tb2插入数据验证主键自增
INSERT INTO tb2(username,age) VALUES('笑笑',18);
INSERT INTO tb2(username,age) VALUES('笑笑a',18);
![](https://i-blog.csdnimg.cn/blog_migrate/451b6ac6b941dbd2b38b6edbe6077627.png)