- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- Related Articles
- How to show multiple Canvases at the same time in Tkinter?
- How to add a number to a current value in MySQL (multiple times at the same time)?
- How to identify multiple elements at the same time in Selenium with python?
- What are the best tricks to manage multiple tasks at the same time?
- 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?
- Need to update MySQL and SAP database at the same time from a Form
- How to find the groupwise mean and groupwise sum at the same time in an R data frame?
- In which order MySQL will invoke the triggers if we created multiple triggers of same event and action time?
- How to extend and implement at the same time in Kotlin?
- How to catch many exceptions at the same time in Kotlin?
- Multiple Input Multiple Output (MIMO)
- Can an object be at rest and in motion at the same time? Give example.
- Can I play the same sound more than once at the same time with HTML5?
- Insert multiple data using SET clause in MySQL?

Advertisements