CREATETABLEIFNOTEXISTS sys_student (
name VARCHAR(10),
age INT,
class VARCHAR(10)
math DECIMAL(4,1),
chinese DECIMAL(4,1));CREATETABLE sys_student _clone LIKE sys_student ;-- 复制表
-- 增INSERTINTO sys_student VALUES('张三',20);-- 删DELETEFROM sys_student WHERE name ='李四';-- 条件删除TRUNCATETABLE sys_student ;-- 全删-- 改UPDATE sys_student SET name ='zhansan'WHERE name ='张三';
六、数据库表表查询操作
-- 去重操作SELECTDISTINCT name FROM sys_student ;-- 四则运算查询SELECT IFNULL (math,0)+ IFNULL(chinese,0)AS total FROM sys_student ;-- 与查询(&&)SELECT*FROM sys_student WHERE age>20&& age<30;SELECT*FROM sys_student WHERE age>20AND age<30;SELECT*FROM sys_student WHERE age BETWEEN20AND30;-- 或查询(||)SELECT*FROM sys_student WHERE age=20|| age=30;SELECT*FROM sys_student WHERE age=20OR age=30;SELECT*FROM sys_student WHERE age IN(20,30);-- 非查询(NOT)SELECT*FROM sys_student WHERE class ISNULL;SELECT*FROM sys_student WHERE class ISNOTNULL;-- 占位符SELECT*FROM sys_student WHERE name LIKE'武_';-- 占位符查询 (_)SELECT*FROM sys_student WHERE name LIKE'_文%';-- 占位符查询 (%)
七、查询语法规则
SELECT
字段列表
FROM
表名列表
WHERE
条件列表
GROUPBY
分组字段
HAVING
筛选条件(聚合函数)ORDERBY
排序(ASC,DESC)LIMIT
分页限定(LIMIT(当前页,条数));
一、开启/关闭mysql服务net start mysql //开启net stop mysql //关闭二、登陆mysqlmysql -uroot -p //密码默认回车三、数据库操作 1.创建/删除/显示数据库CREATE DATABASE IF NOT EXISTS my_db CHARACHTER SET gbk; -- 创建...