Mysql入门

增删改查

DDL-data definition language

创建、删除、更改数据库对象

create/drop/alter database

create/drop/alter table

create/drop index

 

DML-data manipulation language

DCL-data control language

select update delete insert into

grant revoke

commit rollback

 

/opt/mysql/bin/mysql -h -D ssadb

 

创建数据库

DROP TABLE IF EXISTS 'TABLE_NAME'

CREATE TABLE 'TABLE_1'{

PRIMARY KEY('*'),

UNIQUE KEY ''

}ENGINE = InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf-8;

 

LOCK TABLES 'TABLE_2' WRITE;

UNLOCK TABLES;

 

table

column

datatype 数据类型

 定长串 char 

 变长串 text varchar enum set

 DECIMAL

 MEDIUMINT

 DATETIME

 TIMESTAMP

 BLOB

row

primary key

 

//执行sql文件

mysql> source d:\*.sql

//select语句

  单列查询、多列查询、全部查询

  查询行 select distinct column_name from table_name;

  限制行 limit 5,6;

  为查询的条件加限定 select table_name.column_name from table_name;

 

//排序 

单列排序 order by column_name

多列排序 order by column_name1,column_name2;

升序 asc

降序 desc

 

//过滤数据 where

范围检查 BETWEEN AND

空值检查 is null/is not null

 

//组合where子句

and  or  

and优先级大于or

in 指定条件范围

not