Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving tables between databases

Status
Not open for further replies.
ushtabalakh

ushtabalakh

Programmer
Jun 4, 2007
132
Hi there,
I only have access to my phpmyadmin on a website,
How can I transfer tables from one database to the other? is there any sql command for that in mysql?
 
Sort by date Sort by votes
run this in the SQL tab in phpmyadmin

Code: 
create table database1.tablename
select * from database2.othertablename
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
388
EdLentz
EdLentz
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
540
BobThornton
BobThornton
fryertuk001
  • Locked
  • Question
New tables for each day, week, month
Replies
3
Views
258
spamjim
spamjim
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
127
Arthur Lewis
Arthur Lewis
P Soman
  • Locked
  • Question
insert data into colums of different tables
Replies
2
Views
147
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top