幫我看看這句insert語句有什麼錯?
執行這條語句insert into chinaipv4 (from,to) values ('1.50.0.0','1.50.255.255');
總是提示:
ERROR 1064 (42000): 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 'from,
to) values ('1.50.0.0','1.50.255.255')' at line 1
表結構如下:
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| from | varchar(16) | YES | | NULL | |
| to | varchar(16) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
------解決方案--------------------
MySQL的話這樣
insert into `chinaipv4` (`from`,`to`) values ('1.50.0.0','1.50.255.255');
------解決方案--------------------
from 是 mysql 保留字,挪作他用時需轉義 `from`
------解決方案--------------------
探討
MySQL的話這樣
insert into `chinaipv4` (`from`,`to`) values ('1.50.0.0','1.50.255.255');