Posted by Andy Jeffries on 05/17/06 22:51

On Wed, 17 May 2006 12:26:56 -0700, Jessica Parker wrote:
> "No, it's certainly not. I've use it as the name of the autoincrement
> field on hundreds of tables over the years..."
>
> I know you can use it, but I thought you have to put the tick marks around
> it.

Nope.

> I use it as the primary key all the time, but I've had problems in the
> past when I do just "SELECT id" rather than "SELECT `id`"

What problems? Can you reproduce them now? That way we can see what the
error is and find out what was happening in your case.

> Could this be MySQL related?

Certainly not here:

mysql> select id from test;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)


Cheers,


Andy

--
Andy Jeffries MBCS CITP ZCE | gPHPEdit Lead Developer
http://www.gphpedit.org | PHP editor for Gnome 2
http://www.andyjeffries.co.uk | Personal site and photos

[Back to original message]