INFORMATION_SCHEMA.COLUMNS : and must be a Primary Key : Mysql query

INFORMATION_SCHEMA.COLUMNS : and must be a Primary Key : Mysql query

References

Reference NO 1

http://stackoverflow.com/questions/15188299/information-schema-columns-and-must-be-a-primary-key-mysql-query

Reference NO 2

http://rpbouman.blogspot.com/2008/03/mysql-informationschema-identifying.html

Reference NO 3

http://www.artfulsoftware.com/queries.php

Reference NO 4

http://dev.mysql.com/doc/refman/4.1/en/alter-table.html

Reference NO 5

http://dev.mysql.com/doc/innodb/1.1/en/glossary.html

Reference NO 6

http://dev.mysql.com/doc/refman/5.5/en/explain-output.html

Reference NO 7

http://docs.oracle.com/cd/E19957-01/mysql-refman-5.5/optimization.html

Reference NO 8

http://www.ntu.edu.sg/home/ehchua/programming/sql/MySQL_Beginner.html