[SOLVED] TRUNCATE TABLE IF EXISTS `Users` - not valid?

[PC Nerd]

Hi,

 

mysql spits out he following error in phpmyadmin:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `Users`' at line 1

 

so...... im assuming from that that the TRUNCATE statement doesnt allow you to place teh "IF EXISTS" with it..... so what can i do as an alternative?

 

Thanks

[MasterACE14]

I'm not entirely sure. But I think you have the query back the front.

IF EXISTS TRUNCATE TABLE `Users`

[PC Nerd]

thanks - but still raises an error.

 

It looks to me that whereever i place the "IF EXISTS" in teh SQL - is where the error starts, which is what broght me to my guess that it doesnt support "IF EXISTS".

 

Thanks though

[PC Nerd]

Ill use:

 

DROP TABLE IF EXISTS `Users` and then CREATE TABLE IF NOT EXISTS `Users` etc etc etc

 

thanks though ( unless you have a better solution);

[ShaunO]

IF OBJECT_ID('Users') IS NOT NULL TRUNCATE TABLE `Users`

[PC Nerd]

ahhh ok - thanks.

[PC Nerd]

IF OBJECT_ID('Users') IS NOT NULL TRUNCATE TABLE `Users`

raises an error for the entire SQL statement.  Any ideas why?

 

[Third_Degree]

you might need

 

IF OBJECT_ID('databasename.Users') IS NOT NULL TRUNCATE TABLE `Users`

[Third_Degree]

you could also consider doing this with php.

[PC Nerd]

well then how woudl i do it in php? - im new to the live creation of tables in SQL - i usually use phpmyadmin

 

Thanks

[Third_Degree]

honestly, all you really need here is:

 

<?php

/*
MySQL Connection Here
*/

$q = @mysql_query( "TRUNCATE TABLE `Users`" );
$result = ( $q ) ? "Table 'Users' does exist, and has been truncated." : "Table 'Users' does not exist";
echo $result;

?>

[PC Nerd]

ok - thanks.... ive ended up just doing a :

DROP TABLE IF EXISTS `name`

CREATE TABLE IF NOT EXISTS `name`

 

and so forth..

 

thanks for all the help.