After retrieving the first article number, I can only obtain the data for all products from the query. Each product has a "type_id" that determines in which junction table the product options can be found. My question is how can…
I tried to return some of the rows in table service: SELECT ps.post_name as post, c.cname, p.place, s.date_from, s.date_to, e.emp_name as employee, s.court, s.place FROM `service` s INNER JOIN `employee` e ON s.empno = e.empno INNER JOIN `posts` ps ON…
I am trying to come up with a solution without a subquery which was asked in one of the interview. customerId in Orders table is a foreign key referencing id in Customer table. Table: Customer: id is a primary key…
I'm trying to calculate daily inventory availability for different products using MadiaDB. First of all, there is a products table containing data for every product that is being sold. I'm getting sales data to product_sales_date table on daily level for…
I have a table like this librarylog patronName bookId dueDate John 24 2024-01-14 Sam 42 2024-01-07 Bob 13 2024-01-07 I'm trying to create a SQL query which updates all the dueDate values and increases them by a week. This is…
Customers Field Type Null Key Default Extra recno int NO PRI NULL auto_increment CustomerKey int NO NULL MaintDate date YES NULL Service Orders Field Type Null Key Default Extra recno int NO PRI NULL auto_increment CustomerKey int NO NULL ServiceDate…
I have been moving A DATABASE from MySQL 5.0 (Fedora Core 7) to MariaDB 10.5 into recent OS Rocky 9.1. As far as ASCII 1 byte text data go, no problem. Now, I have plenty of 2-bytes characters in my…
I finished my web project, the application server used is Wildfly 30, I made the deploy of the application without any errors now my problem is how I do to turn my application in production on my domain server. If…
We are building an app from scratch and one developer is using uuid type string for primary key and I used integer with auto increment. I'm wondering what is better for performance and everything else when we use mysql db.…
I am trying to make a library management application with the ability of the following: add a book, delete a book, view a book, searching for a book, editing a book all these functions are done on a table (library1)…