query_init:
    CREATE DATABASE IF NOT EXISTS db1 ; CREATE DATABASE IF NOT EXISTS db2 ;

query:
      create_table | drop_table |
      create_procedure | drop_procedure | call_procedure |call_procedure |
       character_set ;

create_table:
       CREATE TABLE IF NOT EXISTS db1.table_name (table_cols)
       ENGINE = storage_engine |
       CREATE TABLE IF NOT EXISTS db2.table_name (table_cols)
       ENGINE = storage_engine ;

storage_engine:  Myisam | Innodb | Falcon ;

table_cols: one_col | two_col | three_col ;

one_col: column_definition ;

two_col: column_definition,
         column_definition ;

three_col: column_definition,
           column_definition,
           column_definition ;

column_definition: new_column data_type column_option ;

new_column: c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 ;

data_type: INT | CHAR(255) | TINYINT | VARCHAR(255) | SMALLINT | BIGINT | TIME
| YEAR | TIMESTAMP | DATETIME | DATE | TEXT | BLOB ;

column_option: NULL | NOT NULL ;

table_name:
            t1 | t2 | t3 | t4 | t5 | t6 | t7 | t8 | t9 | t10 ;

drop_table:
        DROP TABLE IF EXISTS db1.table_name |
        DROP TABLE IF EXISTS db2.table_name ;

create_procedure:
        CREATE PROCEDURE db1.procedure_name () SET @pro=10 |
        CREATE PROCEDURE db2.procedure_name () SET @pro=100 ;

procedure_name:
        letter ;

drop_procedure:
        DROP PROCEDURE IF EXISTS db1.procedure_name |
        DROP PROCEDURE IF EXISTS db2.procedure_name ;

call_procedure:
        CALL db1.procedure_name |
        CALL db2.procedure_name ;

character_set:
        SET CHARACTER_SET_CLIENT=cset | SET CHARACTER_SET_CONNECTION=cset | SET CHARACTER_SET_DATABASE=cset | SET CHARACTER_SET_FILESYSTEM=cset | SET CHARACTER_SET_RESULTS=cset | SET CHARACTER_SET_SERVER=cset | SET COLLATION_CONNECTION=coll | SET COLLATION_DATABASE=coll | SET COLLATION_SERVER=coll ;

cset: LATIN1 | LATIN2 | LATIN5 | LATIN7 | SWE7 | BIG5 | EUCJPMS | GB2312 | ARMSCII8 | CP932 | UTF8 ;

coll: LATIN1_SWEDISH_CI | LATIN2_GENERAL_CI | LATIN5_TURKISH_CI | LATIN7_GENERAL_CI | SWE7_SWEDISH_CI | BIG5_CHINESE_CI | EUCJPMS_JAPANESE_CI | GB2312_CHINESE_CI | ARMSCII8_GENERAL_CI | CP932_JAPANESE_CI | UTF8_SPANISH_CI ;