首页 > 代码库 > SQL的学习
SQL的学习
create database hpf; use hpf; create table hdfdf ( id int(10) NOT null auto_increment, uid varchar(10) not null default 0, remark text null, primary key (id) ) show tables; select * from hdfdf; select id as idenfiy from hdfdf; select * from test where id!=1; select * from test where id<>1; select * from test where id in (1,2); select * from test where id not in (1,2); select * from test where id between 1 and 3; select * from test where id not between 1 and 3; select * from test where id=1 and remark="学生"; select * from test group by remark; select * from test order by regdate (asc\desc); select * from test limit 0,3; select * from test ; select count(*) as num from test; select max(id) as num from test; select min(id) from test; select avg(id) from test; select sum(id) from test; select * from test where uid like '%王%'; alter table hdfdf drop remark; alter table hdfdf add remark text null after id; alter table hdfdf add name varchar(20) null; insert into test (uid,regdate,remark) values (5,now(),'老师'); update test set uid='万网' where id=5; delete from test where id=6 create table message( id tinyint(1) not null auto_increment, user varchar(25) not null, title varchar(50) not null, content tinytext not null, lastdate date not null, primary key (id) )engine=InnoDB default charset=gbk auto_increment=1; select * from message;
SQL的学习
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。