Philip Molter writes:
> >Description:
>
> When I do this:
>
> mysql>create table test_default ( testint int not null default 1 );
> mysql>desc test_default;
>
> I get:
>
> +---------+---------+------+-----+----------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +---------+---------+------+-----+----------+-------+
> | testint | int(11) | | | 16777216 | |
> +---------+---------+------+-----+----------+-------+
> 1 row in set (0.00 sec)
>
> Why does my default not go in as '1'. I've tried it with and
> without quotes. This is vexing. Is there something obvious that
> I'm just not doing correctly?
>
> >How-To-Repeat:
>
Hi!
As there is a binary for your SPARC Solaris 2.8, please try it out
and see if you get the same result.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
