I am trying to retrieve data using a belongsToMany relationship in Laravel. So I have Student and Course model and they have a many to many relationship, but there are few courses that are compulsory so we don't want to…
Table 1 +--------+------------+-------+ | URI | Date | Name | +--------+------------+-------+ | Fred4 | 2023-04-05 | Fred | | Fred3 | 2023-04-01 | Fred | | Fred2 | 2023-03-15 | Fred | | Fred1 | 2023-03-06 | Fred | |…
I use golang mysql to execute the delete statement, the target of the delete is using IN condition, but only one record is deleted. What is causing this? go 1.16 import ( "database/sql" "errors" "fmt" "io" "log" "net/http" "strconv" "strings"…
I recently started to study SQL and I'm trying to solve the problem: I have a voting table db.votes, it records the nickname, time and type. Like an event log. It now has 500,000 lines. I need to record the…
I'm currently trying to extract latest visited domain information from a table that includes a visits history on my websites and information I want to retreive. Here is my table structure: CREATE TABLE `visit_record` ( `id` INT NOT NULL AUTO_INCREMENT,…
I started to SET my dates to (%d. %M %Y). But now I cant find them with: SELECT value FROM _data WHERE dates >= "01. October 2012" AND <= "01. December 2016" The default DATE_FORMAT was YYYY-MM-DD hh:mm:ss.000 before the…
I'm trying to return a sorted list of entries by their date, but keep matching columns together. For a super simplified example, the table food is as follows. id name group_uuid date 1 Apple 6d37ca 2023-05-20 2 Cucumber d90ad2 2023-05-20…
I'm just learning and I don't understand how to update a separate column in the table, I use MySQL. The table is called card, I want to update the pincode column. java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;…
I design a game achievement system for a MySQL database. Each achievement has 3 levels and each level contains a different reward. Achievements and their levels and rewards are the same for every user. Table achievement: id_achievement title description level_1…
Looking to compare today's temperature to yesterday's. If today's is higher than I want to return that row's id. Table has 3 columns: id, RecordDate, and temperature. Code works on small data sets but looking at a data set of…