Navicat Premium Usage Tutorial "more detailed"

Navicat Premium Usage Tutorials

Summary: Navicat Premium is a well-known database operating software. This article is more detailed.

1. Open Navicat Premium, click Connect, select MySQL, create a new connection. Enter the user name and password to install MySQL. Click OK.

650) this.width=650; "src=" Http://image.mamicode.com/info/201503/20180919125955478765.png "/>

2. The admin data connection has been created successfully. The following is a new database for admin, enter the database name. Confirm.

650) this.width=650; "src=" Http://image.mamicode.com/info/201503/20180919125955596934.png "/>

3. Add a data table to the database, where the data table is created automatically from the creation statement of the data table. The SQL statement that created the data table is found in the project directory first.

650) this.width=650; "style=" width:658px; src= "Http://image.mamicode.com/info/201503/20180919125955746353.png"/ >

4. In Navicat Premium Select the database you just created, select query, new query, copy the SQL statement in the third step into the Query Editor, and click Run.

650) this.width=650; "style=" width:658px; src= "Http://image.mamicode.com/info/201503/20180919125955895773.png"/ >

5, save, enter the data table name.

650) this.width=650; "src=" Http://image.mamicode.com/info/201503/20180919125956108672.png "/>

6. You can now find the newly-created data table in the database.

650) this.width=650; "style=" width:658px; src= "Http://image.mamicode.com/info/201503/20180919125956240513.png"/ >

7, to this, the use of SQL statements to create a data table completion.

The above note is only a personal study of the memo record, such as to help people in need better, God please mo spit groove! Thank you!

Navicat Premium Usage Tutorial "more detailed"