November 17th, 2000, 12:13 AM
I just need some help with creating the new tables in mySQL.
I'm trying to create a mysqldump.sql file that will allow me to create a few tables in phpMyAdmin by simply running it as a SQL query, and I have all the "CREATE TABLE...." set up just fine, but I saw this one script that has the option that looks if the table to be created already exists, and if it does then it is overwritten with the one I have stated.
This is a one line code but I just can't remember what it was, so if any of you guys can help me out, I'd really appreciate it
November 17th, 2000, 01:22 AM
drop if exists tablename;
November 17th, 2000, 01:54 AM
That's the one!