Programmer's mysql database auxiliary tool _ MySQL

Programmer's mysql database auxiliary tool bitsCN.com

Programmer's mysql database auxiliary tool

This database auxiliary tool (1.0) is fully open-source and is a database auxiliary tool developed according to your company's needs. This tool is mainly used to help programmers quickly find database field information, improve development efficiency.

The following describes how to use the tool:

1. click to open the database auxiliary tool, click the database menu, connect to the database, fill in the specific information, and then connect.

2. then, you can query the database. If no table name or field name is specified, click query to query all records. if only the table name is specified, query by table; query by field name if only the field name is entered; query by field name if both are entered, the full name of the table name or field name is entered, exact query. if you want to perform fuzzy query, you can use % id % in the box to perform fuzzy query.

3. click the clear button to clear all the information in the box and the number of items to be queried.

4. after selecting the information in the tableview, click delete to delete the selected entries (one or more entries). However, you can only delete the selected table view, rather than deleting the information in the database.

5. if you want to delete the information in the database, click "information processing" to delete the information. before deleting the information, select a record in tableview (you cannot delete multiple records to prevent accidental operations)

6. click add information in information processing to add information to the database.

7. if you need to disconnect, click "disconnect" in the database.

Write the following information about the database:

By default, mysql is used for databases.

The database name does not need to be defined, and can be defined casually in the connection.

You cannot select a table name for this version 1.0. you need to fix the table name:

yckj_db_tb_infoCREATE TABLE `yckj_db_tb_info` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `tb_name` char(20) NOT NULL,  `db_name` char(20) NOT NULL,  `field` char(20) NOT NULL,  `field_type` char(10) NOT NULL,  `field_size` varchar(8) DEFAULT NULL,  `field_key` varchar(30) DEFAULT NULL,  `field_comment` varchar(30) DEFAULT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `db_tb_field_uni` (`tb_name`,`db_name`,`field`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=gbk

BitsCN.com