This is how statements are used to build tables in navicat 8 for mysql

This article mainly introduces how to use sentences to build tables in navicat 8 for mysql. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

Navicat is a fast set 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 enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way, and how to use statements to build tables in navicat.

1. First open navicat and select the database you want to operate.

two。 Click query and select New query

3. Enter the sql statement to create the table here

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 can see the table tb1 we just created.

The above is all the contents of the article "using sentences to build tables in navicat 8 for mysql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!