MySQL CRUD

database

create, show, delete

create database egg;
show databases;
drop database egg;

table

enter database, create, show all tables and table structure, delete

use egg;
create table user(
    id int(10) not null auto_increment,
  name varchar(30) not null default 'admin' comment '用户名',
  pwd varchar(50) not null comment '密码',
  primary key(id)
)engine=InnoDB charset=utf8;
show tables;
desc user;
drop table user;

row/record

create, read, update, delete

insert into user values(1, 'sean', '123');
insert into user(name, pwd) values('silva, '345');
select * from user;
select id, name from user;
select * from user where id = 1;
update user set pwd = 'xxx' where id = 1;
delete from user where id = 2;