mysql详解:
索引详解:
sql语句:
数据库:创建、删除
create database name;
drop database dbname;
表: 创建、删除
create table name (name char(20),age int(10));
create table tab_new like tab_old
数据:
增:
新的:
insert into table (姓名,性别)values ('w','男 ');
已有的:
insert into addressList (‘姓名’,'地址') select name,adress from student;
删:
delete
delete from a where name=‘哈哈’;
改:
update
update table set 年龄=18 where 姓名=‘哈哈’;
update table set 性别=‘男’ where 姓名=‘哈哈 ’;
查:
select
select * from table where id='1';
select name as 姓名 from a where gender=‘男’
select name from a where email is null
排序:
order by desc/asc
模糊查询:
like