Drop, Clear Tables/Fields
Posted 28 May 2006 - 08:39 PM
Is there a way to set up a query to DROP table1, table2, table3, table3 or SELECT * FROM table4 DELETE.
Anything similar to those would be great.
Posted 28 May 2006 - 09:07 PM
Posted 28 May 2006 - 09:13 PM
You can always call a TRUNCATE TABLE statement if you want to empty the table out -- it's faster than DELETE anyway. Same goes for DROP. But I don't know what you mean by PHP code -- it's just a MySQL statement that you need to issue via the DB layer.
Well, I'm using php right. So say I have a file called 'Clear.php' with a submit button on it, I'd like that post action to truncate and drop some tables.
Posted 29 May 2006 - 01:09 AM
OK -- still, it's just issuing commands; you can write whatever wrapper you desire.
I don't mean to sound beliggerent, but I just started using PHP the day I registered with this forum. I tried searching for the syntax to do that, but I have no idea.
Thanks anyways .
Posted 29 May 2006 - 07:18 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users