I have a parent table and a child table. A parent row stores the foreign key to the child row. If I set the constraint on the foreign key to ON DELETE CASCADE then that will throw an error when…
I'm having a reoccurring error in my SQL statement, and I cannot figure out how to fix it. The ERROR: syntax error at or near "WHERE" is not very helpful as well. This is the code snippet in question: INSERT…
Let's assume I have a table with 3 columns: Id, Value, date Time. I need to find the min, max, first and last value of each 1 minute window between the provided start and end time. And in case no…
I am practising SQL on leetcode (Using MySQL) and came across the following problem - where I am confused on why my solution does not work. The following is an employee table where it shows which department(s) an employee is…
I have a table in mysql like this: id userID idRef userIDRef 1 30 2 100 2 100 0 0 3 30 6 100 5 30 7 100 7 100 0 0 10 30 8 100 In php I want…
I have a couple of tables which have information about an activity(like an article), how do I get a column back that spits out a value based on some condition Learner Certificate view dt First 2023-10-09 Second 2024-01-03 Learner Certificate…
I am trying to amend the value of a key in a table. I have a database (this is for Immich if relevant). See below details of the table. I am trying to amend "library.watch.usePolling" from "true" to "false". I…
Input: consecutive numbers from 1 to 100 - 1,2,3,...,100 Desired output: 1st group: 1, 2, 3, 4, 5 -> sum 15 (not bigger than 20) 2nd group: 6, 7 -> sum 13 (not bigger than 20) 3rd group: 8, 9…
Creating a Auto Generation ID with Prefix in MySQL Without Using Trigger I need Creating a Employee Id with Prefix and Without Using Trigger in MySQL.
I have 3 billion IPs stored in the following ip_location table. CREATE TABLE ip_location ( id BIGINT AUTO_INCREMENT PRIMARY KEY, ip VARCHAR(15) NOT NULL, country VARCHAR(2), region_1 VARCHAR(255), region_2 VARCHAR(255), latitude DECIMAL(10, 6) NOT NULL, longitude DECIMAL(10, 6) NOT NULL,…