move table from one schema to another schema ?
I want to move table from one schema to another schema in mysql , can anybody tell me how can I do this .
If both schema is on same server then Alter table can be used to move tables from one db to another.
alter table old_db.fooTable rename new_db.fooTable
Moving tables with space characters in between should be enclosed.
Example:
ALTER TABLE `schema1`.`tbl somename`
RENAME TO `schema2`.`tbl somename` ;