Detailed graphic explanation of how to use commands to create databases and tables in navicat

Navicat for MySQL is a set of powerful database management and development tools designed specifically for MySQL. Navicat allows you to quickly and easily create, organize, access and share information in a safe and easy way. This article mainly introduces how to use commands to create databases and tables in navicat. Interested friends should continue reading.

1. First open [navicat], select [File]-->[New Connection]-->[MySQL] in the menu bar;

2. Then right-click just now Create a connection, select [Command Line Interface] to open the command line interface;

3. Open the command interface;

4. First create Database, the command is: CREATE DATABASE ;

##5. Then right-click the connection just created and select [Refresh], you can see that we just Created database; (sometimes you need to restart the navicat software to see the created database)

6. Next, we create the table. We must first select this database. The command is: use test1;

7. Then we start to create the table

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 You can see the newly created table (sometimes you need to restart the navicat software to see the created database)

The above is the detailed content of Detailed graphic explanation of how to use commands to create databases and tables in navicat. For more information, please follow other related articles on the PHP Chinese website!