KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
While learning mysql, I read that you can perform the following statement when adding a column to a mysql table: ALTER TABLE contacts ADD email VARCHAR(60) AFTER name; or ALTER TABLE contacts ADD email VARCHAR(60) FIRST; When would you want to do this? Can column order be utilized for query optimization purposes? Should longblobs be the last column to optimize space consumption? Or do these commands exist for some other reason?
Tags (comma-separated)
Save Edits
Cancel