I am building a project with Laravel and I have a table which contains all my products. On that table, products get added daily, and I show all products on my page sorted by created_at. That's a pretty easy job…
I am trying to understand SQL Self-joins. I have the following table Weather +----+------------+-------------+ | id | recordDate | temperature | +----+------------+-------------+ | 1 | 2015-01-01 | 10 | | 2 | 2015-01-02 | 25 | | 3 | 2015-01-03…
I cannot see why my defined function does not work. No error message, just no INSERT into the Table I define my function: import mysql.connector db = mysql.connector.connect(host="localhost", user="root", passwd="", database="autot") mycursor = db.cursor() def writedb(Tablename,Time, trade_ID, Price, Quantity): mycursor.execute("INSERT…
I am working on a vehicle project management system, and using a custom table for storing the signup details in MySQL. When the user logins the authenticate function returns none always, I am using email and password fields for login…
How to compare now to a timestamp in Mysql, when valid_date is greater than now 1, else 0? I only have data of valid_date, I need data of is_valid, thanks so much for any advice. valid_date is_valid 1675739460 0 1680837060…
I have a table with dates and several columns of data. Most weeks every day will have entries but some will not. I have a chart that I want to load the last 15 days of accumulated data into but…
$couponCode = $request->couponCode; // Get coupon details by coupon code $coupon = Coupon::where('couponCode', $couponCode) ->get() ->first(); $couponDetails = response()->json($coupon); return $couponDetails->couponName; That returns as: Undefined property: IlluminateHttpJsonResponse::$couponName (500 Internal Server Error) I am tring to get couponName value from couponDetails
I understand that this query will produce numbers and cumulative tallies: SELECT number , SUM(number) OVER (ORDER BY number) cumulative_number FROM (SELECT 1 number UNION SELECT 2 UNION SELECT 3) inside GROUP BY number Result: number cumulative_number 1 1 2…
I have two tables - employees and departments. The employees table has the following columns: emp_id, salary, dep_id. The departments table has the following: dep_id, department_name, manager. Now, I am trying to get the employee_ids of the employees who have…
I'm getting an error when creating a table. can anyone tell me what I'm doing wrong ? DROP Table if exists #PercentPopulationVaccinated Create Table #PercentPopulationVaccinated ( Continent nvarchar(255), Location nvarchar(255), Date datetime, Population numeric, New_vaccinations numeric, RollingPeopleVaccinated numeric )