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