选择时获取列的名称

Question

I have select code like this:

mysql_query('
  SELECT id, date, ip, page, get, referer 
  FROM iplog ORDER BY id DESC
');

My problem is, name of column called get causes error.

When I change column name in both here and in database, error is gone. Any ideas?

Answer 1

Use backquotes for reserved words (or names with characters like spaces):

SELECT id, date, ip, page, `get`, referer FROM iplog ORDER BY id DESC

get is a reserved word in MySQL 5.7. The list is here. It starts appearing as a reserved word in MySQL 5.6.