全部博文（471）
发布时间：2014-08-06 08:54:42
1.loop-loop嵌套CREATE PROCEDURE hxl.sp_loop_loop()BEGIN DECLARE l_class_id int; DECLARE l_class_name varchar(20); DECLARE l_student_id int; DECLARE l_student_name varchar(20); DECLARE done int; DECLARE cur_out CURSOR FOR SELECT &nb.........【阅读全文】
发布时间：2014-07-24 17:55:19
SELECT a.* FROM score a WHERE ( SELECT COUNT(*) FROM score WHERE class = a.class .........【阅读全文】
发布时间：2014-07-22 10:54:21
mysql执行多表查询时报错：Sql代码 [SQL] SELECT * from ( select e.account from employee e UNION SELECT u.account from `user`.........【阅读全文】
发布时间：2014-07-16 20:50:44
SELECT FROM_UNIXTIME(1404814676372/1000)2014-07-08 18:17:56SELECT NOW()2014-07-16 20:46:28SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')2014-07-16......【阅读全文】
发布时间：2014-06-20 19:30:11
select * from table where name not like '%aa%'......【阅读全文】
