MySQL
zhangketuan
这个作者很懒,什么都没留下…
展开
-
mysql insert_select ID 自增长
insert into player_equipment (id,player_id,equipment_id,equipment_num)select @i:=@i+1 as id, t.* from(select 1,t.id,100 from s_car_equipment t) t ,(SELECT @i :=(select ifnull(max(a.id),0) from pl转载 2015-12-17 18:31:42 · 4232 阅读 · 0 评论 -
快速对Mysql添加索引的五个方法
1.添加PRIMARY KEY(主键索引)mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )2.添加UNIQUE(唯一索引)mysql>ALTER TABLE `table_name` ADD UNIQUE (`column`)3.添加INDEX(普通索引)mysql>A转载 2016-01-25 14:26:57 · 3913 阅读 · 0 评论