Tutorials on MySQL

It is a system for file management developed by IBM, which allows records to access sequentially or even randomly. ISAM stands for Indexed Sequential Access Method. It’s a file organization method used for managing indexes and data within databases. However, in the context of MySQL, ISAM was a storage engine used in older versions of … Read more

InnoDB is a storage database for SQL. The ACID-transactions are also provided in InnoDB and also includes support for the foreign key. Initially owned by InnobaseOY now belongs to Oracle Corporation after it acquired the latter since 2005. InnoDB is a storage engine for MySQL databases. It provides features such as ACID (Atomicity, Consistency, Isolation, … Read more

The SELECT command is used to view the content of the table in MySQL. Explain Access Control Lists. An ACL is a list of permissions that are associated with an object. MySQL keeps the Access Control Lists cached in memory, and whenever the user tries to authenticate or execute a command, MySQL checks the permission … Read more

In MySQL, the “i-am-a-dummy” flag makes the MySQL engine to deny the UPDATE and DELETE commands unless the WHERE clause is present. The “i-am-a-dummy” flag in MySQL is a humorous option that can be used as a safety measure. When enabled, it prevents accidental updates or deletes on a table by issuing an error message … Read more

In MySQL, regular expressions are used in queries for searching a pattern in a string. * Matches 0 more instances of the string preceding it. + matches one more instances of the string preceding it. ? Matches 0 or 1 instances of the string preceding it. . Matches a single character. [abc] matches a or … Read more