I got a files table: CREATE TABLE files ( id SERIAL PRIMARY KEY, path VARCHAR NOT NULL UNIQUE ); And I wanna write an sql transaction to emulate FS behavior when you tryna create a file: if a file with…
I have a table with columns: KEY1, KEY2, KEY3, KEY6, PLT_ID There are rows where different KEY6 values have other (KEY1, KEY2, KEY3, PLT_ID) same, like: KEY1 KEY2 KEY3 KEY6 PLT_ID 1 1 1 X 1 1 1 1 Y…
I am clear on how GROUPING SETS (and ROLLUP and CUBE) work for a single expression. However, I've never entirely understood how it works when multiple GROUPING SETS are combined. Here is an example table that I've created to help…
I have a query: select count(*) from transaction_entry inner join inventory_item on inventory_item_id = inventory_item.id inner join transaction on transaction_id = transaction.id inner join product on inventory_item.product_id = product.id when adding the last inner join, so to product table, the…
I have two tables T1 and T2. I'm doing a simple inner join select t1.a, t1.b, t1.c from T1 t1 inner join T2 t2 on t1.c = t2.c Table T1 has got 2 million rows and T2 has got 4…
In an SQL function I want to create multiple records based on the parameters passed into the function, for example the function takes a member primary ID, a date/time stamp and a number specifying the number of records to create.…
I have three tables 1.) Students (id,firstName,Surname,email) 2.) Course_Student(student_id, course_id) 3.) Courses (id, name, classroom_id) I need to select all students, which have count of curses more or equal = 3. I contstruct this select and it seems that it…
I have codes see below which is works. $city = City::find(1); $city->location = DB::raw('geomfromtext('point(' . $location . ')')'); $city->save(); Question 1: Is there SQL injection issue in the codes above because I using DB::raw() which sticking the string(variable) in without…
On a website with roughly 10k orders, our order search takes on average 20 seconds to complete while searching for order number. This is the sql-query that is slow SELECT DISTINCT p1.post_id FROM nb_postmeta p1 WHERE p1.meta_value LIKE '%ordernumber%' AND…
I am receiving this error message. ERROR: there is no unique constraint matching given keys for referenced table "Employees" This is what I have run: -- Exported from QuickDBD: https://www.quickdatabasediagrams.com/ -- Link to schema: https://app.quickdatabasediagrams.com/#/d/Sa6Ijr -- NOTE! If you have…