RE: Re: Default forced on MySQL

2001-11-14 Thread Christopher Book
I guess you'll have to wait till its implemented its on the TODO >Is that too much to ask? database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: Default forced on MySQL

2001-11-14 Thread Franklin Schmidt
I tried compiling with the DONT_USE_DEFAULT_FIELDS flag. Now no defaults are used, even the ones I ask for. So MySQL gives me a choice of getting defaults I don't ask for (with the regular version) or not getting defaults I do ask for (with the DONT_USE_DEFAULT_FIELDS). How about giving me what

Re: Default forced on MySQL

2001-11-10 Thread Gordan Bobic
On Saturday 10 Nov 2001 21:00, Franklin Schmidt wrote: > The worst thing any development tool can do is silent unwanted favors. > Java and C don't do unwanted favors which is why they are great. > Javascript and most Microsoft tools do lots of unwanted favors which is > why I hate them. This is

Re: Default forced on MySQL

2001-11-10 Thread Kodrik
On Saturday 10 November 2001 01:00 pm, you wrote: > Kodrik wrote: > > Understand also that the check for a uniq index has to be made by a call > > to the DB so it makes sense the DB does it, but a check on the content of > > a variable can be made by one line of code without any call to the db. >

Re: Default forced on MySQL

2001-11-10 Thread Franklin Schmidt
Kodrik wrote: > > Understand also that the check for a uniq index has to be made by a call to > the DB so it makes sense the DB does it, but a check on the content of a > variable can be made by one line of code without any call to the db. Anything that the database does, one can also do in code

Re: Default forced on MySQL

2001-11-10 Thread Kodrik
> I would like to add my support for NO DEFAULT. The lack of this feature > is by far the worst thing about MySQL. > I don't get this argument. What happens when a unique index is > violated? Isn't this the same problem? Those two comments together are quite interesting. Can you enlighten me w

Re: Default forced on MySQL

2001-11-10 Thread Franklin Schmidt
I just found the following at http://www.mysql.com/doc/B/u/Bugs.html -- Because MySQL allows you to work with table types that don't support transactions, and thus can't rollback data, some things behave a little differently in MySQL tha

Re: Default forced on MySQL

2001-11-10 Thread Franklin Schmidt
Sinisa Milivojevic wrote: > As your entire discussion centers on the non-existence of NO DEFAULT, > I will briefly comment only on that. I would like to add my support for NO DEFAULT. The lack of this feature is by far the worst thing about MySQL. > Forcing default on all columns is a design de

Re: Default forced on MySQL

2001-11-10 Thread Franklin Schmidt
DownloadFAST.com wrote: > But hey apparently I did finally get a solution from a helpful chap on this > list What is it? I would like to know. My email is [EMAIL PROTECTED] P.S. for spam filter - database,sql,query,table -