Home Sql Sql-functions Mysql Multiple Date Insert

Mysql Multiple Date Insert
Posted on: January 16, 2009 at 12:00 AM

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)

Related Tags for Mysql Multiple Date Insert:
sql, mysql, c, table, data, insert, multiple, sed, column, ip, tab, add, to, e, multi, use, ul, in, m, dd, ad, umn, s, tip, col, at, my, is, rt, s, s, th, ab, abl, lum, ipl, ple, pl, ol, o

«Previous Index Next»