> -----Original Message----- > From: David Blomstrom > Sent: Thursday, February 10, 2005 10:06 > To: mysql@lists.mysql.com > Subject: Importing Tables on Top of Tables > > If I revise a MySQL table and try to publish it > online, I often get the error message, "Table my_table > already exists." So I have to delete the online > version before I can import the revised version.
This error comes from issuing a CREATE TABLE when a table with that name already exists. > Is there a way to just publish one table over another, > as long as both have the same name? There are two ways to do this. Issue a DROP TABLE IF EXISTS my_table, before the CREATE TABLE my_table, or you can issue TRUNCATE TABLE my_table and ditch the CREATE TABLE statement. > > Thanks. > --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]