How to add records to the table in navicat

To add records to a table in Navicat, you only need to perform three steps: open the table, insert new records, and save changes.

How to add records to the table in Navicat

It is very simple to add records to the table in Navicat. Just follow these steps:

Step 1: Open the table

• In Navicat, navigate to the database and schema that contains the target table.
• Right-click the table and select Open.

Step 2: Insert new records

• In table data view, scroll down to the end of the table.
• Click on the blank row at the end of the table.
• Enter the field value of the record.

Step 3: Save changes

• Click the Save Changes icon (green checkmark) in the toolbar.
• Alternatively, press F2 on your keyboard.

Advanced options

• Using the INSERT statement: You can also use the SQL INSERT statement to insert records into the table. In the Query tab, write the insert statement and click Execute.
• Batch Insert: To insert multiple records at the same time, please use the "Batch Insert" option in the "Import Wizard".
• Auto-generated values: If there are automatically-generated values ​​(such as auto-increment columns) in the table, Navicat will automatically generate these values ​​during insertion.

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