MySQL基本建库建表添加约束增删改查

-- 建库
CREATE DATABASE shop CHARSET utf8;
-- 切换数据库
USE shop;
-- 建表
CREATE TABLE db(
	id INT PRIMARY KEY AUTO_INCREMENT,
	name VARCHAr(30) NOT NULL,
	sex CHAr(2),
	age INT,
	address VARCHAr(100)
)ENGINE INNODB CHARSET utf8;

-- 增
INSERT INTO db(name,sex,age,address) VALUES('张三','男',22,'三门峡');
INSERT INTO db(name,sex,age,address) VALUES('李四','女',23,'三门峡');
INSERT INTO db(name,sex,age,address) VALUES('王五','男',22,'三门峡');

-- 删
delete from db where id = 1;

-- 改
UPDATe db set name = '程少商' WHERe id = 2;

-- 查
SELECT * FROM db;
select name,sex from db;