Home> Database> navicat> body text

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

yulia
Release: 2018-09-26 16:39:49
Original
12112 people have browsed it

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;

Detailed graphic explanation of how to use commands to create databases and tables in navicat3. Open the command interface;

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

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

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

##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;

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

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));

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

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!