JIANDANQINXINILOVEYO的专栏

mysql触发器     drop trigger if exists tg_bb_insert; delimiter $$ create trigger tg_bb_insert before insert on bb FOR EACH ROW BEGIN declare ishave int; select 1 into ishave from cc ...

  MySQL server has gone away    2013. Lost connection to MySQL server during query   官网分析其原因及解决办法：     http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

    delimiter $$ DROP FUNCTION IF EXISTS `getFloor`$$ CREATE FUNCTION getFloor(message VARCHAR(255)) RETURNS INT BEGIN DECLARE floor INT; DECLARE b INT; DECLARE e INT; DECLARE s VARCHAR(2...

因为在自定义函数中limit后面不支持写变量，也不支持动态sql，所以只能写一个存储过程。 [b]getID：[/b] [code="sql"] delimiter $$ DROP PROCEDURE IF EXISTS `getID`$$ CREATE PROCEDURE getID(IN appID INT, IN tID INT, IN floor INT) BEGIN ...