Try the create table LIKE syntax.
create table users2 like users;
This should give you an empty table (users2) with the same structure as the original (users).
Try the create table LIKE syntax.
create table users2 like users;
This should give you an empty table (users2) with the same structure as the original (users).