85 messages in com.mysql.lists.mysqlRe: Default forced on MySQL
FromSent OnAttachments
Kodrik06 Nov 2001 22:28 
DownloadFAST.com07 Nov 2001 00:35 
Arne K. Haaje07 Nov 2001 01:05 
DownloadFAST.com07 Nov 2001 01:26 
Kodrik07 Nov 2001 01:31 
Kodrik07 Nov 2001 01:34 
DownloadFAST.com07 Nov 2001 01:45 
Kodrik07 Nov 2001 01:59 
DownloadFAST.com07 Nov 2001 02:43 
Kodrik07 Nov 2001 02:44 
Kodrik07 Nov 2001 02:53 
Elm Gysel07 Nov 2001 02:59 
DownloadFAST.com07 Nov 2001 03:16 
DownloadFAST.com07 Nov 2001 03:36 
Kodrik07 Nov 2001 03:46 
Carsten H. Pedersen07 Nov 2001 04:02 
DownloadFAST.com07 Nov 2001 04:05 
DownloadFAST.com07 Nov 2001 04:13 
DownloadFAST.com07 Nov 2001 04:46 
Carl Troein07 Nov 2001 04:54 
Kodrik07 Nov 2001 05:06 
DownloadFAST.com07 Nov 2001 05:20 
Sinisa Milivojevic07 Nov 2001 05:34 
DownloadFAST.com07 Nov 2001 05:53 
DownloadFAST.com07 Nov 2001 06:25 
Sinisa Milivojevic07 Nov 2001 06:29 
DownloadFAST.com07 Nov 2001 06:35 
DownloadFAST.com07 Nov 2001 06:46 
DL Neil07 Nov 2001 06:52 
DownloadFAST.com07 Nov 2001 07:01 
DownloadFAST.com07 Nov 2001 07:08 
Sinisa Milivojevic07 Nov 2001 07:13 
Elm Gysel07 Nov 2001 07:23 
DownloadFAST.com07 Nov 2001 07:27 
Sinisa Milivojevic07 Nov 2001 07:28 
DownloadFAST.com07 Nov 2001 07:31 
DownloadFAST.com07 Nov 2001 07:35 
DownloadFAST.com07 Nov 2001 07:47 
Sinisa Milivojevic07 Nov 2001 08:20 
Scott Thurmond07 Nov 2001 08:28 
Sinisa Milivojevic07 Nov 2001 08:29 
Elm Gysel07 Nov 2001 08:30 
Paul DuBois07 Nov 2001 08:45 
DownloadFAST.com07 Nov 2001 09:02 
DownloadFAST.com07 Nov 2001 09:08 
DownloadFAST.com07 Nov 2001 09:29 
Sinisa Milivojevic07 Nov 2001 09:47 
DownloadFAST.com07 Nov 2001 09:49 
DownloadFAST.com07 Nov 2001 10:01 
Paul DuBois07 Nov 2001 10:18 
rc07 Nov 2001 10:48 
Shankar Unni07 Nov 2001 11:17 
DownloadFAST.com07 Nov 2001 12:48 
Kodrik07 Nov 2001 13:53 
Ravi Raman07 Nov 2001 14:16 
Paul DuBois07 Nov 2001 14:37 
Shankar Unni07 Nov 2001 15:52 
Kodrik08 Nov 2001 01:02 
Kodrik08 Nov 2001 01:02 
DownloadFAST.com08 Nov 2001 04:54 
DownloadFAST.com08 Nov 2001 06:53 
Gordan Bobic08 Nov 2001 08:18 
DownloadFAST.com08 Nov 2001 19:30 
Gordan Bobic09 Nov 2001 02:54 
DownloadFAST.com09 Nov 2001 03:37 
DownloadFAST.com09 Nov 2001 04:11 
Gordan Bobic09 Nov 2001 05:07 
Gordan Bobic09 Nov 2001 05:09 
Shankar Unni09 Nov 2001 11:31 
Kodrik09 Nov 2001 12:39 
Franklin Schmidt10 Nov 2001 01:50 
Franklin Schmidt10 Nov 2001 01:56 
Franklin Schmidt10 Nov 2001 02:31 
Kodrik10 Nov 2001 02:56 
Franklin Schmidt10 Nov 2001 12:59 
Kodrik10 Nov 2001 13:52 
Arjen G. Lentz10 Nov 2001 15:27 
Kodrik10 Nov 2001 15:50 
Gordan Bobic10 Nov 2001 18:34 
Phieu Huynh11 Nov 2001 16:31 
M.Ho...@gac.nl12 Nov 2001 01:51 
Nguyen Trong Phuc12 Nov 2001 16:25 
Phieu Huynh12 Nov 2001 22:19 
Franklin Schmidt14 Nov 2001 06:44 
Christopher Book14 Nov 2001 07:58 
Subject:Re: Default forced on MySQL
From:DownloadFAST.com (supp@DownloadFAST.com)
Date:11/07/2001 05:53:08 AM
List:com.mysql.lists.mysql

Thanks for the informative reply.

SUGGESTION: Since the rollback optimization problem does NOT apply to single inserts, then why butcher the schema, and instead just make the automatic defaults a "feature" of multiple row inserts??

In other words, why penalize the single row insert (the most common) just because of the optimization issue with multi-row inserts?

<JOKE>Hey I feel like we are actually helping each other now. What a wonderful concept</JOKE>

Sincere thanks.

At 03:35 PM 11/7/2001 +0200, you wrote:

DownloadFAST.com writes:

I recently took over the programming of our site and am shocked to discover that MySQL doesn't even support the most basic SQL syntax.

For example, to support the NO DEFAULT value for column. I.e. to allow a column to NOT have a DEFAULT and thus give an error when an INSERT command does not specify the value for that column.

[skip]

Shelby Moore CEO DownloadFAST.com, Inc.

Hi!

As your entire discussion centers on the non-existence of NO DEFAULT, I will briefly comment only on that.

Forcing default on all columns is a design decision which had to be forced for many reasons. Most important reason of all is that MyISAM tables are designed for utter speed. Therefore, they are not transactional tables nor do they have any form of pre-imaging. As on the other hand, MySQL supports multi-row inserts (and soon even multi-table updates), having defaults was a necessity as rolling back upon hitting the error in user's data in N'th row is simply impossible.

-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com