Mysql – Construct JSON_ARRAY with conditional second object
I have a simple sample table: f1 f2 1 2 1 3 I want to create a JSON array of each line - BUT, I do not want to include the second object if its value is 3. So I…
Mysql SUM with UNION ALL and JOIN
I have 2 tables and I like to get sum of values and also to group by the result. I have this query: SELECT SUM(tr_amount) as total, projects.pr_type from transactions INNER JOIN projects ON projects.pr_name = transactions.tr_pr_name WHERE tr_amount <…
How do I make a text box display the last entry made into a database a mysql table?
I would like to display the last entry made in the database table inside of a text box. Currently all the entries are being displayed in text boxes but i want just one text box that contains the last entry…
Mysql – find unique records ignoring difference of 5 seconds
I need to find unique records from mysql table / dataframe. As per the business logic, if the time difference is less than 5 seconds (mobile number and code should be the same) then that record is considered as a…
Display Line chart with data retrieved from MySQL Database
I am using a template built on Bootstrap 4 & 5. There is a line chart already featured, with hardcoded values being displayed. Hardcoded values: <div class="sparkline" data-type="line" data-spot-Radius="0" data-offset="90" data-width="100%" data-height="50px" data-line-Width="1" data-line-Color="#604a7b" data-fill-Color="#a092b0">1,4,2,3,6,2</div> </div> And it looks like…
mysql sorting a string containing alphanumeric
Hi I have these set $numbser (varchar) CA 0000002 CA 0000001 CA 10000000 CA 1111111 CA 2222222 CA 20000000 CB 0000001 CB 0000002 CB 1111111 When I use order by numbser, I get these. SELECT * FROM stock ORDER BY…
Why does this query work in MySQL but fail in MariaDB?
This query works as intended in MySQL, but fails in MariaDB as not being able to recognize the "uID" field. Why? Is it possible to code one version for both? select user_id as uID, last_name, first_name, athlete, parent, coach, code,…
Mysql – Nested loop inner join with index lookup and filter is slow
I have this query I'm running in MySQL: SELECT count(*) FROM library AS l JOIN plays AS p ON p.user_id = l.user_id AND l.path = p.path WHERE l.user_id = 20977 AND p.time >= '2022-10-17'; When EXPLAIN ANALYZE is run: |…
Library not loaded libmysqlclient, macOS Sonoma
ruby 2.5.1 macOS Sonoma Beta Run rails server Error /.rvm/gems/ruby-2.5.1/gems/mysql2-0.5.3/lib/mysql2/mysql2.bundle, 0x0009): Library not loaded: /usr/local/opt/mysql/lib/libmysqlclient.21.dylib (LoadError) i want run my ruby and rails app.
Mysql – retrieve orders over 3 calendar years
I am looking for the right query to retrieve orders that are 3 calendar years old. Example: It is October 18, 2023, and therefore I want to collect all orders from January 1, 2021 until October 18, 2023. SELECT *…