|
|
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
Navigation:
[Reply to this message]
|