You can clone or create an exact copy of a table in MySQL or MariaDB by creating a new table with the same structure as the source and to copy over the data or rows of the source table to the new table.
This could be done manually or you could use the following
SQL statements to easily clone or create a copy of an existing MySQL/MariaDB table;
Sign up for The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert and many other great courses on Udemy to learn more.
Become an In-demand SQL Master by creating complex databases and building reports through real-world projects!
Written by Mohd Shakir Zakaria.
Last updated on 2019-03-26.