Re: php/mysql
| From: | Jason Stechschulte | Date: | Thu, 22 Feb 2001 13:20:41 +0000 |
| Subject: | Re: php/mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6862@lists.php.net to get a copy of this message | ||
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
jpstech@unoh.edu
--
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 <199710221859.LAA24889@wall.org>