Re: Hoe to create indexes on existing tables
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 UNIQUE INDEX pk_code on company( ?) Take a look at: http://www.mysql.com/doc/C/R/CREATE_INDEX.html PT> I am not sure what to put it the brackets. I tried by just specifying PT> length ,tried char,varchar. PT> It is possible for me to change the data type of a column?? Or do I have to PT> recreate the tables? Yes, it is possible. Try to look for CHANGE/MODIFY at: http://www.mysql.com/doc/A/L/ALTER_TABLE.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: Hoe to create indexes on existing tables
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
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. | - 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
Re: Hoe to create indexes on existing tables
> 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 - 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
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? Also, any suggestions of how cursors work with mysql would be of great help. Thanks a lot Princy. - 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