摘要:
第一次测试执行下面的语句时发生如下错误:bigdata里面有100万条数据mysql> select count(*) from (select distinct(id) from bigdata) as total;ERROR 1317 (70100): Query execution was i... 阅读全文
摘要:
创建测试表:mysql> create table bigdata (id int,name char(2));创建存储过程:mysql> delimiter //mysql> create procedure rand_data(in num int)-> begin-> declare str ... 阅读全文