sql总结
sql分类:
DDL:
对象:数据库和表
关键词: create alter drop truncate
创建数据库: create database 名称;
删除数据库:drop database 名称;
创建表: create table user(
id int primary key auto_increment,
username vaichar(20)
);
修改表:
alter table user rename to users;
alter table user add password varchar(20);
alter table user change password pwd varchar(20);
alter table user modify pwd int;
alter table user drop pwd;