CODEWITHSUNDEEP
mysqlsqlalter-table
neubert
neubert

Reputation: 16792

ALTER TABLEs without AFTER vs ALTER TABLEs with AFTER

Say I have these two ALTER TABLEs:

  1. ALTER TABLE tableName ADD COLUMN colName INT(11) AFTER colName2
  2. ALTER TABLE tableName ADD COLUMN colName INT (11)

Let's say tableName has 400 columns and one million rows. Should those ALTER TABLEs run at the same speed or should one be faster than the other?

Upvotes: 0

Views: 149

Answers (1)

newman
newman

Reputation: 2719

400 columns is terrible :)

In theory both variants will run in same time

Upvotes: 2

Related Questions