Wrox Programmer Forums Functions
 | Search | Today's Posts | Mark Forums Read
 Intro Programming What is a loop? Which language is best for beginners? What is "object oreinted?" All those types of questions and more are welcome here.
 Welcome to the p2p.wrox.com Forums. You are currently viewing the Intro Programming section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
December 5th, 2005, 06:40 PM
 Registered User Join Date: Dec 2005 Location: , , . Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts
Functions

Hi;; I want to know if there is a function that give all the primary and secundary indexs for a table??? please!!!

January 23rd, 2006, 01:03 PM
Friend of Wrox
 Points: 1,515, Level: 15
 Activity: 0%

Join Date: Dec 2003
Location: Oxford, , United Kingdom.
Posts: 488
Thanks: 0
Thanked 3 Times in 3 Posts

in mysql:

mysql> show index from users\G;
*************************** 1. row ***************************
Table: users
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 3
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
*************************** 2. row ***************************
Table: users
Non_unique: 1
Seq_in_index: 1
Collation: A
Cardinality: 3
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
2 rows in set (0.01 sec)

--
http://charlieharvey.org.uk
http://charlieharvey.com

 Similar Threads Thread Thread Starter Forum Replies Last Post C functions...??? ethantinder C# 2 April 25th, 2008 02:25 AM Functions LTello BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0 3 September 15th, 2006 11:15 AM Functions czambran BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0 13 July 11th, 2006 06:33 PM functions xelepi PHP How-To 1 March 10th, 2006 02:59 AM Help with Functions megabytes C# 1 August 7th, 2003 12:48 PM