Programmer's mysql database auxiliary tool _ MySQL

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.