Get Primary MySQL Key

getPrimaryKey

#!/bin/bash

HOST=$1
USER=$2
PASS=$3
DATABASE=$4
TABLE=$5

# head/tail to get the second line. The first column is the table, so we delete everything afterwards.
mysql -h $HOST -u $USER --password=$PASS $DATABASE -e 'show columns from '"$TABLE"' where `Key`="Pri";'| head -2 |tail -1|sed "s/\t.*//g"