Search the Community
Showing results for tags 'look up primary keys in table'.
Found 1 result
-
I am trying to look up a table and get the primary keys of the table into an assoc array , the below code is working for 1 primary key but its not working for more than 1 primary keys in a table. Could any one please help me in this. , I am a beginner in php. $getPrimaryKeys="SELECT k.COLUMN_NAME FROM information_schema.table_constraints t LEFT JOIN information_schema.key_column_usage k USING(constraint_name,table_schema,table_name) WHERE t.constraint_type='PRIMARY KEY' AND t.table_schema='".$schemaname."' AND t.table_name='".$table."';"; $results=mysql_query($getPrimaryKeys); $priKeys=mysql_fetch_assoc($results) <pre> print_r($priKeys); </pre>