How to get primary key of table?

by

A better way is to use SHOW KEYS since you don’t always have access to information_schema. The following works:

SHOW KEYS FROM table WHERE Key_name="PRIMARY"

Column_name will contain the name of the primary key.

More Related Contents:

  1. How can I do ‘insert if not exists’ in MySQL?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. How can I use PDO to fetch a results array in PHP?
  5. Fixing broken UTF-8 encoding
  6. Insert multiple rows with one query MySQL
  7. MySQL check if a table exists without throwing an exception
  8. Export MySQL data to Excel in PHP
  9. MySQL – ignore insert error: duplicate entry
  10. How to write a stored procedure using phpmyadmin and how to use it through php?
  11. localhost vs. 127.0.0.1 in mysql_connect()
  12. “slash before every quote” problem [duplicate]
  13. Doing calculations in MySQL vs PHP
  14. Geo-Search (Distance) in PHP/MySQL (Performance)
  15. Call to a member function execute() on boolean in [duplicate]
  16. PHP mysql search multiple tables using a keyword
  17. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  18. How to store the data in unicode in hindi language
  19. PDO + MySQL and broken UTF-8 encoding
  20. Best practice: Import mySQL file in PHP; split queries
  21. How to select multiple rows from mysql with one query and use them in php
  22. php run once and insert twice in mysql database
  23. Connecting to remote MySQL server using PHP
  24. Using PHP to execute multiple MYSQL Queries
  25. split keywords for post php mysql
  26. Remotely connecting to a MySQL database
  27. mysql_connect VS mysql_pconnect [closed]
  28. Strange problem with the length of the field gotten from database [duplicate]
  29. mysql_fetch_array skipping first row
  30. 500 Internal Server Error?

Leave a Comment