vangahi
چهارشنبه 11 اسفند 1389, 00:51 صبح
این SQL وقتی میخوام ایمپورت کنم ارور میده عکس و خود SQL گذاشتم لطفا" اساتید کمک کنند.
Error
SQL query:
DELIMITER $$ CREATE FUNCTION fn_marking_period_seq() RETURNS INT BEGIN INSERT INTO MARKING_PERIOD_ID_GENERATOR
VALUES ( NULL
);
-- DELETE FROM MARKING_PERIOD_ID_GENERATOR;
RETURN LAST_INSERT_ID( ) ;
END$$
MySQL said: http://localhost/phpmyadmin/themes/original/img/b_help.png (http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html)
#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Error
SQL query:
DELIMITER $$ CREATE FUNCTION fn_marking_period_seq() RETURNS INT BEGIN INSERT INTO MARKING_PERIOD_ID_GENERATOR
VALUES ( NULL
);
-- DELETE FROM MARKING_PERIOD_ID_GENERATOR;
RETURN LAST_INSERT_ID( ) ;
END$$
MySQL said: http://localhost/phpmyadmin/themes/original/img/b_help.png (http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html)
#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)