How to copy one table?

[Sleep Mode]

Hi :) I want to copy one of my table in one of my database to another database. Is there a function or way to do it? Thank you...

[william232]

well there is one way of doing is using the join table sql function other than that if you want to copy the table you want click the table go to export and select your export method i suggested sql then click on go it do a sql query for you just for that table where you can place it into another table depending on if the other fields have anythign in them of not it also includes the values in the fields aswell :)

feel free to come back here and ill ask your questions you may have :)

[Sleep Mode]

thank you for your answer william. i dont use ms access or any other sql softwares. i use mysql. and i should copy a table to another database with the same name with a code. because in my system, when i click the button, this will happen. it will just copy my table from my database to another database that i know the ip number of. how can i do it?

[william232]

do your host have php my admin if so use that other than that you can install it on your account.

[Sleep Mode]

yes my host have it but as i said, i will not do it by manually. it should be done automatically, because i will not use this program. The people will use this program, do not have any idea about php or anything... what are your ideas?

[bokeh]

I'd recommend SQLyog Enterprise (http://webyog.com/) for this.