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 -

Re: OT: Default forced on MySQL;

2001-11-09 Thread Kodrik
> No kidding? Why don't you fork the PostGreSQL codebase and apply your > special assembly talents to speed it up by "50% or even 60%"? If you're willing to pay for quality, Oracle is an obvious choice. It's fast, it has all the features, there are numerous advanced tools to manage and develop y

Re: OT: Default forced on MySQL;

2001-11-09 Thread Shankar Unni
DownloadFAST.com wrote: >> [...] why don't you try PostgreSQL instead? > My understanding is it is much slower. No kidding? Why don't you fork the PostGreSQL codebase and apply your special assembly talents to speed it up by "50% or even 60%"? ---

Re: Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 12:08, you wrote: MySQL > On Friday 09 Nov 2001 11:37, you wrote: > > Note on what is going on here... > > > > The paragraph below was from a private email I sent to Gordon. And now > > Gordon just responded to it on the public list. > > > > Gordon, I was strongly hinting to

Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 12:11, DownloadFAST.com wrote: > >Considering the features you want (IIRC you only mentioned the > >default values in tables) - why don't you try PostgreSQL instead? > > My understanding is it is much slower. That is what I am hoping for. Or rather, I am hoping that MySQL pr

Re: OT: Default forced on MySQL;

2001-11-09 Thread DownloadFAST.com
>Considering the features you want (IIRC you only mentioned the >default values in tables) - why don't you try PostgreSQL instead? My understanding is it is much slower. >There are at least 5 free open source SQL DBMSes (MySQL, PostgreSQL, SAP, >Interbase, MiniSQL). Before you hopelessly sta

Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 03:36, DownloadFAST.com wrote: > Mr. Bobic, [snip] > The only thing that matters is that every time you respond on the list, you > are only making a fool of yourself in the eyes of the many people who are > lurking. They can see right thru your motives in sending this post

Re: OT: Default forced on MySQL;

2001-11-08 Thread DownloadFAST.com
I just got back in from a nice day in the park with my kids and my parents. All I can say to defend myself is that I'm sorry I did not bow to you thy King. And I am sorry if I have my own opinions and personality. I will try to conform asap to Big Brother's wishes. And I am sorry that my apol