How to clone MySQL / MariaDB table
You can duplicate a table in MySQL or MariaDB by creating a new table with the same structure as the source table and then copying the data or rows of the source table to the new table.
You can clone or create a copy of an existing MySQL / MariaDB table manually or you could use some dedicated SQL statements to simplify the process.
Steps to copy MySQL / MariaDB table:
-
Log in to MySQL / MariaDB.
-
Select the database of the source table.
use mydatabase;