How to create a table using sql statement in navicat

Select a database, click "Query", click "Create Query" on the right, enter the SQL statement, and click "Execute".

Related recommendations: "Navicat for mysql graphic tutorial"

Sample SQL:

CREATE TABLE `test`.`users` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`age` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The above is the detailed content of How to create a table using sql statement in navicat. For more information, please follow other related articles on the PHP Chinese website!