Hi !
I did try using the mysql client gui but you cant create indexes thru that.
Also, since I've exported from access, the datatype all seem to be
MEDIUMTEXT.
So, when I try the create index syntax,
ie, CREATE UNIQUE INDEX pk_code on company( ?????)
I am not sure what to put it the brackets. I tried by just specifying
length ,tried char,varchar.
It is possible for me to change the data type of a column?? Or do I have to
recreate the tables?
thanks for all the help
[EMAIL PROTECTED] on 24/01/2002 12:39:31
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>,
<[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 tables. How do I go about that?
|
Hi!
the simplest solution is to get a GUI client for MySQL, in which indexing
or any other operation are as easy to do as with Access...
The most famous GUIs are : MASCON, MySQLFront, MySQLGui, DBTools...
Otherwise, you can still use the CREATE INDEX clause with commandlines.
Check the doc it is very well explained...
All urls for GUIs at www.mysql.com or www.dwam.net/mysql/
|
|Also, any suggestions of how cursors work with mysql would be of great
|help.
|
Quite the same as for Access, and the next release of MyODBC (announced for
this month end) should provide full compatibility with ADO.
///// D W A M W 3 S P A C E /////////////////////
Guillaume de Lafontaine - [EMAIL PROTECTED]
. Services Internet : http://www.w3space.com
. Annuaire Aquitaine : http://www.aquitanet.com
. Espace TeleTravail : http://www.w3workers.com
. DWAM.NT Docs & Resources : http://www.dwam.net
|Thanks a lot
|
|Princy.
|
|
|---------------------------------------------------------------------
|Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
|posting. To request this thread, e-mail [EMAIL PROTECTED]
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail [EMAIL PROTECTED] instead.
|
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
