Reserved words usage in MySQL

 property name="hibernate.globally_quoted_identifiers" value="true"
 

So what are the symptoms?

 mysql> CREATE TABLE interval (begin INT, end INT);
 ERROR 1064 (42000): You have an error in your SQL syntax ...
 near 'interval (begin INT, end INT)'
 

How can we check for reserved words?

1. Using the list on the corresponding manual page, create a text file with one reserved word on each line
2. Load data into a temporary table

   USE test;
    CREATE TABLE reserved_words VARCHAR(50); 
    LOAD DATA INFILE 'reserved_words.txt' INTO TABLE test.reserved_words;
    

3. Check for any column names using reserved keywords

   SELECT table_schema, table_name, column_name, ordinal_position 
    FROM information_schema.columns
    WHERE table_schema NOT IN ( 'mysql', 'information_schema', 'performance_schema' ) 
    AND column_name = ANY ( SELECT * FROM test.reserved_words ) 
    ORDER BY 1,2,4;

4. Check for any table names using reserved keywords

   SELECT table_schema, table_name
    FROM information_schema.tables
    WHERE table_schema NOT IN ( 'mysql', 'information_schema', 'performance_schema' ) 
    AND table_name = ANY ( SELECT * FROM test.reserved_words );

5. Check for any procedures or functions

    SELECT routine_schema, routine_name, routine_type
    FROM information_schema.routines
    WHERE routine_schema NOT IN ( 'mysql', 'information_schema', 'performance_schema' )
    AND routine_name = ANY ( select * from test.words );