Mysql
2019-08-16 本文已影响0人
zouxiaoyu
Mac下安装MYSQL：
https://zhuanlan.zhihu.com/p/27960044
You must reset your password using ALTER USER statement before executing this statement. 解决方案：
mysql> SET PASSWORD = PASSWORD('your_new_password');
alter table aspect_issue change bug_id to issue; 列重命名
rename table aspectj_method to aspect_method; 表重命名
show databases; 查看有哪些数据库
desc ant_issue; 查看表结构
source aspect_method.sql; 直接运行sql脚本
mysql -u root -p"${mypasswd}" istData_db -e "select Id, issue, method from ant_issue_method;" -pxxx的形式将密码xxx放入命令行直接运行mysql。也可以将xxx直接换成shell里的变量名$mypasswd
