How to use statements to create tables in navicat 8 for mysql

Navicat is a fast database specially designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized businesses. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access and share information in a secure and easy way. Below we will introduce to you how to use statements to create tables in navicat.

Recommended tutorial: Navicat graphic tutorial

##1. First open navicat and select the database to be operated.

2. Click Query and select New Query

3. Enter the sql to create the table here Statement

CREATE TABLE IF NOT EXISTS `tbl`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `title` VARCHAR(100) NOT NULL,
   `author` VARCHAR(40) NOT NULL,
   `date` DATE,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

Click to run

4. Refresh the database and you will see the table tb1 we just created.

The above is the detailed content of How to use statements to create tables in navicat 8 for mysql. For more information, please follow other related articles on the PHP Chinese website!