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;
- 添加表列
alter tabel person
add birth date;
- 删除表列
alter table person
drop colum birth;
- 改变表列数据类型
alter table person
alter column birth year;
- 改变表列名
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;