MySQL operations

Change a table name

ALTER TABLE old_table RENAME new_table;

Move a table from one database to another

CREATE TABLE new_database_name.new_table_name
LIKE original_database_name.original_table_name;

INSERT new_database_name.new_table_name
SELECT *
FROM original_database_name.original_table_name;

Difference between PDO fetch() and fetchAll()

Leave a Reply