解决方案 »
- mysql使用c接口查询定位
- load数据进去,有索引的表~索引会生效吗?还是要重新建立索引~load命令如下。
- 关于linux下连接mysql的问题
- 请教几个mysql的问题?
- discuz论坛,帖子排序问题
- mysql中text字段的问题。。。
- 数据类型转换(在线等)?
- SOS,有人碰到过MYSQL因停电造到一个表的数据全部被清空的情况吗??
- 簡單問題嗎?在線等待!謝謝!
- mysql里面有没有跟SQL SERVER :select top 3 * from member(top) 这样相同的语法啊
- mysql 表插入数据后,索引值为空,求解
- 使用xampp装的testlink 意外关机后mysql无法启动,怎么把原来testlink里面的数据导到新安装的xampp的testlink里面?
mysql -s -L -e "select concat('delete from ',table_schema,'.',table_name,' where type in (''et'',''md'',''pd'');') from information_schema.tables where table_schema in ('db1','db2','db3'); "
mysql> delimiter //
mysql> drop PROCEDURE p_bluelive//
Query OK, 0 rows affected (0.00 sec)mysql> CREATE PROCEDURE p_bluelive()
-> BEGIN
-> DECLARE done INT DEFAULT 0;
-> DECLARE v_a INT;
-> DECLARE cur1 CURSOR FOR SELECT distinct a FROM t_bluelive;
-> DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
->
-> OPEN cur1;
-> FETCH cur1 INTO v_a;
-> WHILE done=0 DO
-> set @sqlstmt=concat('SELECT a,count(*) as N from t_bluelive wher
e a=',v_a,' INTO OUTFILE \'',v_a,'.txt\'');
-> PREPARE stmt1 FROM @sqlstmt;
-> EXECUTE stmt1 ;
-> DEALLOCATE PREPARE stmt1;
-> FETCH cur1 INTO v_a;
-> END WHILE;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> delimiter ;