启动服务
需要以管理员的身份运行cmd,输入命令net start [服务器名称]
**注意:需要以管理员身份运行指令,否则会提示:发生系统错误 5 拒绝访问 **
查看表结构
DESC [表名]
筛选数据
- 去重
SELECT DISTINCT [列名] FROM 表名 WHERE 筛选条件;
- 带时间的筛选
SELECT * FROM [表名] WHERE [时间字段名] <= '2022-01-10 23:59:59'
- 多选
SELECT * FROM [表名] WHERE [字段名] IN ('','');
备份数据
CREAT TBALE [备份表名] AS SELECT * FROM [表名] WHERE 筛选条件
修改
修改数据
UPDATE [表名] SET [列名] = 值 WHERE 筛选条件;
修改表结构
1.将A列置于B列后
ALTER TABLE [表名] MODIFY [列A] [字符类型] AFTER [列B];
2.将A列置于最前一列
ALTER TABLE [表名] MODIFY [列A] [字符类型] FIRST;
删除
删除数据
DELECT FROM [表名] WHERE 筛选筛选