At 11:55 AM 6/25/2002 -0400, Andy Dustman wrote:
> From a usability perspective, since other databases don't seem to be so
>picky about this sort of thing, InnoDB ought to (IMHO):
>
>a) Act on REFERENCES clauses (i.e. column type REFERENCES ref-table)
>instead of ignoring them.
>
>b) Auto-create
At 09:45 PM 6/10/2002 -0600, Day Irmiter wrote:
>And yet my message comes through from the list. Is
>anybody else having this experience?
Everybody, I would guess. Two thoughtless subscribers have let their
e-mail accounts fall into disuse without unsubscribing. So, when you post,
you get the
Leo,
I believe there was a conversation about this subject several weeks ago, in
which the conclusion was that a good reason to use Linux, in preference to
FreeBSD, for database servers is that Linux multi-processor support works
and FreeBSD doesn't.
--Erv
sql,query
At 09:42 AM 6/11/2002 +0
staff
at this moment.
Is there a similar facility with a different name in MySQL? If not, is it
planned?
Thanks.
--Erv Young
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
?
2) Also, the discussion of ANALYZE TABLE at
http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of InnoDB
tables in limbo. If this doesn't work on InnoDB tables, what takes its
place, or why does its place not need to be taken?
At 03:11 PM 6/8/2002 +0200, Benjamin Pflugmann wrote:
>Hi.
>
>As far as I can see is that you use a condition in your WHERE clause
>which MySQL will not (yet?) use indexes for. See
>
> http://www.mysql.com/doc/M/y/MySQL_indexes.html
> (seems to be mainly about MyISAM tables)
>
>to see how inde
Dion,
Let me repeat back to you the question that I heard you asking:
Can I load a text-file representation of a big, flat, single-table
unnormalized mess into a nicely normalized multi-table MySQL database all
in one fell swoop?
The answer I thought I heard from Bhavinder(?) Vyas was No, you
Jon,
Have you tried phrasing your WHERE clause as
WHERE sequence_log_id >= 0 ?
If there is a determinate lower bound other than zero, then substitute it
for 0 as the second comparand.
Let us know how it comes out.
(And however it comes out, don't ask me why. The real experts can sort
At 05:18 PM 6/5/2002 -0700, you wrote:
>On Wed, Jun 05, 2002 at 04:52:39PM -0700, j.random.programmer wrote:
> > > We're running a custom-compiled 3.23.51 (or .52-pre,
> > > [..]
> > > Why not build your own?
> >
> > Hmm. The latest source on the pre-release page is 3.23.50 and it's
> > not clear
are experiencing. I know this first-hand.
Of course, I'm also assuming that all your tables are InnoDB tables.
Hope this helps.
--Erv Young
At 12:35 PM 6/3/2002 -0400, Stembridge, Michael wrote:
>The following query takes a very long time to process. It finally returns
>only the row
Lance,
Lance,
You are asking for help in the wrong place. MySQL doesn't issue Oracle
error messages. Only Oracle issues Oracle error messages. Try www.oracle.com.
When you go there, they will surely ask you what in the world you are
trying to do. They might suggest that you start by defin
Sounds like you have a table (lkup_info) of load dates (date), in which you
record fileid (did) and date. Sounds like you do not have a separate table
of fileids. I'm assuming that the lkup_info table is updated synchronously
with the loading of each file that the table is recording, though y
In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html, immediately
after introducing MyISAM, BDB, and InnoDB, it says:
"Note that only MyISAM is available in the standard binary distribution."
This assumes that I am able to complete the necessary next sentence:
"Therefore, to use BDB
All,
I have searched the online manual in vain for mySQL system
requirements. Can anyone give me the precise URL? Is there one?
I want to play around with converting an existing FoxPro data base (about
65mb in all tables, 55mb in the largest table) to mySQL. And learning PHP
from square 1,
e knowledgeable than I) think?
Perhaps I should add that Durham, NC, is the home of Red Hat, Inc., and is
also my home.
--Erv Young
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Dominique,
At 05:45 AM 1/15/2002 -0800, Steve Edberg wrote:
>See doc sections:
>
> http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
>and
> http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
> From the CREATE TABLE docs:
>
> "The FOREIGN KEY, CHECK, and REFERENCES cla
Does MySQL have anything functionally equivalent to the data dictionary
views of Oracle? I am thinking particularly of retrieving, via a SQL
SELECT statement, a list of all my tables, or a list of all the columns of
a particular table along with the columns' attributes.
TIA.
--Erv
17 matches
Mail list logo
