[ic] 'inactive' column name not allowed

[interchange-users@icdevgroup.org (Ed LaFrance)]

At 06:03 PM 11/12/2002 -0800, you wrote:
>Hi all
>
>I just wanted to confirm something.
>
>I had spent a few hours trying to get a couple mysql tables to work. It
>seemed naming a field 'inactive' is a no-no.
>
>I could not do a simple...
>
>WHERE   inactive != 1
>
>However when I changed the field to "status" all works fine....
>
>Is 'inactive' a reserved name? is this an IC thing?
>
>
>Paul

Inactive does not appear to be a MySQL reserved word, but there are many 
others you should be aware of:

http://www.mysql.com/doc/en/Reserved_words.html

- Ed L.

>

===============================================================
New Media E.M.S.              Technology Solutions for Business
463 Main St., Suite D         eCommerce | Consulting | Hosting
Placerville, CA  95667        edl@newmediaems.com
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
===============================================================