FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


HomeWatched TopicsRegisterSearchDirectory
FAQMemberlistUsergroupsLog inStoresItemsBank
Google

Reply to topic Page 1 of 1
what to do to copy[triple] a table in phpmyadmin
Message  

Reply with quote
Post what to do to copy[triple] a table in phpmyadmin 
what to do to copy[triple] a table['land' to 'villas' to 'apts'] in phpmyadmin, not the contains ?

CREATE TABLE `land` (
`photourl` VARCHAR( 40 ) NULL ,
`id` VARCHAR( 5 ) NOT NULL ,
`name` VARCHAR( 40 ) NOT NULL ,
`priceeuro` DECIMAL( 9, 2 ) NULL ,
`pricecyp` DECIMAL( 9, 2 ) NULL ,
`beds` VARCHAR( 1 ) NULL ,
`description` VARCHAR( 500 ) NULL ,
`location` VARCHAR( 20 ) NULL ,
`area` VARCHAR( 20 ) NULL ,
`detailsurl` VARCHAR( 40 ) NULL
) ENGINE = MYISAM COMMENT = 'Land for sale in Pafos';

View user's profile Send private message

Reply with quote
Post  
having created your table click on it on the left menu. Then click on "operations" menu item on the top menu. On the page you will find:

Copy table to:

select the database where you want to copy your table, and a new name for it. Select 'data only' and "Go"

Regards,
Tim.


_________________
www.eb-downloads.com
FREE E-BOOKS DOWNLOADS.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger

Reply with quote
Post  
Error
The additional features for working with linked tables have been deactivated. To find out why click here.
PMA Database ... not OK[ Documentation ]
General relation features Disabled


this appear when I proceed ...?

Code:
CREATE TABLE `landaptsvillas` (
`priceeuro` DECIMAL( 9, 2 ) NULL ,
`pricecyp` DECIMAL( 9, 2 ) NULL ,
`name` VARCHAR( 40 ) NULL ,
`id` VARCHAR( 5 ) NULL ,
`area` VARCHAR( 25 ) NULL ,
`location` VARCHAR( 25 ) NULL ,
`beds` SET( 'any', '1', '2', '3', '4', '+5', 'NA' ) NULL ,
`photourl` VARCHAR( 20 ) NULL ,
`detailsurl` VARCHAR( 20 ) NULL ,
`description` VARCHAR( 500 ) NULL
) ENGINE = MYISAM COMMENT = 'TABLE FOR PROPERTY SEARCH PL';


View user's profile Send private message

Reply with quote
Post how copy a table using SQL code ? 
how  copy a table using SQL code ?

View user's profile Send private message
Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  



Google

FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


Web Design by PlatinumShore.com & Web Hosting by TradeWebHosting.com