Get the App
SLTechnology News&Howtos  ›  Database  › 

Mysql adds multiple pieces of data through the command

Shulou Source: shulou.com Published: 2022-06-01 13:17:41 11月18日 Update

Mysql adds multiple pieces of data through the command

1. Syntax:

INSERT INTO table name (field 1, field 2... Field n)

VALUES

(worth 1, worth 2. Value n)

(worth 1, worth 2. Value n)

...

(worth 1, worth 2. Value n)

two。 Syntax parsing:

INSERT INTO... VALUES...: insert data into a table command

3. Example:

INSERT INTO

Student (name,sex)

VALUES

('xiaoxiao',0)

('xusu',0)

('yuanya',0)

4. Example screenshot:

Take a screenshot before adding data:

Screenshot of code execution:

Take screenshots after adding data:

Tags: Data screenshots fields commands examples syntax multiple code Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Shulou Information Xiaomi MySQL Linux