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’;