WHAT I HAVE CURRENTLY: I have a table with Customer_ID, Start_Date, Frequency, Day I have a second table with simply a list of dates throughout the year 2024 and day of the week, like the below... Date Day 01/01/2024 Monday…
I have a result set of parent categories and subcategories. I want to exclude all parent categories if a subcategory exists in the results. What I would do is using a NOT IN in the query, but that requires a…
I have a column in a table where the value is only a letter. The column name is 'place'. When selecting everything from the table grouped by 'place', the letter A and the Danish letter Å is placed together. Why…
Below is a snippet of a MySQL Script mysql> SET @j1 = '[{"Documents": []}]'; mysql> SET @j2 = '{"rc":{"DisplayName":"Registration Certificate","Extension":"png"}}'; mysql> SET @path = '$[0].Documents[0]'; mysql> SELECT REPLACE(JSON_ARRAY_INSERT(@j1, @path, @j2), '\', ''); The output generated by above script is: [{"Documents":…
I have the following code which encompasses a boost::mysql connection using a shared_ptr. I want to keep the connection object for the duration of the application's runtime. I want the application to then close the connection on the end of…
I have 2 queries which give count of cases based upon a condition Query 1: Select count(unique c.caseid) as New_cases from caseinfo c where (c.crtdate between TO_DATE('2024/07/08') AND TO_DATE('2024/07/11')) and c.channel is not null; Query 2: Select count(unique c.caseid) as…
How to write out dataframe mtcars to mtcars.sql file ? So I can import the sql file to MySql manual. (xx.write just wished function ) library(tidyverse) xx.write(mtcars,'mtcars.sql')
I am new to using Docker and I want to place an existing project in a set of Docker containers so I can run the project on other platforms/devices. I currently have a Flask app connected to a mysql database.…
I want to understand why mySQL says there's an error in the syntax when I try to run this query: select g1.*, g2.* from (select * from Customer where referee_id is not null) Logs g1, Logs g2 Am I not…
When I install MySql server, root user is initialized. It has no password. I have a query here. Suppose I create few databases in the mysql server. Do all these databases have same user now ie root user? How can…