ysj_121的博客

-- 生成个函数 DELIMITER # CREATE PROCEDURE insert_10000() BEGIN DECLARE i INT DEFAULT 1 ; WHILE i <= 10 DO INSERT INTO tmp_test_ids (`id`) values(i) ; SET i = i + 1 ; END WHILE ; COMMIT ; END # call insert_100...

日期字段添加/减掉时间 date_sub( stime, INTERVAL 2 MINUTE ) AS expiretime date_add( stime, INTERVAL 2 MINUTE ) AS expiretime date_sub( NOW(), ...