I think you'll get better results if you don't quote your numbers. Quotes
should be used for text and dates (depending) but not numbers.
----- Original Message -----
From: "Arturo Busleiman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 11:54
Subject: MySQL Tables
> These are the commands I'm currently using to build the MySQL tables
> used/needed by a program I'm doing:
>
> What is wrong here that an INSERT ('2','2','1','test',NULL)
> generates:
>
> | 33554432 | 33554432 | 1 | test | 20171221080222 |
>
> the 33554432 shouldn't be 2's? anything other than INT works WELL (and the
> 3rd column's a TINYINT, whereas the other two are INT's)
>
> why the third column is OK?
>
> CREATE TABLE msg (
> f INT UNSIGNED,
> t INT UNSIGNED,
> mt TINYINT UNSIGNED,
> md BLOB,
> mdt TIMESTAMP,
> INDEX (t)
> );
>
> *> MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/
> *> MP OnLine? EL BBS? FeedBack? -> System Fork!!! 4799-2510 TLD 24hs
> *> El sexo es como el Hacking. Entras, salis y esperas no haber dejado
> *> nada por lo que puedan rastrearte.
> *> Panic? My kernel doesn't panic! We are doomed! DustDustDust!!!!
>
>
>
> ------------------------ Yahoo! Groups Sponsor ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://us.click.yahoo.com/kWP7PD/pYNCAA/4ihDAA/stAVlB/TM
> ---------------------------------------------------------------------_->
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
