I've got a set of accounting data that I need to query using MySQL, but I'm having trouble figuring out how to convert the ending balance of a month into the beginning balance for the next month. Here's an example:…
I want to write a SELECT query in MySQL to find words with only and only specific characters in database. For example if data is : id word --------- 1 a 2 b 3 aa 4 ab 5 aaa 6…
My dbfiddle I have a table that stores user counts every 5 minutes for multiple devices. Each device has it's own row per timestamp. As I show in my fiddle, I created a query to sum all of the rows…
So, for example, we have a function that performs some kind of transaction, it gets imported in different parts of the application where it keeps being called. // myDb.mjs export const db = mysql.createConnection({ host: 'localhost', user: 'root', password: 'password',…
MySQL / MariaDB structure: Person | id | |----| | 1 | | 2 | | 3 | Car | person_id | car | |-----------|-------| | 1 | Ford | | 2 | Mazda | | 3 | Ford |…
I have two tables. 'users' table: id name book1 book2 book3 1 Brian name1 name2 name3 2 John name3 name1 name2 'library' table: id book_names position 1 name1 2 2 name2 3 3 name3 1 What I want is: The…
i have a problem with sql request. I have 3 tables. table_1 id name 1 aaa 2 bbb 3 ccc 4 ddd table_2 id name 1 zzz 2 yyy 3 xxx 4 www And third table for many to many…
My orignal code is using TransactionScope and Async/Await. There is a DispatcherTimer on my WPF application and there are some code in the tick as below: List<string> connectionString = new List<string>(); foreach (string connStr in connectionString) { using (TransactionScope transactionScope…
i have a one table employee . need to sort the result . match_id isin start_date ref_number 1 A123 01-jan-2023 11 3 A123 03-jan-2023 11 2 B123 02-jan-2023 11 1 A123 01-jan-2023 12 2 A123 02-jan-2023 11 1 B123 01-jan-2023…
I have a table that has a column called year. The year column contains data such as 2022-2023. I want to separate 2022 from 2023 using explode(), but it is not working. It stops at the first row. public function…