sql 的增删改查
数据库
mysql -u root -p
>show databases
>use security
>create database employees charset utf8;
>drop database employees;
use employees;
数据表
create table employee
->(
->id int
->name varchar(40),
->sex char(4),
->birthday date,
->job varchar(100)
->);
>show full columns from employee;
>select * from employee;
>drop table employee;
>rename table employee to user;
>alter table user character set utf8;
数据列和数据行
->insert into user
->(
->id,name,sex,birthday,job)
->values
->(
->1,'ctfstu','male','1999-05-06','it')
->;
insert into user (id,name,sex,birthday,job)
values(1,'ctfstu','male','1999-05-06','it')
>alter table user add salary decimal(8,2);
>update user set salary=5000;
>update user set name='benben' where id=1;
>update user set name='benben2',salary=3000 where id=1;
>alter table user drop salary;
>delete from user where job='it';
>delete from user;