How to use Netbeans to operate MySQL database (3) [figure] _ MySQL

Methods for using Netbeans to operate MySQL databases (3) [figure] TIP: We often use databases during development to perform various operations on databases, thanks to the support of various mainstream databases in the integrated development environment of Netbeans, our developers can easily use Netbeans for project development, saving a lot of time and bringing convenience. First, make sure that netbeans and mysql are installed on the computer. I am using netbeans6.5 and mysql5.

Here, Tables is the table created in the yang database, Views is the view, and procedures is the stored procedure. here we can intuitively see the structure of the database, you can perform various operations on the mysql database through netbeans.

3. Database operations

To view the data in the person table, right-click "person" and select "view data". the combined form is displayed immediately. The preceding is the SQL editor. The following is a data display box, for example:

Here we can clearly see that the person table has two pieces of data. of course, we can also write SQL statements in the preceding SQL editor to query the data we need, here, we can perform a lot of operations on mysql database functions under the command line.