Bugzilla Question: Download Questions PDF
Bugzilla Database Basics
![Bugzilla Interview Answer Bugzilla Interview Question](https://globalguideline.com/public/images/interview/8.png)
Answer:
# 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
# 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
Download Bugzilla Interview Questions And Answers
PDF
Previous Question | Next Question |
I ca not upload anything into the database via the Create Attachment link. What am I doing wrong? | What is Red Hat Bugzilla? |