access mantis db and some sql for inquiry

原创 2005年03月02日 16:20:00

The mantis is an open source project for bug tracking.  In our project, the db for mantis is mysql.

We can read the bug information from mantis through browser.

But you might hope to access the mantis db for more advance operation if you need do some complex operation for them.

The steps:

1.  Download a mysql client tools. ( I recommend you to use toad for mysql, you can download it from, and it's totally free)

2.  Submit a request to Vincent ( HP network Admin in Innolux project) to register your pc for access the mantis db. The only information you need sumbit is your pc name.  If you really need access mantis db in your job, pls let me know your pc name, I will do it for you.

3. Connect to mantisdb with the following information


Database: bugtracker

Username: luke


4.  Execute your SQL in your mysql client tool

Additionally, you can download myODBC from

It can help you to create a ODBC DNS to access mysql database if you wanna write some vb program to access it. E.G. I made a VBA macro to get bug detail information according to bugid in excel file.

Here is a chinese mysql manual:

The following sqls is used to query bug detail by date.

SELECT, a.severity, a.summary, a.category, a.status,
 a.date_submitted, a.last_updated,b.value,IFNULL(c2.username,'') as assigner,
  c1.username as reporter, a.duplicate_id,,
  (TO_DAYS(now()) - TO_DAYS(a.last_updated)) as notfollowed
 mantis_bug_table a left join mantis_user_table c2 on a.handler_id =,
 bugtracker.mantis_custom_field_string_table b,mantis_user_table c1, mantis_project_table prj
     a.ID = b.bug_id
     AND a.reporter_id =
     AND = a.project_id
     AND in ('Beluga MES','Production_Array','Production_Cell','Production_CF')
     AND a.status NOT in (80,85,90)
     AND DATE_FORMAT(a.date_submitted, '%Y-%m-%d') < '2005-01-01'
ORDER by desc





Berkeley DB——Java and .Net and Some Applications

berkeley db——java and .net and some applications introduction berkeley db在c/c++环境下使用是十分方便的,尤其是使用c时...

dplyr do: Some Tips for Using and Programming

This post was originally posted on Quantide blog. Read the full article here. If you want to comp...

How to configure ODBC DSN in Client to access remote DB2 for Windows

This article introduces how to configure ODBC DSN in Client to access remote DB2 for windows in deta...

Data access between different DBMS and other txt/csv data source by DB Query Analyzer

In this essay, I will show you an example about data access between different DBMS and other txt/csv...

C#连接Access、SQL Server、Oracle、MySQL、DB2和SyBase数据库的代码集

C#连接六类数据库的代码集 本文列出了C#连接Access、SQL Server、Oracle、MySQL、DB2和SyBase六种不同数据库的程序源码

Access和sql server的语法区别 (包括db2 oracle)

Access和sql server的语法区别 (包括db2 oracle) 收藏 Access和sql server的语法区别 一、有区别的函数及解决方案 以下所示的解决方案中的函数定义在untDat...