Princy,
Thursday, January 24, 2002, 3:23:24 PM, you wrote:
PT> Hi !
PT> I did try using the mysql client gui but you cant create indexes thru that.
PT> Also, since I've exported from access, the datatype all seem to be
PT> MEDIUMTEXT.
PT> So, when I try the create index syntax,
PT> ie, CREATE
<[EMAIL PROTECTED]>
cc:
Subject: Re: Hoe to create indexes on existing tables
|Hi,
|
|I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
|Basic application.
|
|I had a set of tables which I exported from Access database.
|But now, I want to index these ta
|Hi,
|
|I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
|Basic application.
|
|I had a set of tables which I exported from Access database.
|But now, I want to index these tables. How do I go about that?
|
Hi!
the simplest solution is to get a GUI client for MySQL,
> I had a set of tables which I exported from Access database.
> But now, I want to index these tables. How do I go about that?
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
mysql> ALTER TABLE your_table ADD KEY(your_column);
Hope that helps
Marcus
---
Hi,
I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
Basic application.
I had a set of tables which I exported from Access database.
But now, I want to index these tables. How do I go about that?
Also, any suggestions of how cursors work with mysql would be of great
he
