常见基础SQL语句汇总

websites,access_log,apps（表数据来源）

“数据库”的增删改查和使用

Create Database

Create database test;

drop databases

Drop Database test;

Alter Database

暂时找不到改数据名的命令

Show databases

show databases

use database

use test;

“数据库表”的增删改查

Create Table

Create Table person
(
    id int,
    laseName varchar(255),
    fistName varchar(255),
    address varchar(255),
    city varchar(255)
);

Drop Table

Drop Table person;

Alter Table
1. 更改表名

alter table person
rename pserson1;

1. 添加表列

alter tabel person
add birth date;

1. 删除表列

alter table person 
drop colum birth;

1. 改变表列数据类型

alter table person
alter column birth year;

1. 改变表列名

alter table person
change column birth birth1 int;

Show Tables

show tables test;

“表记录”的增删改查

Insert Into

Insert Into person(id, city)
values(1, '成都'),
values(2, '绵阳');

Delete

Delete from Websites
Where name = '百度' And country = 'CN';

Update

Update Websites
Set alexa = '5000', country = 'USA'
Where name = '菜鸟教程';

提示：
更新记录时要格外小心！在上面的实例中，如果我们省略了Where字句，会将表中所有的alexa改为5000，country改为USA

Select

Select name, country Form Website;