How old is this database? Is it MySQL or MSSQL?
I ask because there was a time when databases did not support transactions.
So some db designers did indeed use temporary tables for what was called
scratch tables. These were tables where updates were collected over a
period of time and then batch u
On Mon, 2013-10-07 at 14:04 +0200, Caveat wrote:
> Thanks Randall, we got some great discussions going here. I think the
> closing paragraph sums it up quite well...
>
> "
>
> So err on the side of caution and normalize your data until you have
> the experience needed to know when to break the
Lovely
-- Original Message ---
From: Caveat
To: gambas-user@lists.sourceforge.net
Sent: Mon, 07 Oct 2013 14:04:55 +0200
Subject: Re: [Gambas-user] [slightly OT] No Problem with Gambas or MySql!
> Thanks Randall, we got some great discussions going here. I think the
> c
Thanks Randall, we got some great discussions going here. I think the
closing paragraph sums it up quite well...
"
So err on the side of caution and normalize your data until you have
the experience needed to know when to break the rules. If you always
normalize your data you will be correct 99
On Sun, 2013-10-06 at 11:55 +0200, Charlie Reinl wrote:
>
> Salut Bruce,
>
> how do you look back to 'Lemon Liniment' history ?
>
>
Once the name change occurs we have no reason to look for 'Lemon
Liniment' history, it's all under the 'Cherry Zontop' history and that
is how anyone would look
If you need some books on relational databases. I can give you private
access to my library or digital/scanned books. They will explain things
much better that we have here and teach you SQL. Also, know that relational
data bases are only one type of data base. There are other types of
databases no
A simple explanation as to why you do not repeat data in a rational
database. (Very simplistic):
Rational or Relational data bases normalize data so that any usage of a
single bit of data is stored only once. This allows the data to be edited
in only one location and also requires the least amount
Am Sonntag, den 06.10.2013, 10:55 +1030 schrieb Bruce:
> On Sun, 2013-10-06 at 00:58 +0200, Willy Raets wrote:
> > On Sun, 2013-10-06 at 00:05 +0200, Caveat wrote:
> > > > If you wanted to delete one row with values 347 200, then which row
> > > > would it be?
> > >
> > > It *doesn't matter*! Th
On 10/06/2013 02:25 AM, Bruce wrote:
> postgres, because it properly supports "ON UPDATE CASCADE" constraints
> on those tables and their foreign key columns handles it all
> internally. Anyway, as I said, [ASIDE] and just one of the reasons for
> preferring postgresql.
In my experience it's no
Thanks for the great horse story Bruce. Willy asked me once whether I
preferred MySQL or postgreSQL and I couldn't really come up with a very
smart answer! Perhaps that helps :-)
The only thing I find odd is why you don't just use the microchip ID as
the primary key... then a name change would
On Sun, 2013-10-06 at 00:58 +0200, Willy Raets wrote:
> On Sun, 2013-10-06 at 00:05 +0200, Caveat wrote:
> > > If you wanted to delete one row with values 347 200, then which row would
> > > it be?
> >
> > It *doesn't matter*! The rows are the same, so pick a row, ANY row!
>
> That is exactly w
On Sun, 2013-10-06 at 00:05 +0200, Caveat wrote:
> > If you wanted to delete one row with values 347 200, then which row would
> > it be?
>
> It *doesn't matter*! The rows are the same, so pick a row, ANY row!
That is exactly what I have been doing for the last 10 years.
In VB code I just looke
On 10/06/2013 12:05 AM, Caveat wrote:
>>> "duplicate rows are and always were a mistake in SQL", C.J.Date
> The guy has obviously never read William Kent's "Data and Reality". It's
> a book I'd still recommend to anyone working with data and particularly
> databases, even though it was written 35 y
> If you wanted to delete one row with values 347 200, then which row would it
> be?
It *doesn't matter*! The rows are the same, so pick a row, ANY row!
> Without the primary key, you're asking MySQL to guess, and it wont.
Yes it will, if you use LIMIT (see my previous two mails). Otherwise,
14 matches
Mail list logo
