2019 九月 21 , 星期六
Home / 2018 / 十月

Monthly Archives: 十月 2018

mysql 批量建表 存储过程

delimiter // CREATE procedure create_table() BEGIN DECLARE `@i` int(11); DECLARE `@sqlstr` varchar(65000); SET `@i`=0; WHILE `@i` < 256 DO SET @sqlstr = CONCAT( “CREATE TABLE box_item_pool_”, `@i`, “( `id` int(10) unsigned NOT NULL ...

Read More »