We are using very simple SELECT … WHERE queries (1000 rows, from a very small table with 18000 entries) to load time series data for plotting (for testin
I have data in the below format { "userId": 1 "stateId": 199, "productId": [ 1, 2 ] } I want to get this type of response
Even though I already started the game on the teacher's side, the code keeps on returning 'notrunning' so does this just mean that is_null($result[0])? <?php
can anybody tell me how to implement a split function in mysql which behaves like Javascript split. I want a function like this SELECT Split('a,b,c,d', ',') A
I installed MySQL via brew, but instead of letting me set a root password after mysql_secure_installation, I get prompted for the root password instead. % brew
I need to support an old site. using HTML4, <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" > and DB TABLE fields with latin1_
There is a blood bank which maintains two tables: DONOR that contains information on the people who are willing to donate blood and ACCEPTOR, the people who are
i am using onKeyUp event for fire api without submitting the form and i fetched data in response successfully if Mobile number matched. But i don't understand h
Just want to count the number of devices and display it here: I have tried using "SELECT DISTINCT Firmware, COUNT(SerialNumber) FROM SoftwareCycle GROUP BY Mod
I'm using wsl2 on a windows machine. I want to view my databases that I have on mysql server ubuntu in a GUI such as mysql workbench (on windows) but it seems a
So, I'm trying to run a stored procedure within another stored procedure and parse out some XML data into a variable. It is giving me a syntax error on the fir
I have the following query in mysql select count(*) as aggregate from `promotions` where `supplier_id` = 1 and '2022-03-27' <= promotions.to AND '2022-04-27'
Below is the schema of my table A. CREATE TABLE A ( NAME VARCHAR(255), CREATED_AT DATETIME DEFAULT CURRENT_TIMESTAMP, UPDATED_AT DATETIME DEFA
If a pyspark dataframe is reading some data from a table and writing it to azure delta lake Can we add comments to this newly written file? For e.g Df = sql("se
We have some data in our Mysql RDS, which slows down our application, but it's no longer needed. So we want to remove old records but keep them somewhere so our
I tried to create a relationship in Laravel for this, Expense has May ExpensesItem Expense has One ExpensesCategory But I could not create a relationship betwee
I have a model with char field with values like this: "Justin Roseman" (one single whitespace betwen words) "Justin Roseman" (two whitespaces betwen words) " J
I have created a MySQL join between two tables in two different databases on our account. The query works fine on my local server, but the hos
i have table schema in mysql for my project. this project build with laravel and as you can see in the below image i want to fillter all row with the same store
I am currently scraping tweets via Tweepy into a mySQL database. I am new to routing data into a server, so I am having trouble adjusting my code to get the ext