MariaDB Request

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Hello,

i have on my Debian Server MariaDB running.

Now i need a Request to check the days beetween rows.

i have attached a example database.

in the result i want to see as example all dates between the rows who are shorter than 3 days in room 4 ( see attached image )

example result: 4 20201220 20202022

Sysinfo: Ver 10.1.47-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 (Debian 9.13)

Linux PHP MariaDB

Project ID: #28333362

About the project

6 proposals Remote project Active 3 years ago

Awarded to:

pawelwtorek

Hi, Can you clarify: do you need query to show dates between rows or between columns (from and to) ? This is not the same, but i suspect you need difference between columns (from and to) I recommend myself regards

€19 EUR in 1 day
(1 Review)
1.8
ksab

The check can be done using PHP code after reading the values from the database. please let me know if the difference of days you are check is from the from date and to date or the difference between end date of one r More

€19 EUR in 1 day
(22 Reviews)
4.0

6 freelancers are bidding on average €24 for this job

kreativesystem91

Hi, nice to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Cheers

€15 EUR in 7 days
(65 Reviews)
5.0
gattes

Hi there, I have over 10 years of work experience with Linux and DBs I think I can help you with this. Ping me and I'll do so. Cheers mate.

€30 EUR in 1 day
(17 Reviews)
4.4
naasirlampard

I am an employee who is ready to help or assist you in his or her work; I am an IT designer, Video editor, Web designer & Developer, Programmer, Big IT networker and many more. I studied Computer Science & Network Cybe More

€19 EUR in 7 days
(0 Reviews)
0.0