- 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;修改数据
MySQL常用命令
最新推荐文章于 2021-02-06 19:17:05 发布