+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| occurtime | bigint(20) | | PRI | 0 | |
| deltime | bigint(20) | | PRI | 0 | |
| regioncode | char(2) | | PRI | | |
| areacode | char(2) | | PRI | | |
| sitecode | char(2) | | PRI | | |
| devno | smallint(2) | | PRI | 0 | |
| almcode | char(3) | | PRI | | |
| almsubcode | char(3) | | | 0 | |
| almclass | char(1) | | PRI | | |
+------------+-------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
mysql> INSERT INTO almhistorytbl
-> (ocurrtime,deltime, regioncode, areacode, sitecode,
devno, almcode, almsubcode, almclass)
-> VALUES
-> (1095755341, 1095756032 '01', '05', '01', 2, '801', '0',
'1');
ERROR 1064: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the
right syntax to use near ''01', '05', '01', 2, '801', '0', '1')' at
line 4
어떤 에러인지 알수가 없어서 질문 올립니다.
MYSQL VERSION 은 mysql Ver 12.22 Distrib 4.0.20, for
pc-linux (i686) 입니다.
|