var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query to retrieve primary key
1)i wanna know the query which retrieves the primary key of a table.
2)query to retrieve the primary key and table names.
If anyone knows the query, expecting replies.
To get the tables in a database:
To show the indexes on a table;
(You'll have to grab the line with an index name of PRIMARY KEY from that)
SHOW INDEXES FROM tableName ;