增删改查的语句命令为
增:insert
删:delete
改:update
查:SELECT或者show
库操作
创建数据库:create database shujukuba;
创建带字符集的数据库:create database mydb2 CHARACTER SET=utf8;
创建带校验的数据库:create database mydb3 CHARACTER SET=utf8 COLLATE utf8_general_ci;
显示数据库:show databases;
删除数据库:DROP DATABASE shujukuba;
修改数据库编码:ALTER DATABASE shujukuba character set gb2312;
表操作
创建数据库表(创建一个表名为:employee,该表中含有id、name、sex、birthday、job字段):
create table employee
(
id int,
name varchar(40),
sex char(4),
birthday date,
job varchar(100),
);
表中增加image字段:alter table employee add image blob;
修改job值,使其长度为60(原长度为1000):alter table employee modify job varchar(60);
删除sex列:alter table employee drop sex;
表名改为user(原名employee):rename table employee to user;
修改表的字符集为utf-8:alter table user character set utf8;
列name修改为username:alter table user change column name username varchar(100);
删除表:drop table user;
增删改查实例
准备表
新建表employee:
插入表数据
插入数据:
insert into employee(id,name,sex,birthday,entry_date,salary,resume) values(1,'zhangsan','male','1993-03-04','2016-11-10','1000','i am a developer');指定某些列插入数据:insert into employee(id) values(6);
插入汉字:insert into employee(id,name) values(6,'张三');