Interview Questions

Bugzilla Database Basics

Bugzilla FAQ

(Continued from previous question...)

54. Bugzilla Database Basics

  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

(Continued on next question...)

Other Interview Questions