Python之MySQL基础

# 创建一个user_info表，uid自增
CREATE TABLE user_info(
    uid INT AUTO_INCREMENT PRIMARY KEY,
    uname VARCHAR(20)
)ENGINE = INNODB DEFAULT CHARSET = utf8;

# 表内插入3条数据
INSERT INTO user_info(uname) VALUES(‘老赵‘);
INSERT INTO user_info(uname) VALUES(‘老李‘);
INSERT INTO user_info(uname) VALUES(‘老王‘);

SELECT * FROM user_info;

# 删除第二条和第三条数据
DELETE FROM user_info WHERE uid = 2 OR uid = 3;

# 再次插入一条数据
INSERT INTO user_info(uname) VALUES(‘老李‘);
# 再次查看uid为4
SELECT * FROM user_info;