On Tue, Aug 24, 2004 at 11:57:05AM +0200, Thomas Spahni wrote:
> Jesse,
>
> mysql> SHOW INDEX FROM mytable;
>
> gives you all indexes for `mytable`; you can process the results with
> perl.
Thanks very much. This works fine, and since I don't care about the
return value--just that there is one--
Jesse,
mysql> SHOW INDEX FROM mytable;
gives you all indexes for `mytable`; you can process the results with
perl.
Thomas Spahni
On Mon, 23 Aug 2004, Jesse Sheidlower wrote:
> I have a database where, most of the time, I'm bulk-loading
> data into new tables from an external source, several mi
On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote:
> Why don't you disable the indexes before the load and enable the indexes
> after the data load?
If I'm bulk-loading a fresh install of data, then I'll be using
un-indexed tables and index them afterwards. Otherwise, I want
to kee
Why don't you download navicat or use php admin and then just open the table
up in design view? You can then see if it has an index or not and add one if
you need?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
Why don't you disable the indexes before the load and enable the indexes
after the data load?
-Original Message-
From: Jesse Sheidlower
To: [EMAIL PROTECTED]
Sent: 8/23/04 3:33 PM
Subject: Testing for the existence of an index
I have a database where, most of the time, I'm bulk-loading
