Online Suche im Handbuch

28.27 Ist MySQL empfindlich bei reservierten Worten ?

Der Parser bei MySQL kann die Syntax nur dann korrekt erkennen, wenn bestimmte Ausdrücke für SQL reserviert bleiben:

action          add             all             alter           after
and             as              asc             auto_increment  between
bigint          bit             binary          blob            bool 
both            by              cascade         char            character 
change          check           column          columns         constraint 
create          cross           current_date    current_time    current_timestamp 
data            database        databases       date            datetime 
day             day_hour        day_minute      day_second      dayofmonth 
dayofweek       dayofyear       dec             decimal         default 
delete          desc            describe        distinct        distinctrow 
double          drop            escaped         enclosed        enum 
explain         exists          fields          first           float 
float4          float8          foreign         from            for 
full            function        grant           group           having
hour            hour_minute     hour_second     ignore          in 
index           infile          insert          int             integer 
interval        int1            int2            int3            int4 
int8            into            join            key             keys 
last_insert_id  leading         left            like            lines 
limit           load            lock            long            longblob 
longtext        low_priority    match           mediumblob      mediumtext
mediumint       middleint       minute          minute_second   month 
monthname       natural         numeric         not             null 
on              option          optionally      or              order 
outer           outfile         partial         password        precision 
primary         procedure       processlist     privileges      quarter 
read            real            references      rename          regexp
reverse         repeat          replace         restrict        returns 
rlike           second          select          set             show 
smallint        soname          sql_big_tables  sql_big_selects sql_select_limit 
sql_low_priority_updates        sql_log_off     sql_log_update  straight_join 
starting        status          string          table           tables 
terminated      text            time            timestamp       tinyblob 
tinytext        tinyint         trailing        to              use 
using           unique          unlock          unsigned        update 
usage           values          varchar         variables       varying 
varbinary       with            write           where           year 
year_month      zerofill 

Einige Ausdrücke werden sehr gerne verwendet, hier also noch eine Auswahl aus den obigen Ausdrücken, die nicht verwendet werden dürfen:

      ACTION 
      BIT 
      DATE 
      ENUM 
      NO 
      TEXT 
      TIME 
      TIMESTAMP 

Online Suche im Handbuch