Re: check if an index exists?
On Fri, 17 Aug 2001, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? SHOW INDEX FROM tablename - 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: check if an index exists?
On Fri, Aug 17, 2001 at 09:32:05AM -0700, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? 'DESCRIBE tablename' or 'SHOW COLUMNS FROM tablename'. Figure out where it says 'index' for yourself :) (since I don't know exactly :) Greetz, Peter -- Against Free Sex! http://www.dataloss.nl/Megahard_en.html - 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: check if an index exists?
thank you, i was actually trying to access the table through C-API and had trouble with show index when I used the following query. show index from db.table i will have to try show index from table from db thank you, Chris -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 10:16 AM To: Christopher Teli Cc: Mysql (E-mail) Subject: Re: check if an index exists? On Fri, 17 Aug 2001, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? SHOW INDEX FROM tablename - 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: check if an index exists?
show index from tablename; This returns a result set listing all indexes on the table. --Greg Johnson -Original Message- From: Christopher Teli [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 12:32 PM To: Mysql (E-mail) Subject:check if an index exists? How can I check if an index exists on a table??? Is there some where I can query the admin tables? Chris - 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 - 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: check if an index exists?
Dear Chris, How can I check if an index exists on a table??? The manual sais: SHOW INDEX FROM tbl_name [FROM db_name] Check: http://www.mysql.com/doc/S/H/SHOW.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Christopher Teli [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:32 PM Subject: check if an index exists? How can I check if an index exists on a table??? Is there some where I can query the admin tables? Chris - 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 - 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