FUDforum: Database discussions » Zero values in fields

Home » General » Database discussions » Zero values in fields

Show: Today's Messages :: Polls :: Message Navigator

Re: Zero values in fields [message #19839 is a reply to message #19820]

Sat, 11 September 2004 01:49

Abraxa

Messages: 72
Registered: August 2004
Location: Germany

Karma:

Member

Thanks for the hints! =)

I fiddled around with MySQL and set the field properties of that column to NOT NULL and lowered the length of the length field (at least I think that's all I did, it was a couple days ago).
I just checked again and to my surprise the query does return the zero values now...

Could it have been the NOT NULL option? Sorry, I'm a beginner in MySQL and couldn't find anything about the exact behavior of that option in the MySQL documentation =\

-Soeren

Report message to a moderator

[Message index]

		Zero values in fields By: Abraxa on Tue, 07 September 2004 00:50
		Re: Zero values in fields By: dataj1998 on Tue, 07 September 2004 12:15
		Re: Zero values in fields By: Abraxa on Sat, 11 September 2004 01:49
		Re: Zero values in fields By: dataj1998 on Sun, 12 September 2004 14:32
		Re: Zero values in fields By: Abraxa on Sun, 12 September 2004 19:36
		Re: Zero values in fields By: dataj1998 on Sun, 12 September 2004 21:37
		Re: Zero values in fields By: alansmith on Sun, 03 October 2004 10:50
		Re: Zero values in fields By: Ilia on Mon, 04 October 2004 13:17

Previous Topic:	2 Fud Forums, Can I combine users
Next Topic:	Determining when to use INSERT or UPDATE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:52:15 GMT 2024

Total time taken to generate the page: 0.04263 seconds