On Wed, February 21, 2007 4:14 pm, Michael Reece wrote:
> i am curious, if you "set sql_mode=strict_trans_tables;", what
> happens if you "insert into bars set id=1;" (with the original schema
> that had an id column, of course)?
>
> does it give the "cannot be null" error?
Yes. You get
mysql> in
i am curious, if you "set sql_mode=strict_trans_tables;", what
happens if you "insert into bars set id=1;" (with the original schema
that had an id column, of course)?
does it give the "cannot be null" error?
(i don't have mysql 5.0.2+ installed and strict_trans_tables is not
an option for
On Feb 21, 2007, at 1:23 PM, Danial Pearce wrote:
>> You got the SQL_MODE setting "wrong". :-)
>>
>> set sql_mode=strict_trans_tables;
>
> Does that SQL_MODE apply to the create table, and stay there? Or does
> it apply to the insert and maybe you didnt need to have it set when
> you created?
I
> You got the SQL_MODE setting "wrong". :-)
>
> set sql_mode=strict_trans_tables;
Does that SQL_MODE apply to the create table, and stay there? Or does
it apply to the insert and maybe you didnt need to have it set when
you created?
Reason I ask, is maybe you need DBI to somehow set the SQL_MODE
On Feb 21, 2007, at 12:35, Michael Reece wrote:
>> MySQL, correctly, says the default is NULL:
>
> i was say erroneously, not correctly.
>
> if you try this:
>
>insert into bars set id=1 ;
>select * from bars ;
>
> you will see that the foo column is '', not NULL, suggesting the
> default
On Feb 21, 2007, at 12:01, John Siracusa wrote:
> On 2/21/07, Ask Bjørn Hansen <[EMAIL PROTECTED]> wrote:
>> MySQL, correctly, says the default is NULL:
>
> Try using DBI's column_info() method and see what COLUMN_DEF is set to
> for that column.
Grrh, it's '' (an empty string). I thought they
> MySQL, correctly, says the default is NULL:
i was say erroneously, not correctly.
if you try this:
insert into bars set id=1 ;
select * from bars ;
you will see that the foo column is '', not NULL, suggesting the
default really is ''.
On Feb 21, 2007, at 11:44 AM, Ask Bjørn Hansen
Ask Bjørn Hansen wrote:
>Note the "" default to "foo".
>
>MySQL, correctly, says the default is NULL:
>
>mysql> show create table bars\G
>*** 1. row ***
>Table: bars
>Create Table: CREATE TABLE `bars` (
> `id` int(10) unsigned NOT NULL,
>
On Feb 21, 2007, at 10:00, John Siracusa wrote:
> I'm going to release 0.761 shortly. If you have any outstanding bugs
> not fixed in SVN or any other small suggestions, speak now...
Maybe this is something, once again, that I am doing wrong - but I
don't understand this:
mysql 5.0.27 and DB
I'm going to release 0.761 shortly. If you have any outstanding bugs
not fixed in SVN or any other small suggestions, speak now...
-John
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay pa
10 matches
Mail list logo
