# To connect to your database: bash#mysql-u root

# To see all the "spreadsheets" (tables): mysql>show tables from bugs;

# To see columns from table: mysql> show columns from table;

# To see all the data in a table: mysql> select * from table;

# others:

mysqlgt; select * from table where (column = "some info");

mysqlgt; select * from table where (column != "some info");

mysqlgt; show columns from bugs

(exceedingly long output truncated here)

| bug_status| enum('UNCONFIRMED','NEW','ASSIGNED','REOPENED','RESOLVED','VERIFIED'

mysqlgt; ALTER table bugs CHANGE bug_status bug_status