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 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
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
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
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
]
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/Eastern, Marco Tabini wrote:
where is a reserved
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
(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 fine on my
-
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 fine.
thanks!
Jule
On Tuesday, Nov 5, 2002
9 matches
Mail list logo
