The method of using commands to create databases and tables in navicat

This article will explain in detail how to use commands to create databases and tables in navicat. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Navicat for MySQL is a powerful database management and development tool designed for MySQL. Navicat allows you to create, organize, access and share information quickly and easily in a secure and easy way.

1. Open [navicat] first, and select "File"-> "New connection"-- > "MySQL" in the menu bar.

two。 Then right-click the connection you just created, select Command Line Interface, and open the command line interface.

3. Open the command interface

4. First create the database with the command: CREATE DATABASE

5. Then right-click the connection you just created and select "Refresh" to see the database we just created. (sometimes you need to restart the navicat software to see the created database)

6. Next, to create the table, select the database first, with the command: use test1

7. And then we started to build tables.

Mysql > CREATE TABLE Product

-> (product_id CHAR (4) NOT NULL

-> product_name VARCHAR (100) NOT NULL

-> product_type VARCHAR (32) NOT NULL

-> sale_price INTEGER

-> purchase_price INTEGER

-> regist_date DATE

-> PRIMARY KEY (product_id))

8. Refresh the database to see the newly created table (sometimes you need to restart the navicat software to see the created database)

This is the end of the method of using commands to create databases and tables in navicat. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.