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