Copy compleet table layout including keys in one query:
CREATE TABLE newtable LIKE oldtable;
This code gives us insight into the number of people who visit our website, where they are from, and what they are clicking on.