Hi Group,
Please forgive me if this has an obvious answer, but I couldn't find it
in the MySQL v4.1 manual --- how can I see what indexes (and which
columns are indexed) for a table?
Thanks!
Holly
Thank you! That's just what I was looking for.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:34 PM
To: Holly Chamberlain; [EMAIL PROTECTED]
Subject: Re: how see list of a table's indexes?
Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE
Hi Group,
Does anyone have a good site that contains the current SQL standard? Or
does anyone know is ISNULL() and IFNULL(), and similar null testing
functions, standard SQL or extensions to SQL?
Thanks! I'm porting from Sybase SQLAnywhere to MySQL and just found what
worked in Sybase (ISNULL())
Hi -
You didn't mention which version of Sybase you are migrating from. I
just migrated our db from Sybase SQLAnywhere to MySQL v4.1 and there
were a couple things I found that didn't I had to change:
1) SQLAnywhere allows some words as column names that MySQL doesn't: I
had some a couple tables
Hi Group,
I'm requesting feedback - should I use MyISAM or Innodb tables, or a
mix? My database (currently in Sybase) typically gets no larger than 50
gigs, but 99% of the data is in one table.
(The app is an cleanroom monitoring system, we collect 3-5,000 records a
minute from environmental
To: Holly Chamberlain
Subject: Re: What do you recommend: MyISAM or INNODB?
No question. MyISAM.
_M
At 02:01 PM 10/10/2003, you wrote:
Hi Group,
I'm requesting feedback - should I use MyISAM or Innodb tables, or a
mix? My database (currently in Sybase) typically gets no larger than 50
gigs, but 99
I can connect to my v4.1 MySQL server from Crystal Reports v8.5 using MyODBC
v3.51. (Via selecting my DSN from the list of ODBC DSNs that Crystal shows
me).
-Holly
-Original Message-
From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 10:21 AM
To: [EMAIL
