Multiple data input at the same time in MySQL?

Following is the syntax −

insert into yourTableName values(yourValue1,yourValue2,.....N),
(yourValue1,yourValue2,.....N),
(yourValue1,yourValue2,.....N),
(yourValue1,yourValue2,.....N),
.
.
.
N

Let us create a table −

mysql> create table demo56
−> (
−> id int,
−> first_name varchar(20),
−> last_name varchar(20),
−> age int
−> );
Query OK, 0 rows affected (1.91 sec)

Insert some records into the table with the help of insert command −

mysql> insert into demo56 values(1,'John','Smith',23),
−> (2,'David','Miller',21),
−> (3,'Chris','Brown',22),
−> (4,'Carol','Taylor',20);
Query OK, 4 rows affected (0.10 sec)
Records: 4 Duplicates: 0 Warnings: 0

Display records from the table using select statement −

mysql> select *from demo56;

This will produce the following output −

+------+------------+-----------+------+
| id   | first_name | last_name | age  |
+------+------------+-----------+------+
|    1 | John       | Smith     |   23 |
|    2 | David      | Miller    |   21 |
|    3 | Chris      | Brown     |   22 |
|    4 | Carol      | Taylor    |   20 |
+------+------------+-----------+------+
4 rows in set (0.00 sec)

AmitDiwan

Published on 20-Nov-2020 07:04:22

• Related Questions & Answers
• How to show multiple Canvases at the same time in Tkinter?
• What are the best tricks to manage multiple tasks at the same time?
• How to identify multiple elements at the same time in Selenium with python?
• How to add a number to a current value in MySQL (multiple times at the same time)?
• Need to update MySQL and SAP database at the same time from a Form
• How to catch many exceptions at the same time in Kotlin?
• Can I play the same sound more than once at the same time with HTML5?
• How to find the groupwise mean and groupwise sum at the same time in an R data frame?
• How can we create multiple MySQL triggers for the same trigger event and action time?
• How to multiple insert or batch insert at a time in MySQL query?
• How to select at the same time from two Tkinter Listbox?
• How can one believe in science and religion at the same time?
• How to extend and implement at the same time in Kotlin?\n
• In which order MySQL will invoke the triggers if we created multiple triggers of same event and action time?
• Multiple Input Multiple Output (MIMO)