Guest User

Untitled

a guest
Jun 25th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.98 KB | None | 0 0
  1. Ошибка
  2.  
  3. SQL-запрос:
  4.  
  5. DELIMITER;
  6.  
  7. /*2*//*script createfunc_getUserSess.sql*//*Функция возвращает пользователя работавшего в сессию, которая работала в момент времени dttm*/ DROP FUNCTION IF EXISTS getUserSess;
  8.  
  9. CREATE FUNCTION getUserSess(
  10. dttm INTEGER( 10 )
  11. ) RETURNS VARCHAR( 100 ) DETERMINISTIC RETURN IFNULL( (
  12. SELECT u.name
  13. FROM sessions s
  14. JOIN users u ON u.userid = s.userid
  15. WHERE s.lastaccess = (
  16.  
  17. SELECT MIN( lastaccess )
  18. FROM sessions
  19. WHERE lastaccess >= dttm )
  20. LIMIT 1
  21. ), "Default"
  22. );
  23.  
  24. /*3*//*script evg_#_2010_08_10.final.sql*//*Старый нужный скрипт*/DELIMITER | DROP FUNCTION IF EXISTS get_target_event |
  25.  
  26. Ответ MySQL:
  27. #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))
  28. RETURNS varchar(100) DETERMINISTI' at line 5
Add Comment
Please, Sign In to add comment