I have a problem. I want to create a calculated column call ExpectedOutcome . The value of column ExpectedOutcome for 1st row where No.Session = 1 is calculated by Score + 60. From the second row, the value of ExpectedOutcome…
I am creating something like google drive or some cloud using PHP and HTML where you can save your files but i have problem with saving files to binary code and uploading it to database. I mean i want to…
Route Incident delay_minute 63 Operator 60 63 Operator 24 63 Mechanical 89 54 Operator 70 54 Sanitation 34 54 Operator 12 From the example table above, I want to return one row per route with their most common type/form of…
I have this date format : YYYY-MM-DD (example : 2022-05-10) I want to extract only last 6 months inclunding current months. The result normaly it's : june, july,august, september, octobre, november (6 last months) I do this request : Select…
I have this code snippet which will delete all rows in the user_interests table. I have a parameter of int id which is user id. I want to pass this parameter to my SQL statement. I have tried using "....…
I am new to PHP and HTML and trying the below. The below html code displays data from the database and add a calendar as row. The calendar displays current date by default. When changed, the changed date should be…
language: Python 3.7.0 mysql-connector-python==8.0.31 I'm working on a website and have just implemented a database. The response I'm getting from the database looks like this: [('indigo', 'admin')] How do I extract the two values from the tuple in a list…
At a workplace they recycle punchcard ids (for some strange reason). So it is common to have past employees clashing with current employees. As a workaround I want to have employee punchcard id, employee name+surname as the unique primary key…
I am trying to update a column in the mainDB table, based on data in the engine table. The date in the main DB table is stored in (YYYY-MM_DD) format and I want to subtract only the year I'm not…
Given a currency table I need to find the latest record of conversion rate which is less than given particular date Input table structure given below: id baseCur Curr rate date 1 INR USD 81 2022-11-09 2 INR USD 82…