Create a creattable instance in mysql

Creating a table creattable in mysql is the most basic syntax. This article describes how to create a table in mysql through examples. For more information, see. Example 1: create the most basic table (a manong table is created below)

Create table manong (id int not null, category char (20 ));

Example 2: create a table with a primary key

Create table manong (id int not null primary key, category char (20 ));

The above instance creates a mangnong table, which has two fields: id and category, where id is the primary key.