Archive for December, 2006

Basic administration commands for MySQL and Linux.

Monday, December 18th, 2006

This posting shows some basic commands I use for administrating MySQL databases and using Linux.

Mysql
Show all databases:
mysql> show databases;
Run all commands on this database from now on:
mysql> use myDatabase;
Show all tables inthe selected database:
mysql> show tables;
Show all field/column names in a table:
mysql> describe myTable;
You have table with a field named “username” and you want to […]