Question

write the SQL query to change the schema of table and insert some data in changed table​

Answer 1

• Renaming is the best option in order to change the schema of the table. The syntax is as follows:

RENAME TABLE old_tablename TO new_tablename;

• To insert data values into the new table the syntax is as follows:

INSERT INTO new_tablename (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...);