sql create part of software problem
i am using mysql migration software to upload a table of data to a server.
When i go through the steps it produces two sections of code within the software that can be edited the first is.
CREATE DATABASE IF NOT EXISTS `craig_Database1`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `craig_Database1`;
This is for the database itself then the table section is
DROP TABLE IF EXISTS `craig_Database1`.`Craig_songlyrics2`;
CREATE TABLE `craig_Database1`.`Craig_songlyrics2` (
`Field2` VARCHAR(255) NULL,
`Field3` VARCHAR(255) NULL,
`Field4` VARCHAR(255) NULL,
`Field5` VARCHAR(255) NULL,
`Field6` VARCHAR(255) NULL,
`Field7` VARCHAR(255) NULL,
`Field8` VARCHAR(255) NULL,
`Field9` LONGTEXT NULL,
`Field10` VARCHAR(255) NULL,
`Field11` VARCHAR(255) NULL
)
ENGINE = INNODB;
Each time is use the software it will delete the previous data and upload the data in the database on my computer only.
what i want to do is update the data on the server with fresh data from teh database on my computer and not delete the records on the sql server all ready.
Can any one help
Thanks :-)
Craig
Subject
Written By
Posted
sql create part of software problem
March 18, 2009 05:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.