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
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.