[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 t
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 in
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 c
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
INNER
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?
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
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 dec
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 provid
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
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 sa
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 mor
11 matches
Mail list logo
