Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Ошибка
- SQL-запрос:
- DELIMITER;
- /*2*//*script createfunc_getUserSess.sql*//*Функция возвращает пользователя работавшего в сессию, которая работала в момент времени dttm*/ DROP FUNCTION IF EXISTS getUserSess;
- CREATE FUNCTION getUserSess(
- dttm INTEGER( 10 )
- ) RETURNS VARCHAR( 100 ) DETERMINISTIC RETURN IFNULL( (
- SELECT u.name
- FROM sessions s
- JOIN users u ON u.userid = s.userid
- WHERE s.lastaccess = (
- SELECT MIN( lastaccess )
- FROM sessions
- WHERE lastaccess >= dttm )
- LIMIT 1
- ), "Default"
- );
- /*3*//*script evg_#_2010_08_10.final.sql*//*Старый нужный скрипт*/DELIMITER | DROP FUNCTION IF EXISTS get_target_event |
- Ответ MySQL:
- #1064 - You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'CREATE FUNCTION getUserSess (dttm INTEGER(10))
- RETURNS varchar(100) DETERMINISTI' at line 5
Add Comment
Please, Sign In to add comment