摘要：权限问题，授权 给 root 所有sql 权限 mysql> grant all privileges on *.* to root@"%" identified by ".";Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Q 阅读全文

摘要：1 drop PROCEDURE IF EXISTS AddIsDoliday ; 2 CREATE PROCEDURE AddIsDoliday() 3 BEGIN 4 IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 't_f... 阅读全文

摘要：BEGIN DECLARE l_acode INT DEFAULT 0; -- SET @len = length(carplate); IF (@len = 0) THEN RETURN 0; END IF; SET l_acode = ascii(carplate); IF (l_acode >= 124) THEN RETURN 1; ... 阅读全文