MySQL常用命令

• show global variables like ‘port‘;查看端口号
• alter user ‘root’@‘localhost’ identify with mysql_native_password BY ‘password’;用SQLyog登录时错误代码2058，输入此命令
• mysqladmin -uroot -p123456 password 123修改密码
• mysql -h localhost -P 3306 -u root -p123连接数据库
• show databases;显示所有的数据库文件
• create database mysql;创建数据库
• use mysql;使用某个数据库
• show tables;查看数据表
• drop database mysql;删除库
• insert into [table_name] ([column],…) values(“name”,…);增加数据
• delete from [table_name] where [column_name] = " ";删除数据
• update [table_name] set [columns] = " ",[columns] = " " where;更改数据
• select * from [tables] order by [columns] desc;查询数据
• SELECT table_name FROM TABLES WHERE TABLE_SCHEMA = ‘goods’;
• alter table MyClass add passtest int(4) default ‘0’;添加字段
• alter table Person drop column age;删除字段
• UPDATE table_name
  SET column1=value1,column2=value2,…
  WHERE some_column=some_value;修改数据