Thanks Peter, exactly what I was hoping for!
andy
On 2/4/11 3:11 PM, Peter He wrote:
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
Are you using the strict SQL mode? Check your my.cnf file.
Peter
> Date: Fri, 4 Feb 2011 14:08:01 -0800
> From: awall...@ihouseweb.com
> To: mysql@lists.mysql.com
> Subject: Question about database value checking
>
> So, a problem popped up today that has caused us no e
So, a problem popped up today that has caused us no end of hair-pulling, and
it brought to mind a similar issue that I found very, well, wrong.
If you have a table defined:
CREATE TABLE `tester_table` (
`acnt`varchar(20) NOT NULL DEFAULT '',
`method` varchar(10) NOT NULL
