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…
I have a table with jsonb column, turns out storing a lot of json data in this column per row is taking too much space, with around 90M records this table has consumed around 167GB storage. Now I want to…
For the last few days, I have been working to write a MySQL query to extract a result. Basically, I have to join two tables log and conditions table based on any column of the log table from the trigger_param_value…
Problem Statement: We will be getting a request of a number (11 digits) and have to efficiently lookup in the database and return a single row (last updated) based on range in which it fits. Also, I have already used…
The data model is something like this: "_id":... "special_offers": [ 0 => Object, 1 => Object, ...] I just need to get 0 => Object, I mean, the first item of the special_offers array. Here is what I've tried: But…
I want to get the list of users who are new users vs returning user. Report is taken for every week. If user logs in for the first time in a week he is considered as new user,in a week…
Just wanted to make sure that I'm understanding this right: designing UML-diagram we are talking about the relations between entities? in the context of SQL a table is a relation? I can remember that my teacher, for a while ago,…
I want to download Daily NAV (Net asset Value) from AMFI Website for all the schemes and store all of it in MongoDB. But with my current code it is taking too long almost 5 days to download and push…
drop procedure if exists AddValidBooking; DELIMITER // CREATE PROCEDURE AddValidBooking(IN booking_date DATE, IN table_number INT) BEGIN DECLARE booked BOOLEAN; START TRANSACTION; SELECT CASE WHEN EXISTS ( SELECT 1 FROM Bookings WHERE DATE(Booking_Date) = DATE(booking_date) AND Table_Number = table_number ) THEN…
I am trying to pick up the basics of SQL and my teacher has given us this block of code to cpy and paste to create a table: mysql> CREATE TABLE IF NOT EXISTS actors ( -> id SMALLINT UNSIGNED…