Home > Database > navicat > How to use statements to create tables in navicat 8 for mysql

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

angryTom
Release: 2019-08-10 17:01:38
Original
8583 people have browsed it

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.


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

2. Click Query and select New Query

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

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;
Copy after login

Click to run


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

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

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

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!

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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template