I a new comer to MySQL. I must copy this content of 1 table to a different table inside the same database. Essentially, I must place to some table from another table. Can there be smart way to do this?

thank you for any help

INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE

EDIT: or maybe the tables have different structures you may also:

INSERT INTO TARGET_TABLE (col1,col2) SELECT col1,col2 FROM SOURCE_TABLE

When the table does not exist, you may create one with similar schema like so:

CREATE TABLE table2 LIKE table1;

Then, copying the information over:

INSERT INTO table2 SELECT * FROM table1

If table1 is big and you won't want to lock it throughout the copy process, you are able to perform a dump-and-load rather:

CREATE TABLE table2 LIKE table1;

SELECT * INTO OUTFILE '/tmp/table1.txt' FROM table1;
LOAD DATA INFILE '/tmp/table1.txt' INTO TABLE table2;

If you wish to create and copy this content in one shot, only use the Choose:

CREATE TABLE new_tbl Choose * FROM orig_tbl