That did it. I really do appreciate all of the help that I received from you
and the list.
Thanks again. :)
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 7:52 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating
Sorry. I can imagine how frustrated you must be.
In mysql 5, condition is a reserved word, so the person who told you to
remove the quotes was wrong, at least for that column. (In his defense,
CONDITION is relevant to stored procedures, so it isn't a reserved word for
versions prior to 5, as
M AUTO_INCREMENT=1 ;
And it still isn't working!!!
WHAT am I doing wrong here?
Thanks again for the help.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 2:05 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help c
Marvin Cummings wrote:
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL auto_
Looks like you are using backticks instead of single quotes on your
column names. You don't really need the quotes on your table name or
column names anyway, so I'd just remove them.
On Tue, 2004-04-06 at 09:29, Marvin Cummings wrote:
>
>
>
> _
>
> From: Marvin Cummings [mailto:[EMAI
Marvin Cummings writes:
>I attempt to create this table from the command line and get the following
>error:
Marvin,
the use of the "'" [single quote] appears to be your problem. I've
been able to create the table on 4.0.18 using the following syntax:
CREATE TABLE nuke_zc_ads
(
ad_id smalli
Hi, the table name and the column names dont have to be inclosed by ' '.
Carlos
Original Message Follows
From: "Marvin Cummings" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Need help creating table...
Date: Tue, 6 Apr 2004 12:29:48 -0400
_
From: Marvin Cummings [mailt
Marvin Cummings wrote:
Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads:
(
`ad_id` smallint(5) unsigned NOT NULL auto_inc