Posted by mrcakey on 07/03/07 11:23

"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1183460553.581960.33590@g4g2000hsf.googlegroups.com...
> On 3 Jul, 11:45, "mrcakey" <nos...@spamispoo.com> wrote:
>> "Captain Paralytic" <paul_laut...@yahoo.com> wrote in message
>>
>> news:1183458148.394512.69990@q75g2000hsh.googlegroups.com...
>>
>>
>>
>>
>>
>> > On 3 Jul, 10:35, "mrcakey" <nos...@spamispoo.com> wrote:
>> >> Utterly perplexed by this one. I entered this into my MySQL:
>>
>> >> create table if not exists user
>> >> (userid int not null auto_increment primary key,
>> >> email char(64) not null,
>> >> nickname char(32),
>> >> user_pass char(41),
>> >> reset_ans char(41),
>> >> block_timestamp timestamp,
>> >> blocked tinyint,
>> >> fail_cnt tinyint,
>> >> auth_pending tinyint,
>> >> default_home tinyint,
>> >> pref_email_newsletter tinyint,
>> >> pref_email_own tinyint,
>> >> polled tinyint,
>> >> nominations tinyint,
>> >> songalike_count int );
>>
>> >> When it came out at the other end, phpMyAdmin is reporting that all
>> >> the
>> >> INTs
>> >> are 11 bytes long and the TINYINTs are 4 bytes long. I've no idea
>> >> what's
>> >> going on here?!!!!
>>
>> >> Also, a related issue, is it necessary to align the fields in byte
>> >> pairs?
>> >> This comes from my Tandem programming background - data was stored in
>> >> byte
>> >> pairs, so if you had a field that was 5 bytes long for instance, you'd
>> >> try
>> >> to stick an odd-byte field next to it so that space wasn't wasted. Do
>> >> I
>> >> need to do this for MySQL (just using ISAM)?
>>
>> >> +mrcakey
>>
>> > To find out what's going on here, I can recommend reading the manual:
>>
>> >http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>>
>> Thank you. I had spent a good 20 minutes looking at the manual, but
>> apparently not at the relevant bit. Seems a very weird thing for
>> phpMyAdmin
>> to want to add the display length when it's not needed.
>>
>> +mrcakey- Hide quoted text -
>>
>> - Show quoted text -
>
> The writers of phpMyAdmin obviously didn't realise that you didn't
> need that information. In their ignorance they went and built it to
> display all the relevant information about the fields, for all the
> other people who need to know the details. Crazy huh!
>
> I notice the same with MicroSoft Windows. There are things in here
> that I find totally unnecessary. So I assume that no one else needs
> those features either!
>

Wow. How dumb do I feel? You really got my number. Facetious gimp

+mrcakey

[Back to original message]