Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. DELIMITER $$
  2.  
  3.  
  4. DROP PROCEDURE IF EXISTS `GTS`.`sp_ClearStatistic`$$
  5. CREATE PROCEDURE `GTS`.`sp_ClearStatistic` ()
  6.  
  7.     COMMENT  'Blanks all Log entrys from the statistic table'
  8.  
  9. BEGIN
  10.  
  11. DELETE FROM statistik
  12.  
  13. END$$
  14.  
  15. DELIMITER ;
  16.  
  17. Executed successfully IN 0.002 s, 0 ROWS affected.
  18. Line 4, COLUMN 1
  19.  
  20. Error code 1064, SQL state 42000: 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 '' at line 9
  21. Line 5, COLUMN 1
  22.  
  23. WHERE IS the failure??
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement