开发者

MySQL Copy table structure vs. Creating with statement

开发者 https://www.devze.com 2023-01-07 06:49 出处:网络
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

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 lo开发者_如何学运维t, 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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消