久しぶりに db いじってたら mysql (mariadb) の予約語にはまった

先日，LINE Message API がどうのこうのって blog を書きましたが，その関係(?)のはなし．

LINE Message API をハンドリングするために，何気なく lines って db 作ったら，lines って単語は mysql の予約語だったのね．まったく動作しないからちょっと悩んでしまった．

よくよく考えれば構文で使う単語から判る話だけど，最近は直接 SQL を書くことが少なくなったからなぁ．

ドキュメント的には https://dev.mysql.com/doc/refman/5.6/ja/reserved-words.html あたりに予約語の説明があります．

一応，自分用のメモとして一覧を転載．

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | R | S | T | U | V | W | X | Y | Z

A

• ACCESSIBLE

• ADD

• ALL

• ALTER

• ANALYZE

• AND

• AS

• ASC

• ASENSITIVE

B

• BEFORE

• BETWEEN

• BIGINT

• BINARY

• BLOB

• BOTH

• BY

C

• CALL

• CASCADE

• CASE

• CHANGE

• CHAR

• CHARACTER

• CHECK

• COLLATE

• COLUMN

• CONDITION

• CONSTRAINT

• CONTINUE

• CONVERT

• CREATE

• CROSS

• CURRENT_DATE

• CURRENT_TIME

• CURRENT_TIMESTAMP

• CURRENT_USER

• CURSOR

D

• DATABASE

• DATABASES

• DAY_HOUR

• DAY_MICROSECOND

• DAY_MINUTE

• DAY_SECOND

• DEC

• DECIMAL

• DECLARE

• DEFAULT

• DELAYED

• DELETE

• DESC

• DESCRIBE

• DETERMINISTIC

• DISTINCT

• DISTINCTROW

• DIV

• DOUBLE

• DROP

• DUAL

E

• EACH

• ELSE

• ELSEIF

• ENCLOSED

• ESCAPED

• EXISTS

• EXIT

• EXPLAIN

F

• FALSE

• FETCH

• FLOAT

• FLOAT4

• FLOAT8

• FOR

• FORCE

• FOREIGN

• FROM

• FULLTEXT

G

• GET

• GRANT

• GROUP

H

• HAVING

• HIGH_PRIORITY

• HOUR_MICROSECOND

• HOUR_MINUTE

• HOUR_SECOND

I

• IF

• IGNORE

• IN

• INDEX

• INFILE

• INNER

• INOUT

• INSENSITIVE

• INSERT

• INT

• INT1

• INT2

• INT3

• INT4

• INT8

• INTEGER

• INTERVAL

• INTO

• IO_AFTER_GTIDS

• IO_BEFORE_GTIDS

• IS

• ITERATE

J

• JOIN

K

• KEY

• KEYS

• KILL

L

• LEADING

• LEAVE

• LEFT

• LIKE

• LIMIT

• LINEAR

• LINES

• LOAD

• LOCALTIME

• LOCALTIMESTAMP

• LOCK

• LONG

• LONGBLOB

• LONGTEXT

• LOOP

• LOW_PRIORITY

M

• MASTER_BIND

• MASTER_SSL_VERIFY_SERVER_CERT

• MATCH

• MAXVALUE

• MEDIUMBLOB

• MEDIUMINT

• MEDIUMTEXT

• MIDDLEINT

• MINUTE_MICROSECOND

• MINUTE_SECOND

• MOD

• MODIFIES

N

• NATURAL

• NOT

• NO_WRITE_TO_BINLOG

• NULL

• NUMERIC

O

• ON

• OPTIMIZE

• OPTION

• OPTIONALLY

• OR

• ORDER

• OUT

• OUTER

• OUTFILE

P

• PARTITION

• PRECISION

• PRIMARY

• PROCEDURE

• PURGE

R

• RANGE

• READ

• READS

• READ_WRITE

• REAL

• REFERENCES

• REGEXP

• RELEASE

• RENAME

• REPEAT

• REPLACE

• REQUIRE

• RESIGNAL

• RESTRICT

• RETURN

• REVOKE

• RIGHT

• RLIKE

S

• SCHEMA

• SCHEMAS

• SECOND_MICROSECOND

• SELECT

• SENSITIVE

• SEPARATOR

• SET

• SHOW

• SIGNAL

• SMALLINT

• SPATIAL

• SPECIFIC

• SQL

• SQLEXCEPTION

• SQLSTATE

• SQLWARNING

• SQL_BIG_RESULT

• SQL_CALC_FOUND_ROWS

• SQL_SMALL_RESULT

• SSL

• STARTING

• STRAIGHT_JOIN

T

• TABLE

• TERMINATED

• THEN

• TINYBLOB

• TINYINT

• TINYTEXT

• TO

• TRAILING

• TRIGGER

• TRUE

U

• UNDO

• UNION

• UNIQUE

• UNLOCK

• UNSIGNED

• UPDATE

• USAGE

• USE

• USING

• UTC_DATE

• UTC_TIME

• UTC_TIMESTAMP

V

• VALUES

• VARBINARY

• VARCHAR

• VARCHARACTER

• VARYING

W

• WHEN

• WHERE

• WHILE

• WITH

• WRITE

X

• XOR

Y

• YEAR_MONTH

Z

• ZEROFILL

• GET

• IO_AFTER_GTIDS

• IO_BEFORE_GTIDS

• MASTER_BIND

• PARTITION

あんまり内容がない話だけど，そんな感じで．