Sunday, 1 September 2013

Display only Index that are not Primary or Foreign Key from a Mysql Table

Display only Index that are not Primary or Foreign Key from a Mysql Table

References

Reference NO 1

http://dev.mysql.com/doc/refman/5.1/en/create-table-foreign-keys.html

Reference NO 2

http://stackoverflow.com/questions/16423199/mysql-friend-system-index-foreign-key-prim-key

Reference NO 3

http://stackoverflow.com/questions/9696571/can-a-table-have-two-foreign-keys

Reference NO 4

http://stackoverflow.com/questions/13093732/mysql-innodb-table-adding-foreign-key-errno150

Reference NO 5

http://www.sitepoint.com/mysql-foreign-keys-quicker-database-development/

Reference NO 6

http://www.maatkit.org/doc/mk-duplicate-key-checker.html

Reference NO 7

#EANF#

Reference NO 8

#EANF#

No comments:

Post a Comment