So I'm working on my internal assessment for IB for comp sci and I have the snippet of code that basically is supposed to insert a a row within a subjects table that contains both a subject name, and the…
I am trying to connect to the mysql database from my express server in cpanel (the databse and server are both in cpanel) , I already added a user, and I'm trying to connect via localhost but this ain't working…
What do I need to do for the fk of the child table to be automatically filled? I'm using JPA, Spring Boot, MySql The JSON in Postman is sent successfully, but the Request attribute is not filled in and neither…
I have a MySQL table which has sets of records that follow a sequence of events. I would like to find out cycle time (time it took to complete) by calculating the difference between few specific set of records. Table…
I have two tables in MySql i.e., subjects and photos and I wished to count the number of photos on each subjects SELECT a.id, a.name, count(a.id) as `refcount`, FROM `subjects` a LEFT JOIN `photos` b ON (a.id = b.subject_id) GROUP…
I have a MySQL database that has a table with multiple duplicate records. The table has 4 columns e.g. id, post_id, post_key and post_value. I am able to return the duplicate entries with the query below. SELECT * FROM table1…
I have a table contain reference time and a user check-in time. Both data is different in type. Sample data dtime = 2023-06-02 08:23:21 work_time = 08:00-18:00 And my code is... SELECT substring(dtime,-8,5) AS chkin, SUBSTRING(work_time, 1, 5) AS wt1,…
I have a called users id name username 1 John user1 2 Mary user2 3 Bucket user3 second table relationship id followerid followId 1 2 1 I want to use sql query to get the user3 not following user1 export…
I have a MySQL SELECT query that takes a few minutes to run when I run it in SQLyog (the GUI I use). When I try to run the identical query via PowerShell (using SimplySQL), it fails, always at 30…
I'm building my first CRUD application (Create, Read, Update, and Delete), but i'm having issues Updating the Data. On the html page, when you click on a table row that you wish to update, it sends you to an update…