CODEWITHSUNDEEP
mysql
Anon
Anon

Reputation: 737

MySQL Copy table structure vs. Creating with statement

Ok so I was wondering if there is a big difference performance and efficiency wise between creating a table in MySQL with a full Create table statement vs. Copying the structure of another table that has the same layout. I ask because there are going to be multiple, and I mean a lot, of tables being created so I wanted to see if copying would help relieve some stress on the server vs just using full statements to create them.

EDIT: Yes I am talking about using the CREATE TABLE...LIKE... I just wanted to know if there was any performance difference

Upvotes: 1

Views: 1204

Answers (1)

davidcelis
davidcelis

Reputation: 3347

If you're talking about using a CREATE TABLE tbl LIKE other_tbl, I'm pretty sure MySQL just performs a normal CREATE TABLE statement using the layout of other_tbl

Upvotes: 2

Related Questions