MySQL CREATE TABLE SELECT Sub-Query Example

MySQL CREATE TABLE SELECT Sub-Query Example

Open your SQL Query Editor then copy & paste the below code to make a backup copy table of another MySQL table using CREATE TABLE .. SELECT:

   CREATE TABLE employees_bak SELECT *
   FROM employees

MySQL CREATE TABLE SELECT Sub-Query Example - Execution in SQL Query Editor