Learn how to duplicate mysql table

By admin|Computer, Internet, MySQL

Think you need to duplicate existing mysql table as a new empty table. That means only structure of an existing table to new one. Use following sql to do that.

create table users2 like users;