MySQL 最最简单命令---- 慢慢收集

mysql -u root -p 123

查看当前数据库: show databases;

添加数据库: create database newDatabase;

删除数据库: drop database newDatabase;

创建表 CREATE TABLE accoutTable ( id bigint(20), username varchar(255), qq varchar(255));

查看表 show tables;

查看表结构: describe accoutTable;

删除数据表table: drop table table_name;

为数据表增加列: alter table [table_name] add [column_name] [data_type] [not null] [default]

eg: alter table account add c1 int(11) not null default 1;

删除列: alter table [table_name] drop [column_name];

eg: alter table account drop c1;

修改列信息: alter table [table_name] change [old_column_name] [new_column_name] [data_type]

eg: 1.只改列名: data_type和原来一样, old_column_name != new_column_name

eg: 2.只改数据类型: old_column_name = new_column_name, data_type改变

eg: 3.列表和数据类型都改了

修改表名: alter table [table_name] rename [new_table_name]

eg: alter table account rename newAccount;

查看表数据: select *from table_name; 或者 select col_name1, col_name2,…from table_name;

插入数据: insert into [table_name] values(值1, 值2,…) 或者 insert into [table_name] (列1, 列2..) values (值1, 值2,…)

where 语法: select * from table_name where col_name 运算符 值

and or

select * from table_name where col_name is null / not null

distinct(精确的)

select distinct col_name from table_name;

eg: select distinct title from book;

修改单列: update 表名 set 列名 = xxx [where 字句]

修改多列: update 表名 set 列名1 = xxx, 列名2 = xxx,… [where 字句]

查询MySQL的端口号: show global variables like ‘port’;