#1
  1. No Profile Picture
    fantom
    Guest
    Devshed Newbie (0 - 499 posts)
    Hey everyone...

    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
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    drop if exists tablename;
  4. #3
  5. No Profile Picture
    fantom
    Guest
    Devshed Newbie (0 - 499 posts)
    That's the one!

Similar Threads

  1. Large tables or many small tables?
    By Tassadar356 in forum MySQL Help
    Replies: 4
    Last Post: February 8th, 2004, 01:07 PM
  2. tables get corrupted
    By 90coders in forum MySQL Help
    Replies: 1
    Last Post: December 5th, 2003, 05:23 AM
  3. Replies: 0
    Last Post: October 15th, 2003, 08:02 PM
  4. Synchronizing 2 tables with different field structure
    By nickcwj in forum Database Management
    Replies: 0
    Last Post: October 15th, 2003, 07:55 PM
  5. 3 tables overlapping help (CSS / Javascript)
    By static07 in forum JavaScript Development
    Replies: 2
    Last Post: September 4th, 2003, 06:40 AM

IMN logo majestic logo threadwatch logo seochat tools logo