It is complicate situation I installed [email protected] through brew zsh can't find mysql command. so, I add mysql path to ~/.zprofile but still zsh can't find mysql, in addition can't find brew if I remove mysql path, then zsh can…
I am working with a booking appointment system. I want to find out how many time slots are available and how many time slots are already booked. time slot count will be change base on the appointment. I used laravel…
How do i go on about on a query for where i wanna extract the same first name but the last name is different? NAME ------ Chris Stutter Chris Lamb Alfred Dark Kristine Light output: Chris Stutter Chris Lamb
Good morning! I'm a bit stuck with this question. I know it's not complicated (Because I'm pretty sure I'm close to the answer) But I've been Stuck for a bit now. I'm totally new to MySQL My database code :…
Example: SELECT COUNT(id) AS total_orders, ( ( SELECT COUNT(id) FROM orders WHERE status = 'Closed' ) / total_orders * 100) AS percent_closed_orders FROM orders Question: How can I use total_orders in the subquery? I get a an error "unknown column…
I'm looking to fetch the last 10 item IDs in a single value separated by commas, like: 123,456,789 etc However, MySQL just doesn't seem to work the way I think. I try: SELECT GROUP_CONCAT(item.id) AS Item_IDs FROM items GROUP BY…
any idea how to improve this code to avoid the java.sql.SQLException: No operations allowed after statement closed. I can't understand where the error actually occurs, I guess after if (resultSet.next()) the connection is closed. This method is executed when a…
I am summing the columns from different tables each in a different database. Created the models for each of the 8 connections and added them to the controller. use AppModelsobjectMapping1; use AppModelsobjectMapping2; use AppModelsobjectMapping3; use AppModelsobjectMapping4; use AppModelsobjectMapping5; use AppModelsobjectMapping6;…
I have multiple products on my website that have hardcoded links to other products in the product description (text). Those links are mixed case and are causing issues with duplicate pages on the Google index. I would like to convert…
This query return users from database MariaDB (MySql). I need to remove rows from result, where in surname is added "(old)" OR "- R". How to edit a query? SELECT au.id, au.name, au.surname FROM statements s JOIN aduser au ON…