On Wed, Feb 21, 2001 at 10:58:27PM +0100, Ramiro Radjiman wrote:
> the following code repeats saying ERORR : cannot execute query.
> if i delete the text IF NOT EXISTS al goes good.
> I don't understand why.
Check the version of mysql you are using. From the manual:
In MySQL Version 3.23 or later, you can use the keywords IF NOT EXISTS
so that an error does not occur if the table already exists.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
--
Jason Stechschulte
[EMAIL PROTECTED]
--
The way these things go, there are probably 6 or 8 kludgey ways to do
it, and a better way that involves rethinking something that hasn't
been rethunk yet.
-- Larry Wall in <[EMAIL PROTECTED]>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
