Copy a Table & Rows, Creating a New Table

Copy a Table & Rows, Creating a New Table

MySql / MariaDB

Copy a Table & Rows, Creating  a New Table

This example shows you how to use an origin table to create a new table, and populate the new table with contents from the origin.  This can be used across databases.

CREATE TABLE current_database.notes (SELECT * FROM origin_database.notes);

Share this Post

Author

Avatar for mike knebel

mike knebel

Software Developer - Websites, Mobile Apps. Owner of Logistics Logic, 307WEB and 405Software
@mknebel   MikeKnebel