That's what I thought. Thanks!
On 30. Sep 2007, at 14:55, Rob Wultsch wrote:
CHECK CONSTRAINT I mean...
On 9/29/07, Rob Wultsch [EMAIL PROTECTED] wrote:
CONSTRAINT does not exist in mysql.
You can use a trigger to deal with the issue, which is obviously less
than ideal.
On 9/29/07, David
I am sorry for sending multiple notes. The reply to is set not being
set to mysql discussion list. I click the reply button automatically.
This email is for the sake of the list sake...
You want a feature like a check constraint:
http://www.postgresql.org/docs/8.1/static/ddl-constraints.html
I often find that I have more than one column in a tale that is an
integer ID used to join to a lookup table. If there is only one Join to
do it is to do something like this
SELECT t.data, l.group
FROM table t JOIN lookuptable l USING (groupID)
WHERE whatever
however if I need to join
I'm seriously intrigued by the idea of trying postgres for this
project...
Thanks!
On 30. Sep 2007, at 15:08, Rob Wultsch wrote:
I am sorry for sending multiple notes. The reply to is set not being
set to mysql discussion list. I click the reply button automatically.
This email is for the
Hi !
Dan Nelson wrote:
In the last episode (Sep 27), Jake Conk said:
Not sure if this is known or not but I just wanted to let you guys
know that MySQL 5.1.21 fails the make. I've never had this problem on
other versions of mysql. It looks like GNU make worked all the way
through but why won't
Hi, all.
I'm having trouble storing monetary values.
When MySQL 5.0 stores the entered value of 5.23,
it storing it as 5, dropping off the values after the decimal.
The field is the decimal type with 2 specified as the number
of values to store after the decimal.
Can anyone
Rick Faircloth wrote:
Hi, all.
I'm having trouble storing monetary values.
When MySQL 5.0 stores the entered value of 5.23,
it storing it as 5, dropping off the values after the decimal.
The field is the decimal type with 2 specified as the number
of values to store after the
Chris W wrote:
I often find that I have more than one column in a tale that is an
integer ID used to join to a lookup table. If there is only one Join to
do it is to do something like this
SELECT t.data, l.group
FROM table t JOIN lookuptable l USING (groupID)
WHERE whatever
however if I
Hello
I have a database with variable-size fields, some of them may be
modified/deleted during the usage and administration, so my doubt is: how can
I compact the records to remove those blank spaces and save space, lets
say defragment the database file so data is continuous and contiguous?
Perhaps you want the ON syntax
SELECT x, y, z
FROM table t, lookupA a, lookupB b
WHERE t.aID = a.aID AND t.bID = b.bID
is equivalent to:
SELECT x, y, z
FROM table t
INNER JOIN lookupA a ON t.aID = a.aID
INNER JOIN lookupB b ON t.bID = b.bID
If you were to do:
SELECT x, y, z
FROM table t
Hello Renito -
What you are looking for is MySQL's OPTIMIZE function:
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
It does exactly what you are looking for.
You can implement this manually, via shell script on a timer, etc. I have
written a multi-threaded perl solution which will
Dear MySQL users,
we are proud to present to you the MySQL Server 5.1.22-rc release,
the first 5.1 release candidate version of the popular open source
database.
Bear in mind that this is still a candidate release, and as with any
other pre-production release, caution should be taken when
[take 2]
Nobody has any comments ?
-- Forwarded message --
Date: Wed, 26 Sep 2007 12:19:21 -0400 (EDT)
From: Philip M. Gollucci [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Crystal Reports XI on W2k3 Server SP2 x64
Hi All,
I'm trying to get Crystal Reports to connect to
13 matches
Mail list logo