数据库的操作:创建、查看、修改、删除
create、show、alter、drop
create database db_name;
show databases;
show create database db_name;
alter database db_name character set utf8;
drop database db_name;
表的操作:创建、查看、修改、删除
create、show、alter、drop
create table tb_name(
field1 datatype1,
fieldn datatypen
);
show table tb_name;
alter table tb_name add|modify|drop;
drop table tb_name;
表数据的操作:增删查改(CRUD)【create、retrieve、update、delete】
C:insert、R:select、U:update、D:delete
insert into tb_name(field1,fieldn) values(value1,valuen);
select * from tb_table;
update tb_name set field1=expr1 where where_definition;
delete from tb_name where where_definition;