你可真棒💚💚
设置数据库安全权限:set sql_safe_updates=0;
(允许批量修改数据)
alter修改有rename,change,modify,add,drop 命令
常用查看命令:
show,desc(describe)
示例:
show databases;
show tables;
desc emp;
distinct(去除重复值)
输出文件
into outfile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/t.csv'
fields terminated by',';