When you create a table, and then run SHOW CREAT
More DBA job interview questions and answers at
When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
1. VARCHARs with length less than 4 become CHARs
Other Job Interview Questions