Mysql数据库流程图:
mysql
数据类型:
字符串
varchar
CHAR
TINYBLOB
TINYTEXT
BLOB
TEXT
MEDIUMBLOB
MEDIUMTEXT
LONGBLOB
LONGTEXT
日期
DATE
TIME
YEAR
DATETIME
TIMESTAMP
数值
TINYINT
SMALLINT
MEDIUMINT
INT或INTEGER
FLOAT
DOUBLE
DECIMAL
建库建表
#建库
CREATEDATABASE IF NOT EXISTS
yuesu DEFAULT CHARSET utf8
#建表
CREATE TABLE IF NOT EXISTS
student( id INT PRIMARY KEY);
增删改查
增
INSERT INTO emp VALUES(''zhangsan'');
删
DELETE FROM emp WHERE NAME=''lisi'';
改
UPDATE cs_user SET age=14
查
基本
SELECT * FROM cs_user
where
SELECT * FROM cs_user WHERE age <= 14
排序
SELECT * FROM cs_user ORDER BY gender
分组
SELECT * FROM cs_user GROUP BY gender HAVING AVG(age)>14
去重