My apologies.. I scanned back looking for the reference but couldn't
find it... I thought it worth reiterating what turned out to be your
point because there seems to be so much confusion around this issue.
- michael
On 8/9/07, Brent Baisley [EMAIL PROTECTED] wrote:
Actually, I said to
Hi
I added the following statement at the end of the my.cnf file:
sql-mode=STRICT_ALL_TABLES,ALLOW_INVALID_DATES
but I still got the values 0 and 0.00 where no values were entered.
I did restart the the mysql daemon of course.
What am I still doing wrong?
Thanks.
On 8/8/07, Christian High
I did remove that column from the insert statement and no text appeared at
all in that field under that column. Not even the word NULL.
On 8/8/07, Christian High [EMAIL PROTECTED] wrote:
On 8/8/07, Brent Baisley [EMAIL PROTECTED] wrote:
One thing to check is to make sure you are not quoting
IF it is a null in that column, you should not see the word 'null'..
and the advise to put quotes around it I read earlier in this thread
is completely misguided.. If you insert the string 'null' or 'NULL'
into the database, you have just strored a string..
Perhaps it is the form of your
That is MySQL, not PHP doing that to you. You need to set your
SQL_MODE to strict to get that kind of behavior.. there are other
implications to this mode so you should review:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- michael
On 8/8/07, Mahmoud Badreddine [EMAIL
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I have a table which contain a few numerical values.
I
On 8/8/07, Brent Baisley [EMAIL PROTECTED] wrote:
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I
Ales Zoulek wrote:
Hi,
I've read reacently, that it's not good to use columns with NULL
values in MySQL, because it slows down the select queries over that
columns. Is it true? Or do that affects only some situations or some
versions? Are there some relevant statistics about that?
There is
Thanks a lot.
I agree with you in meaningful separating columns into tables as you
descibed it. I had just impression, that mysql have some inner
algoritmic issue with dealing with NULL values.
Rgrds.
Ales
On 3/29/07, Jay Pipes [EMAIL PROTECTED] wrote:
Ales Zoulek wrote:
Hi,
I've read
So Jay,
What benefit do we get if we only null columns in a separate table, since
they are null, then there is not point in access this table.
Please correct me , i am bit confused by this.
regards
anandkl
On 3/30/07, Ales Zoulek [EMAIL PROTECTED] wrote:
Thanks a lot.
I agree with you in
On Sat, 2006-10-07 at 13:55 +0800, Ow Mun Heng wrote:
Hi,
Anyone here familiar with sqsh?
I'm trying to get bcp going here for replication between a MSSQL
server(2000) to a MySQL server (5.0).
Since I've not found any decent way to do the replication, I'm now
using sqsh to do it via the
Use the keyword 'default' to make the attributes default to the values you
want.
Use some thing like this
user_name varchar(50) default 'default_value' not null
sujay
-Original Message-
From: joshua pereira [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 5:24 PM
To:
joshua pereira wrote:
i want to make it so that i will have to fill in all
the attributes in .so i put not null for all the
attributes. Is this correct ?? when for example do
not fill in user_name , all the other values is
accepted and stored in the databaseplease advise
create table
On Thursday 13 March 2003 20:27, Steve Holt wrote:
I am linking an MS Access front end to MYSQL on the back with ODBC
If I open the table I can enter a value in the course name field only which
is the primary key
and it will save the record even though I have not entered values in the
fields
];
[EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 7:09 PM
Subject: Re: Counting null values
At 9:41 +0200 2/12/03, Octavian Rasnita wrote:
It won't work because MySQL doesn't count null values.
It depends.
count(FieldName) will not count NULL values
count(*) will, because it counts rows
It won't work because MySQL doesn't count null values.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 8:18 AM
Subject: Re: Counting null values
Hi
]
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 8:18 AM
Subject: Re: Counting null values
Hi Octavian,
Try this:
select FieldName, count(*) from TableName group by FieldName
Bye,
Danny
At 16:39 2003.02.08._+0200, you wrote
Hi Octavian,
Try this:
select FieldName, count(*) from TableName group by FieldName
Bye,
Danny
At 16:39 2003.02.08._+0200, you wrote:
Hi all,
I have a table where I have something like this:
| abc |
| abc |
| xxx |
| null |
| null |
| null |
I want to count these lines to give the
On Wed, 2002-08-28 at 21:17, Keith C. Ivey wrote:
Not paying attention to case. As you said earlier, the code for NULL
is \N, not \n.
Oh my! I feel so stupid! I should have known to check the case better by now.
\n is a newline in mysql, right? That's probably why the lines are 'broken' in
sql,query
The current
behavior is what I'd expect to have happen, and what I'd expect most
people to expect to have happen. Maybe you just need to adjust your
expectations.
Paul/Keith:
OK, I see. It was a varchar field, so I assume it must have been entering
empty strings where
SELECT * FROM table WHERE title is NULL LIMIT 1;
Cal
http://www.calevans.com
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 7:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text
Try checking the section 20.16 in the manual, it helped me.
That section is titled: Problems with NULL Values
But you could use:
SELECT * FROM table WHERE title IS NULL LIMIT 1;
/roger
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I
Title will never be = NULL.
NULL is not equal to anything, not even NULL.
SELECT * FROM table WHERE title IS NULL LIMIT 1;
Peter Szekszardi wrote:
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I have about a hundred thousand records
use:
SELECT * FROM table WHERE title IS NULL LIMIT 1;
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 7:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text field (let's name it title).
On Wed, 21 Mar 2001, Peter Szekszardi wrote:
Date: Wed, 21 Mar 2001 14:36:02 +0100 (CET)
From: Peter Szekszardi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I
Hi.
On Wed, 21 Mar 2001 14:36:02 +0100 (CET)
Peter Szekszardi [EMAIL PROTECTED] wrote:
SELECT * FROM table WHERE title = NULL LIMIT 1;
SELECT * FROM table WHERE title IS NULL LIMIT 1;
URL:http://www.mysql.com/doc/W/o/Working_with_NULL.html
On Wed, Mar 21, 2001 at 02:36:02PM +0100, Peter Szekszardi wrote:
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I have about a hundred thousand records in the db,
where the title field is NULL. I have to fill these NULL title fields
Peter,
try
SELECT * FROM table WHERE title IS NULL LIMIT 1;
HTH,
Christopher Oson
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a
28 matches
Mail list logo