Undefined Title

basic commands of CLI of MySQL and PostgreSQL

2012-12-18

I usually get confused for those commands. It’s my own memo.

| | MySQL | PostgreSQL | |-+——-+————| | login | mysql -h <hostname>
  -u <username>
  –password=<password>
  <dbname> | PGPASSWORD=<password> psql
  -h <hostname>
  -U <username>
  -d <dbname> | | list databases | show databases; | \l | | set current database | use <dbname>; | N/A | | show table names | show tables; | \dt | | show table schema | desc <tablename>; | \d <tablename> |