copy table mysqla code example

Example 1: copy table oracle

CREATE TABLE New_Table_name AS SELECT * FROM Existing_table_Name;

Example 2: create table mysql query

create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
   PRIMARY KEY ( tutorial_id )
);