-
Are table and column names of the database case sensitive? ⌘
-
How do I enable case sesitive or case insensitive search within data? ⌘
-
What is the difference between
LIKE ''and= ''? ⌘ -
What are collations for? ⌘
-
What is the difference between collation and encoding? ⌘
-
What is character set? ⌘
-
What is the difference between character set and encoding? ⌘
-
What is the difference between shared locks (read locks) and exclusive locks (write locks)? ⌘
-
What is the difference between table-level locking and row-level locking? Storage engines should be mentioned. ⌘
-
What are index prefixes? ⌘
-
How to reset MySQL root password?
Read more: https://linuxconfig.org/how-to-reset-root-mysql-password-on-ubuntu-18-04-bionic-beaver-linux