How to insert data into mysql database separate row if calendar from and till date are selected means?

Question

0.00/5 (No votes)

See more:

i am having the data like Employee ID 123456 he is going on leave from the date of 26-11-2017 till 2-12-2017 .

i am have the MySQL database field names with EmployeeId LeaveDates
so i should get the data inserted in the below format like
EmployeeId LeaveDates
123456 26-11-2017
123456 27-11-2017
.
.
.
.
123456 2-12-2017 like this. can any one suggest me on above question..

What I have tried:

I am able to save the data with
employeeId FromDate Tilldate
123456 26-112017 2-12-2017
but i want separate row wise......

Posted 25-Nov-17 21:24pm

VIJAY KUMAR

Updated 26-Nov-17 8:26am

Add a Solution

Comments

Richard MacCutchan 26-Nov-17 3:46am

What exactly is the problem? The SELECT command should be able to find the records you want.

CHill60 26-Nov-17 6:25am

Can you try to explain your problem again. It is not clear

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

A_Griffin · Answer 1 · 2017-11-26T08:26:00

Solution 1

You can use multiple inserts[^]

SQL

INSERT tableName (EmployeeId,LeaveDates) VALUES 
(123456, '2017-11-26'),
(123456, '2017-11-27'),
...
(123456, '2017-12-01'),
(123456, '2017-11-02')

Posted 26-Nov-17 8:26am

A_Griffin

Updated 26-Nov-17 8:27am

v2

How to insert data into mysql database separate row if calendar from and till date are selected means?

1 solution

Solution 1

Add your solution here

Preview 0

How to insert data into mysql database separate row if calendar from and till date are selected means?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us