Home > Database > navicat > body text

How to create a new table in navicat

angryTom
Release: 2019-08-05 14:19:37
Original
7557 people have browsed it

How to create a new table in navicat

Navicat for mysql is a visual management tool for mysql database. Here is a simple example of how to use navicat for mysql to create a table.

Recommended tutorial: MySQL introductory video

1. First create a database, let’s call it userdemo

2. 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 will be automatically increased.

How to create a new table in navicat

How to create a new table in navicat

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

How to create a new table in navicat

How to create a new table in navicat

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

How to create a new table in navicat

5. 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 new table in navicat

#6. 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 new table in navicat

#7. 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 before we The primary key is set to auto-increment.

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 new table in navicat

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

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!