1. To connect to your database: bash#mysql-u root
2. To see all the “spreadsheets” (tables): mysql>show tables from bugs;
3. To see columns from table: mysql> show columns from table;
4. To see all the data in a table: mysql> select * from table;
5. 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

Related posts:

1. What is the Bug List page? Change Columns: by selecting this link, you can show all...
2. What is The Bugzilla Query Page? The Bugzilla Query Page is the heart and soul of...
3. I try to add myself as a user, but Bugzilla always tells me my password is wrong Certain version of MySQL (notably, 3.23.29 and 3.23.30) accidentally disabled...
4. How to Write a Useful Bug Report with Bugzilla Useful bug reports are ones that get bugs fixed. A...
5. I think I’ve set up MySQL permissions correctly, but bugzilla still can’t connect. Try running MySQL from its binary: “mysqld –skip-grant-tables”. This will...

Related posts brought to you by Yet Another Related Posts Plugin.