Databases| SQL| MySQL| Questions? | Software Development

Mysql Multiple Date Insert

Mysql Multiple Column Insert is used to add or insert multiple data to the table.

Mysql Multiple Date Insert

Mysql Multiple Column Insert is used to add or insert multiple data to the table.

Understand with Example

The Section of Tutorial illustrate an example from 'Mysql Multiple Column Insert'. To understand an example we create a table 'Employee' with required fieldname and datatype respectively.

Query for creating table:

mysql> CREATE TABLE Employee(
    ->              Empid int(10),
    ->              Empname varchar(60),
    ->              Salary int(90),
    ->       DOB date
    ->            );
Query OK, 0 rows affected (0.01 sec)

Query for Multiple insertion of data in table:

The Query insert into is used for Multiple insertion of data in table 'Employee'.

The Query is used

mysql>     INSERT INTO Employee (Empid,Empname,Salary,DOB) VALUES
    ->                                          (01,'Habib',2014,20041202),
    ->                                          (02,'Karan',4021,20030411),
    ->                                          (03,'Samia', 22,20080223),
    ->                                          (04,'Hui Ling', 25,20081015),
    ->                                          (05,'Yumie', 29,19990126);
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query to view data inserted in table:

To view the records from table employee we use select query to retrieve the table 'employee'details.

mysql> select * from employee;

Output:-

+-------+----------+--------+------------+
| Empid | Empname  | Salary | DOB        |
+-------+----------+--------+------------+
| 1     | Habib    | 2014   | 2004-12-02 |
| 2     | Karan    | 4021   | 2003-04-11 |
| 3     | Samia    | 22     | 2008-02-23 |
| 4     | Hui Ling | 25     | 2008-10-15 |
| 5     | Yumie    | 29     | 1999-01-26 |
+-------+----------+--------+------------+
5 rows in set (0.00 sec)

ť View all related tutorials

Related Tags: sql mysql c table sed tab if ie record records to ci e use trie pe from m tr spec

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.