codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Move or Copy a table to a different database using MYSQL

    18th July 2014

    MySql

    mysql codehaven category

    This MOVES a table

    1
    2
    3
     
    alter table abc.users rename xyz.users
     

    This duplicates (makes a clone of) a table

    1
    2
    3
     
    CREATE TABLE db1.table1 SELECT * FROM db2.table1
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN