Shulou(Shulou.com)06/01 Report--

This article is about navicat's method of creating tables using sql statements. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

Select a database, click "Query," click "Create Query" on the right, enter SQL statements, click "Execute" on it.

Example 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; Thank you for reading! About navicat with sql statement to create a table method to share here, I hope the above content can be of some help to everyone, so that we can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.