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
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
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
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
