07 2022 档案
摘要：MYSQL在创建一个带有自增主键ID的表时，通常在删除数据时，导致自增主键不连续了。使用下面的SQL脚本可以重置主键。 -- 1、重置已有数据主键 SET @rownum = 0; UPDATE table_name SET id = @rownum := @rownum +1; -- 2、修改自增
阅读全文
摘要：# a = %{ # "mami" => ["a", "d"], # "star" => ["c", "b"]} # b = %{"a" => "1", # "b" => ["2","3","4"], # "c" => ["5","6"], # "d"
阅读全文
