MySQL Forums
Forum List  »  Events (Job Scheduler)

ERRORS
Posted by: Sherif Sayed
Date: August 31, 2007 07:42PM

every time i write any thing include event word i face an errors
such as this errors

mysql> SHOW EVENTS\G
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corr
esponds to your MySQL server version for the right syntax to use near 'EVENTS' at li
ne 1
-----------------

mysql> SET GLOBAL event_scheduler = ON;
ERROR 1193 (HY000): Unknown system variable 'event_scheduler'
mysql> CREATE TABLE `EVENTS`;
ERROR 1109 (42S02): Unknown table 'events' in information_schema
mysql> CREATE TABLE `EVENTS`;
ERROR 1109 (42S02): Unknown table 'events' in information_schema
-----------------

mysql> SHOW EVENTS\G
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corr
esponds to your MySQL server version for the right syntax to use near 'EVENTS' at li
ne 1
------------------
mysql> SHOW VARIABLES LIKE '%events%';
Empty set (0.00 sec)
------------------

and this is the information_schema tables

mysql> SHOW tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| KEY_COLUMN_USAGE |
| PROFILING |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
17 rows in set (0.00 sec)

i'm using

mysql-essential-5.0.45-win32

hope some one can help me

Options: ReplyQuote


Subject
Views
Written By
Posted
ERRORS
13420
August 31, 2007 07:42PM
5729
September 13, 2007 10:01AM
4691
February 15, 2008 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.