Copy structure and all entries from one table to another (or how to create copy of existing table)
Creating copy of existing MySQL table is useful when you want to prevent loose of existing data from it, or when you want to archive existing table. There are several ways to to this. One of the ways is to create new table like existing and to add same data with next two queries: CREATE…