Programmer's mysql database auxiliary tool

Source: Internet
Author: User

Programmer's mysql database auxiliary tool this database auxiliary tool (1.0) is completely open source and is a database auxiliary tool developed according to your company's needs, this tool helps programmers quickly search for database field information and improve development efficiency. The following describes how to use the tool: 1. Click to open the auxiliary database 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, all information in the box on the interface is cleared, and the number of items displayed in the query is also 4. After selecting the information in tableview, click Delete, the selected entries (one or more entries) are deleted, but only in the tableview, rather than 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. To disconnect a database, click "Disconnect" in the database to write the database information: mysql is used by default. 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

 


Related Article

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.