Description:Setting MySqlParameter.MySqlDbType to MySqlDbType.Int24 throws an error similar to "Incorrect integer value: '?' for column 'data' at row 1" when a prepared command is executed. When "command.ExecuteNonQuery()" is executed in the attached sample, the following exception is thrown:...
Still, I do believe that TINYINT has only a 1-byte footprint, and INT uses 4. I think the answer is that rows take a minimum amount of space (5 bytes on 4.1?). Try this: create table t3(a tinyint not null, b tinyint not null, c tinyint not null); insert into t3 valu...