![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 4220 阅读 · 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 · 3901 阅读 · 0 评论