sql create part of software problem
Posted by: craig hodges
Date: March 18, 2009 05:08PM

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

Options: ReplyQuote


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.