The Ultimate Guide to High Availability with MariaDB

Comments - CREATE TABLE

3 years, 5 months ago Charis Evlampiou
Re: CREATE TABLE
This comment has the status of 'removed' and can only be seen by you.

It used to be the case that using CREATE TABLE newtable AS SELECT .. was frowned upon since it was placing locks on the tables used to fill newtable. Instead, it was recommended that tables were created first and then filled with data using INSERT INTO newtable .. statement.

Is this still the case?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.