(Owed by: 春夜喜雨 http://blog.csdn.net/chunyexiyu)
参考:https://www.runoob.com/mysql/mysql-select-database.html
参考:https://blog.csdn.net/xlxxcc/article/details/51754524
参考:https://blog.csdn.net/weixin_39791387/article/details/81908762
登录:
->mysql -h ipaddress -P port -u username -p
输入password:
检查有哪些数据库:
show databases;
选中数据库:
use db;
显示数据库有哪些表:
show tables;
检查表字段:
DESC user
检查表的schema:
show create table user;
(Owed by: 春夜喜雨 http://blog.csdn.net/chunyexiyu)