Home  >  Article  >  Database  >  How to create a table in navicat

How to create a table in navicat

angryTom
angryTomOriginal
2019-08-19 11:28:1827082browse

How to create a table in navicat

Navicat is a set of fast, reliable and relatively cheap database management tools, designed to simplify database management and reduce system management costs. Below we will introduce to you how to use naviact to create a data table.

Recommended tutorial: navicat graphic tutorial

##First create a database and name it userdemo.

How to create a table in navicat

How to create a table in navicat

Create a table in the newly created database, as shown below. The first column of the table is called userid. The primary key is set to not be empty and is automatically increased.

How to create a table in navicat

How to create a table in navicat

Add a new column to the table by adding a field.


How to create a table in navicat

How to create a table in navicat

After the table data is designed, you can click Save.

How to create a table in navicat

Expand userdemo and you will see the table you just created. Double-click to open the table and add data to the table.

How to create a table in navicat

After adding data, if you want to add or delete a piece of data, click the icon as shown in the picture.

How to create a table in navicat

In a piece of data, you can only enter the values ​​​​of username and password, but when you Ctrl s to save it will automatically add the value of userid, because we set it before The primary key is automatically incremented. After you add a piece of data to save, as shown in the figure, you will see the statement it inserted.

How to create a table in navicat

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

Statement:
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