mysql sql query needing to be written

กำลังดำเนินการ โพสต์แล้ว 6 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
กำลังดำเนินการ ชำระเงินเมื่อจัดส่ง

im having issues with an sql statemetn

i have

select *

from analysis_heart_rate

where heart_rate_id between (heart_rate_id and heart_rate_id + 6)

and heart_rate_timestamp between (heart_rate_timestamp and TIMEDIFF(heart_rate_timestamp , "5:00") )

i have a database whcih records who is wearing a belt every second. basicallay i want, for a "belt_no", if i select a person wearing this belt at say 12midday, i want the belt being allocated to this person for the next five minutes. Given we are recording who is wearing a belt every second, there will be hundreds of records updated by selecting one person. So bascially every record from 12midday to 12:05 will automatically be allocated to this player.

การบริหารฐานข้อมูล การเขียนโปรแกรมฐานข้อมูล MySQL PHP SQL

หมายเลขโปรเจค: #16121729

เกี่ยวกับโปรเจกต์

29 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

bhanderirakesh

I will done your job very quickly and easily sir...............................................................................................................

$12 AUD ใน 1 วัน
(48 รีวิว)
4.4

freelancer 29 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $26

liangjongai

I am a full time developer and have high skills in mysql so I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

$25 AUD ใน 0 วัน
(281 รีวิว)
7.9
codetod

Hi The query you have given will always return all row from the table because the condition heart_rate_id between (heart_rate_id and heart_rate_id + 6) is same as saying (5 between 5 and 11), and will be true for al เพิ่มเติม

$25 AUD ใน 1 วัน
(94 รีวิว)
6.7
schoudhary1553

Greeting, I have understood your mysql sql query task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Administration, Database Pr เพิ่มเติม

$30 AUD ใน 1 วัน
(58 รีวิว)
6.4
softcarve

Hi, I would like to write an sql query to get the records for 5 min belt. I have good proficiency in sql. Please go through my profile. Regards, Manish

$25 AUD ใน 1 วัน
(128 รีวิว)
6.3
spryox

I have 7 years of database experience and worked in 3 databases mysql, oracle & sybase so you can surely bet on me for the work. I am available for the work right away, lets get it done.

$15 AUD ใน 0 วัน
(147 รีวิว)
6.2
TenSidesDev

Hey, I haven't fully understood your problem, as you didn't say what you're having difficulties with.. but I'm good at DB stuff, so let me know if interested and I'll help you out. I speak fluent English so no wo เพิ่มเติม

$25 AUD ใน 1 วัน
(19 รีวิว)
4.9
point5nyble

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years, as an. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my tale เพิ่มเติม

$35 AUD ใน 1 วัน
(47 รีวิว)
5.2
deytps86

Interesting event. Can you give me describe analysis_heart_rate output. Or if we can directly talk over the chat? Thanks!

$30 AUD ใน 1 วัน
(12 รีวิว)
4.1
sreenivas2903

HI I will fix this today , need more inputs , as this would be my first freelancing work i am bidding too low , please make a good review once i finish this work.

$15 AUD ใน 0 วัน
(16 รีวิว)
4.4
gayatriprods

We understand your requirement and will be glad to assist you. However, you will have to provide more details about the table which stores the belt information so that we can use it to derive the solution. Kindly con เพิ่มเติม

$30 AUD ใน 1 วัน
(5 รีวิว)
3.3
bnrajumnc

A proposal has not yet been provided

$66 AUD ใน 2 วัน
(7 รีวิว)
3.6
nagraphics5

Hi, I am web developer and full knowledge of MySQL and able to do your job as per your requirement. I can start the work now, and can provide the best services. Waiting for your positive response Regards

$25 AUD ใน 1 วัน
(5 รีวิว)
3.1
mansiwork

I have read your job description carefully & your mysql Query issue. I have a good knowledge in mysql, can we have a quick discussion, so that we can discuss & fix that problem. Looking forward to you Thank you

$25 AUD ใน 1 วัน
(12 รีวิว)
2.9
katiewells3

Hi There, I am an Australian based technical business analyst with over a decade's commercial experience with SQL. Would love to help you with your statement (and anything else I could!)

$25 AUD ใน 1 วัน
(4 รีวิว)
2.3
athulskarun

Hello Sir. I have 4 years experience in MySQL. I can provide 100% quality work within the deadline at a very low rate. Besides I'm a Computer Engineer as well. So I know the work.

$25 AUD ใน 1 วัน
(3 รีวิว)
2.1
chinmayeeshepal

A proposal has not yet been provided

$15 AUD ใน 1 วัน
(0 รีวิว)
0.0
bobysiswanto

Please give your database structure or your entity relationship diagram and i will do your requirements.

$30 AUD ใน 1 วัน
(0 รีวิว)
0.0
Webnoobie

A proposal has not yet been provided

$25 AUD ใน 8 วัน
(0 รีวิว)
0.0
sfaridcste

i can write sql code for you! plese hire me for your project i can sincerely to do your task. i can write sql code for you! plese hire me for your project i can sincerely to do your task.

$25 AUD ใน 1 วัน
(0 รีวิว)
0.0
qixiaojie

Adds the integer expression interval to the date or datetime expression datetime_expr. The unit for interval is given by the unit argument, which should be one of the following values: MICROSECOND (microseconds), SECON เพิ่มเติม

$10 AUD ใน 1 วัน
(0 รีวิว)
0.0