mysql
- 查询去重
SELECT DISTINCT job_name FROM jobs.
SELECT job_name FROM jobs GROUP BY job_name
2 授权远程登录
GRANT ALL PRIVILEGES on *.* to 'root'@'%' IDENTIFIED by 'admin123' WITH GRANT OPTION;
3 删除表内 所有行
TRUNCATE TABLE name
mysql
SELECT DISTINCT job_name FROM jobs.
SELECT job_name FROM jobs GROUP BY job_name
2 授权远程登录
GRANT ALL PRIVILEGES on *.* to 'root'@'%' IDENTIFIED by 'admin123' WITH GRANT OPTION;
3 删除表内 所有行
TRUNCATE TABLE name