Much of the MySQL interview prep you’ll find online is based on outdated versions that reached end-of-life years ago. If your answer to a connection question still mentions mysql_pconnect(), or you write string comparisons without quotes, an experienced interviewer will immediately know you haven’t worked with a modern MySQL server.
This is the third installment in our MySQL interview series, and every question and example has been verified on a currently supported MySQL release. If you haven’t read the previous parts yet, they’re a great place to start before continuing.