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
I'm trying to build an app in nextjs and I've stumbled upon some issues. I'd like to do a query call inside my getServerSideProps() but I get the error: error -
I have a problem selecting the data from a table. I'm sure the answer is staring me in the face, but my brain is mush. We're trying to find out which customers
I am trying to use a single select request to retrieve data from database based on the search term "name" and populate my input fields using select2 so that i d
Say I have a table logins with just the bigint id ,a date_login of type datetime, and fk_user of type bigint. I need to select the first and last logins for eac
I read this post and I wish to fix it the same way as the answers but I can't find the backup folder in my CentOS. Where is C:\xampp\mysql\backup\ located in Li
I've been using Laravel Datatables for awhile in some of the Laravel applications and I really love that, and probably using a fraction of the features. I also
So my question is : How does hashing algorithms actually check if passwords match because they generate a new password every time. Let's suppose I have a passwo
Have anyone deployed Spring Boot app to DigitalOcean droplet? I have previously created app on Heroku.com, where I also ordered MySQL Database and deployed my W