Error In MYSQL Help:
#1

Well I Don't know what this mean any help would be good.:

Код:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 12
STR: //
SQL: 
DELIMITER //
CREATE TRIGGER `accounts_insert` BEFORE INSERT ON `accounts`
 FOR EACH ROW BEGIN
SET new.RegiDate = now();
SET new.UpdateDate = now();
END
//


SQL query:

DELIMITER // CREATE TRIGGER `accounts_insert` BEFORE INSERT ON `accounts` FOR EACH ROW BEGIN SET new.RegiDate = now(); SET new.UpdateDate = now(); END //

MySQL said: Documentation
#1142 - TRIGGER command denied to user '11071_hello'@'localhost' for table 'accounts'
Reply


Messages In This Thread
Error In MYSQL Help: - by jasonsmith - 09.09.2013, 11:06
Re: Error In MYSQL Help: - by Vince - 09.09.2013, 11:15

Forum Jump:


Users browsing this thread: 2 Guest(s)