2. Operate the database with Mysqlworkbench

Open Mysqlworkbench:

650) this.width=650; "style=" width:476px;height:328px; "width=" 476 "src=" http://s2.51cto.com/wyfs02/M02/7E/DD/ Wkiom1clmqsdr9n4aadzmin6dma705.png "title=" 1.png "height=" 328 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1clmqsdr9n4aadzmin6dma705.png "/>

1. Establish the connection

Clicking on the "+" new connection after MySQL connections will bring up the following views:

650) this.width=650; "style=" WIDTH:500PX;HEIGHT:327PX; "width=" src= "Http://s5.51cto.com/wyfs02/M00/" 7e/dd/wkiom1clmszt8gqtaaqa-lvrhmc570.png "title=" 2.png "height=" 327 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1clmszt8gqtaaqa-lvrhmc570.png "/>

Fill in the Connection name Connection name; Username; Then fill in the user password, click OK to complete, workbench view into the following style:

650) this.width=650; "style=" width:500px;height:298px; "width=" src= "http://s5.51cto.com/wyfs02/M02/7E/DB/" Wkiol1clml2jhsajaamhsqggk0c661.png "title=" 3.png "height=" 298 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1clml2jhsajaamhsqggk0c661.png "/>

Click on the newly created connection to proceed further.

2. Create a database

To confirm the MySQL service startup, Click on the newly established connection "TestDB" to open the following view:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7E/DB/wKioL1cLMmLBdVryAAX4C5LZ6hA197.png "title=" 4.png " Width= "height=" 347 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:500PX;HEIGHT:347PX; "alt=" Wkiol1clmmlbdvryaax4c5lz6ha197.png "/>

Click on the Fourth button of the toolbar "650" this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/7E/DE/ Wkiom1clmx6dr3cyaaaabncuxc4178.png "title=" 5.png "width=" to "height=" to "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:31px;height:31px; "alt=" Wkiom1clmx6dr3cyaaaabncuxc4178.png "/>", add the database, shown as follows:

650) this.width=650; "style=" width:500px;height:413px; "src=" http://s2.51cto.com/wyfs02/M02/7E/DD/ Wkiom1clmqqb8yvuaadhzmy8oao258.png "title=" 6.png "width=" "height=" 413 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1clmqqb8yvuaadhzmy8oao258.png "/>

Fill in the database name, here I named "jsp_db", and then click on the "Apply" button to submit.

650) this.width=650; "style=" WIDTH:500PX;HEIGHT:357PX; "width=" src= "http://s1.51cto.com/wyfs02/M00/7E/DB/" Wkiol1clnbybhda5aativqup7es947.png "title=" 7.png "height=" 357 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1clnbybhda5aativqup7es947.png "/>

Pop the above view and continue to apply.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7E/DB/wKioL1cLNHmQpVdOAAQYWgR_1yw236.png "title=" 8.png " Width= "height=" 357 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:500PX;HEIGHT:357PX; "alt=" Wkiol1clnhmqpvdoaaqywgr_1yw236.png "/>

Build a library of libraries successfully.

At this point, if you need to set this database as the default database, then:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/DB/wKioL1cLNB-wu19xAAIIiFHNNO4074.png "title=" 9.png " Width= "height=" 441 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:300px;height:441px; "alt=" Wkiol1clnb-wu19xaaiiifhnno4074.png "/>

Select the newly created database "jsp_db" in the view, right-click and select the first "set as Default Schema".

3. Set up a data sheet

650) this.width=650; "Width=" "style=" width:500px;height:321px "src=" http://s1.51cto.com/wyfs02/M00/7E/DB/ Wkiol1clnm-hw7vxaanrvpp-w4y089.png "title=" 10.png "height=" 321 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1clnm-hw7vxaanrvpp-w4y089.png "/>

Write a table script and save it. Then click on "650" this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7E/DB/wKioL1cLNTPjyThoAAASveozMqU240.png " Title= "11.png" width= "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:31PX;HEIGHT:27PX; "alt=" Wkiol1clntpjythoaaasveozmqu240.png "/>" icon is executed.

Click:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7E/DE/wKiom1cLNJ_QcjyxAABST5l6-o0090.png "title=" 12.png "Width=" 324 "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:324px;height:80px; "alt=" wkiom1clnj_ Qcjyxaabst5l6-o0090.png "/>

The Refresh button in the

To refresh the schemas, you can see the new table:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7E/DB/wKioL1cLNbLDh1TEAABqwaZa62U308.png "title=" 13.png "Width=" height= "171" border= "0" hspace= "0" vspace= "0" style= "width:300px;height:171px;" alt= " Wkiol1clnbldh1teaabqwaza62u308.png "/>

4, data table operation--New data row

INSERT into Tbl_user (ID, uname, upassword, email)

Values

(1, ' xiaoming ', ' 123456 ', ' [email protected] '),

(2, ' Xiaozhang ', ' 123456 ', ' [email protected] ');

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7E/DE/wKiom1cLNCGgslJzAAKLgIZxewc327.png "title=" 14.png "Width=" "height=" 294 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:500px;height:294px; "alt=" Wkiom1clncggsljzaaklgizxewc327.png "/>

This article from "Woody Rose" blog, reproduced please contact the author!

2. Operate the database with Mysqlworkbench