I don't think there's anything wrong with the queries themselves. Are
you trying to run them all at once? You're getting an error because
MySQL is reaching a semi-colon somewhere and that's causing a parse
error... Show how you're trying to run all of these queries. Bottom
line, you must do them on
I just tried this in MySQL and it inserted no problem
INSERT INTO c_emotes VALUES (6, ':-)');
Mike
*** REPLY SEPARATOR ***
On 30/12/2002 at 7:14 PM Stephen wrote:
I'm having some troubles. I have an install script which runs a lot of SQL statements
to create tables then i
Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Wednesday, November 06, 2002 1:52 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
apparently 'where' and 'with' are keywords in Java, i've changed them
and now it works
rchar(255) not null ...
---John Holmes...
-Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Tuesday, November 05, 2002 9:43 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
Ah i see, but then why will phpMyAdmin let me use it?
it works fi
apparently 'where' and 'with' are keywords in Java, i've changed them
and now it works fine.
thanks!
Jule
On Tuesday, Nov 5, 2002, at 21:53 US/Eastern, Marco Tabini wrote:
I'm not entirely sure... different configurations perhaps? Have you
verified that that's indeed the problem?
Marco
--
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] sql error
>
> Ah i see, but then why will phpMyAdmin let me use it?
> it works fine on my local db with these names, but on my remote server
> it refuses to create the table.
>
> Jule
>
> On Tuesday, Nov 5, 2002, at 21:47 US/
I'm not entirely sure... different configurations perhaps? Have you
verified that that's indeed the problem?
Marco
---
php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!
On Tue, 5 Nov
2002, Jule Slootbeek
wrote:
> Ah i see, but
Ah i see, but then why will phpMyAdmin let me use it?
it works fine on my local db with these names, but on my remote server
it refuses to create the table.
Jule
On Tuesday, Nov 5, 2002, at 21:47 US/Eastern, Marco Tabini wrote:
"where" is a reserved keyword in SQL--try changing the name of that
"where" is a reserved keyword in SQL--try changing the name of that
column to something else.
Marco
---
php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!
On Tue, 5 Nov
2002, Jule Slootbeek wrote:
> I know this is the wrong mail
9 matches
Mail list logo
