Basic administration commands for MySQL and Linux.
Monday, December 18th, 2006This 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 […]