hope you can help write a sql query for table X. I have a table with rows per timestamp, filled with User_ID's and weather they have been in variant A or B of the a/b test. I want to select…
ID StartTime StartLocation EndTime EndLocation 1 2023-10-15 10:00:00 A 2023-10-15 12:10:00 B 1 2023-10-15 13:00:00 B 2023-10-15 18:00:00 A I want to merge these two rows into one so I get the first StartLocation and the last EndLocation. It should…
I am looking for how to write a query which contains query with values as one single parameter execute(sql) unlike query and values passed as separate parameters to execute(query, values). Below are the details I am looking into. ###Required Solution###…
I have 2 tables: POLLS: POLL_ID CONTENT 1 C1 2 C2 3 C3 VOTES: POLL_ID USER_ID VOTE 1 U1 1 1 U2 2 2 U1 3 2 U2 2 3 U2 3 I want to query by USER_ID (ex U1)…
When tryint to install AzerothCore with Docker I had the following error to my ac-database container: [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 8.0.29,…
Say, I have 150 records spanned over 2 hours period, eg, 1am to 3pm. There are 60 records timestamped at the end of 1pm and 70 records timestamped at the beginning of the 2am. I need to produce a report…
I've a table with ID column, auto increment. Because of the bad migration a while a go, and I only noticed this now, form entries were all stored as ID 0. So now I have two problems: around 1000 entries…
I need to select all records for the current day in CST, however the timestamp fields in the table are all in GMT/UTC. The server's timezone is GMT. Getting all records for the current day in GMT is very fast…
The database schema below represents a fictional shows database called hbtn_0d_tvshows tables. tv_shows id title tv_genres id name tv_show_genres id show_id genre_id The tv_show_genres is a pivot table that links tv_shows and tv_genres tables. Now I have been given a…
I have a table with Columns:OrderID int PK Department varchar(100) OrderDate date OrderQty int OrderTotal int. I want to add two orderdates from orderid 1 and 5. I tried to make self join but it return 0. select p.orderdate,datediff(p.orderdate,m.orderdate) as…