Home >Database >Mysql Tutorial >mysql发生行号
mysql发生行号
- WBOYOriginal
- 2016-06-07 16:25:301062browse
mysql产生行号 mysql产生行号： set @n = 0;update tbl_material_stone a, (select stone_id,@n:=@n+1 r from tbl_material_stone order by stone_id) b set no = r where a.stone_id =b.stone_id; ?
mysql产生行号mysql产生行号：
set @n = 0; update tbl_material_stone a, (select stone_id,@n:=@n+1 r from tbl_material_stone order by stone_id) b set no = r where a.stone_id =b.stone_id;
?
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 事宜的四种隔离级别Next article：mysql抉择联合索引还是单索引？索引列应该使用哪一个最有效？深