MySQL Forums
Forum List  »  MySQL Workbench

merging tables with sql
Posted by: Steven B
Date: February 01, 2009 01:10AM

If I want to make two tables into one, isn't there any easy way to do this?

I tried taking the sql from both tables and mrging the sql into one create statement. It imports without error using Import => Reverse Engineer but the table is never created.

CREATE TABLE IF NOT EXISTS `stellar`.`orderdetail` (
`id` INT(13) NOT NULL AUTO_INCREMENT ,
`idord` INT(13) NOT NULL ,
`name` VARCHAR(100) NOT NULL DEFAULT '' ,
`credentails` VARCHAR(200) NOT NULL DEFAULT '' ,
`phone` VARCHAR(20) NOT NULL DEFAULT '' ,
`email` VARCHAR(255) NOT NULL DEFAULT '' ,
`image` VARCHAR(255) NOT NULL DEFAULT '' ,
`ageMin` TINYINT(4) NOT NULL DEFAULT '0' ,
`ageMax` TINYINT(4) NOT NULL DEFAULT '0' ,
`incomeMin` INT(8) NOT NULL DEFAULT '0' ,
`incomeMax` INT(8) NOT NULL DEFAULT '0' ,
PRIMARY KEY (`id`) )
ENGINE = MyISAM

Options: ReplyQuote


Subject
Views
Written By
Posted
merging tables with sql
2497
February 01, 2009 01:10AM


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.