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
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?
|
Hi!
the simplest solution is to get a GUI client for
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