sorry i wrote in german... Here again... I'm stuck and hope you can help me! I have a mysql database with two tables: booking and article. They are linked via booking.Uid and article.booking_Uid. There can be several articles in each…
I have a hotel reservations table with three columns: arrival date, departure date, and number of guests. I would like to create another table with two columns: date and total guest who are present in the hotel in this date.…
I have a laravel application A with a mysql database db1 and a table p1 and a diffrent php application B with an equivalent table p2 in its mysql database db2. I want to find best, secure and complete way…
Column Definitions The ID column is the primary key with auto-increment that we use to maintain the pool range. Serial is unique and needs to be unique even after partitioning. The status of a product is an enum with a…
I have the next records from the table 'data' date_post date_complete 2023-11-28 2023-12-04 2023-11-28 2023-12-04 2023-11-28 2023-12-05 2023-11-28 2023-12-05 2023-11-29 2023-12-06 2023-11-29 2023-12-06 2023-11-29 2023-12-07 2023-11-29 2023-12-07 it's posible to select something like this? date_post date_complete 2023-11-28 2023-12-05 2023-11-28 2023-12-05…
Someone brought up a SQL challenge and I couldn't come up with a good solution to it. They wanted to see the best way to detect a split in a game of bowling. For some background, what I could find…
i am new to Laravel and i am working on a blog/post project with likes and comments. Now i would like to display/count all likes from all post that was made by a user. So for example: user 1 made…
I'm a foundation student. My assignment is to create a database for a login system for an html form. I had no problem connecting to it, as well as putting data into the DB. But when I ask my friend…
The following is the setup code: DROP TEMPORARY TABLE IF EXISTS temp_table1; DROP TEMPORARY TABLE IF EXISTS temp_table2; CREATE TEMPORARY TABLE temp_table1 ( `id` bigint NOT NULL AUTO_INCREMENT, `doc_no` varchar(25) NOT NULL, `other_table_id` int DEFAULT NULL, PRIMARY KEY (`id`) )…
I'm stuck with a servlet problem – my database connection is turning up null. The weird part is, the same database code works fine in another class. I've double-checked my configuration, loaded the JDBC driver, and tested it on Tomcat,…