mySQL之库、表、记录增删改查

针对库，表，记录的增删改查

1.数据库：

create database db1;
drop database db1;
alter database db1 charset utf8;
show databases;
show create database db1;
#use db1;

2.表

create table t1(id int,name varchar(10));
drop table t1;
alter table t1 modify name char(10);
show create table t1;
#desc t1;

3.记录

insert into t1(id,name) values(1,’quincy1’),(2,’quincy2’);
delete from t1 where id=1;
update t1 set id=100 where id=1;
select * from t1;