MariaDB's INSTANT ALTER Algorithm Has a Secret!

This MySQL server and MariaDB server tutorial will tell you that if the MariaDB alter algorithm is set to INSTANT, you should keep in mind that it will help your SQL database to quickly add columns to your tables, but such an algorithm will not support column modification to not allow NULL values.

In other words, as this SQL tutorial mentions, if the alter algorithm is set to INSTANT, you cannot quickly deny NULL values in your column.
For that, we suggest you use the algorithm INPLACE.

These are the SQL queries you are likely to be running:
SET SESSION alter_algorithm=’INPLACE’;
ALTER TABLE [your_table] MODIFY COLUMN [column] [datatype] NOT NULL;

We hope that this SQL tutorial has helped you answer some SQL interview questions and answers. Want to know more about SQL interview questions, sql indexes, and database performance optimization?
Make sure to subscribe to this sql tutorial channel! We make sql tutorial for beginners as well as sql tutorials for advanced developers.

If anyone has any issues with copyright (the video, images, etc.), let us know in the comment section below and we’ll immediately act on it. Thank you!

Music:
Late Hours by Devyzed https://soundcloud.com/devyzed
Creative Commons — Attribution-NoDerivs 3.0 Unported
Free Download / Stream: https://bit.ly/3ZkcfKV
Music promoted by Audio Library https://bit.ly/3EFba7a

#database #sql #developer #mysql #webdevelopment #interview #interviewquestions