Re: Why?
| From: | Jason Wong | Date: | Mon, 21 Oct 2002 06:45:38 +0000 |
| Subject: | Re: Why? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120699@lists.php.net to get a copy of this message | ||
On Monday 21 October 2002 01:46, John W. Holmes wrote:
> > I'm not having this problem or anything but exactly why does MySQL not
> > like a section in a table called key? I tried using one to store a key
> > code but whenever I tried to access it, it wouldn't work. I just
>
> changed
>
> > the name to code and it worked.
>
> It's a reserved word. For PRIMARY KEY.
If you insist on using reserved words, you can wrap it in backticks:
key
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
loop found in loop in redundant loopback
*/