insert values from another table sql code example Example: create table and insert values from another table CREATE TABLE new_table AS SELECT * FROM old_table;