[RESOLVED] truncate table

robkir

I am creating an on the fly table -- I can't seem to get truncate to work. What am I missing here?

$sql = "TRUNCATE TABLE sortOrder";

  mysqli_query($cxn, $sql);

thanks,

robkir

johanafm

Not sure what "an on the fly table" would be, or in what way truncate fails to work.

But what do you have, what are you expecting and what actually happens?

bradgrafelman

Is this table only going to be used for the current execution of the script? In other words, should you perhaps be using a TEMPORARY table instead?

robkir

bradgrafelman;11036167 wrote:
Is this table only going to be used for the current execution of the script? In other words, should you perhaps be using a TEMPORARY table instead?

The temporary table seems like the ticket...but of course, I can't get it to work. I have admin rights to use it, but maybe I've code wrong...?

$maketemp = "
CREATE TEMPORARY TABLE eraseMe (
sortOrder int NOT NULL,
field varchar(2),
site varchar(2),
timeGame varchar(10),
tourn_ID varchar(2)) ";

mysqli_query($cxn, $maketemp) or die ("Sql error : ".mysqli_error($cxn));

bradgrafelman

What makes you say that you "can't get it to work?" Are you getting an error when you execute that SQL statement?

Derokorian

What do you mean you can't get it to work? What is not working? What do you expect to get, and what do you get in return? Given the 2 lines of code you gave I see no reason it shouldn't work.

bradgrafelman

I'll also point out that it might make sense to only use a temporary table for a "one-off" sort of operation. If you're going to repeatedly do this in the normal course of your application, creating a VIEW might make more sense. We're all just guessing at this point since you've given us little to no information as to the context of this.

robkir

bradgrafelman;11036177 wrote:
What makes you say that you "can't get it to work?" Are you getting an error when you execute that SQL statement?

When you get a new toy and start to play with it...and it doesn't work, you automatically assume its the 'toy' that's broken, instead of the operator. The Temporary Table routine did work, it was the operator (me) who screwed up (bad SELECT statement).

Thank you all for the guidance. I'll check into VIEW, but for right now, Temporary Table works fine.