The answers to the last pop quiz are up: http://www.pythian.com/blogs/868/pop-quiz-mysql-cluster
So here’s another pop quiz. Given the following:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16450949 to server version: 4.1.14-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select count(*),length(password) from mysql.user group by length(password);
+----------+------------------+
| count(*) | length(password) |
+----------+------------------+
| 49 | 16 |
| 31 | 41 |
+----------+------------------+
2 rows in set (0.00 sec)
mysql> select password('foo');
+-------------------------------------------+
| password('foo') | [Read more...]