Shulou(Shulou.com)06/01 Report--

In the last article, the editor shared with you how to connect to a database remotely in Navicat. Friends who don't have time to get on the bus can poke this article: configure mysql remote connection tutorial in Ubuntu14.04. Today, the editor will share with you how to create new databases and tables in Navicat.

Friends who have used the remote connection database tool know that it is not too difficult to create new databases and tables in Navicat, as shown in the following tutorial. Here we still take the host database with IP address 192.168.255.131 as an example.

1. Log in to Navicat first, and then connect to the database smoothly, as shown in the following figure.

2. Right-click on the database with IP address 192.168.255.131, and then click "New Database", as shown in the following figure.

3. Then pop up the "New Database" dialog box, and you need to set the database name, character set and collation in the "General" tab.

4. Under normal circumstances, it is recommended that the database name should be named in English, the character set should be utf8, and the collation should be utf8_general_ci. Here, name the database scrapyspider, select utf8 for the character set, and select utf8_general_ci for the collation, as shown in the following figure. Click OK when the settings are complete.

5. After that, you can see that the scrapyspider database has been created successfully. Click on the scrapyspider database and you can see that no tables have been created at this time.

6. Click "Table" on the left tab, then right-click to select "create New Table", and then the new table interface in the following figure will pop up.

7. Add a field in the "name" column, then select the type and length, set the decimal point and whether null values are allowed, as shown in the following figure. If you want to add fields, click "add Fields".

8. In the following picture, as a demonstration. Three fields, time, name, and id, are added, and id is set as the primary key, as shown in the following figure.

9. After the setup is complete, press the shortcut key Ctrl+s, save the contents of the settings, and pop up the table name menu, as shown in the following figure. You need to enter the table name in the table name window, name the table article here, and then click OK.

10. After saving, you can see that the table name has changed from the previous "untitled" to the current article, and you can see the fields set.

11. Then enter the content in the field. Enter the time under the time field, enter dcpeng under the nam field, and set the id field to 1. 0. Press the shortcut key Ctrl+s when the settings are complete, and save the settings, as shown in the following figure.

12. Click "query" in the Navicat tab, then click "New query", and then the query window pops up, as shown in the following figure. No SQL statements are currently entered.

13. Enter the SQL statement in the query window to search, as shown in the following figure, in an attempt to query the data in the article table. After the SQL statement is written, click the "run" tab, and the query results will be displayed in the same window, as shown in the following figure.

14, of course, right-click article, you can see that there are many more operations about the table, so I won't repeat them here.

The tutorials on database building, table building and simple query in Navicat have been completed. I hope it will be helpful to your study.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.