I have a DB with two tables: employees table: fields = {ID, name} turnShift table: fields = {ID, date, ID_employee1, ID_employee2} Here is an example of this DB. Using MYSQL, I'd like to execute a SELECT query able to show…
Let's say I have 3 DB tables in MySQL: t1 t2 t3 And each of them has the same columns I am interested in. And also each of them has some other columns that I am not interested in. Now,…
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…