I recently upgraded to MySQL 8.4, and I just noticed my C drive is almost full. After looking into it, I realized that MySQL has been creating a bunch of files called "binlog.XXXXXX" where XXXXXX is a random number (it…
I'm struggling to find the best way to get the total order value (sub-total - deduction) for a specific date or date range (for example today). I don't want shipping value included. The complexity is because the sub-total and deductions…
I have a series of bird species names that are sorted taxonomically (by ID). I would like to cluster sub-species (which currently have a clust value of 0) with the species (clust <> 0) that falls above them in the…
So, I have the following table where Col1 can have 2 values: A or B Col2 can have 2 values: P or Q Col3 can have 3 values: L, M or N Roll_number is just a numeric Id number Roll_number…
Our app has some long-running operations that are wrapped in a transaction, within such transaction it performs dozens of fast queries. Recently we encountered a problem with one of such transactions - it updated a lot of resources and therefore…
I was trying my hands on running my Spring Boot application with MySQL database on Docker Desktop via docker compose. I am getting this error upon running docker compose up . app-1 | java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)" because the…
I am using h2 database for testcase and mysql database as main DB. Do I able to maintain single flyway migration for both. I am using springboot framework. application-mysql.properties: spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.password=root spring.datasource.url=jdbc:mysql://localhost:3306/shipment-planning?useSsl=true spring.datasource.username=root spring.flyway.default-schema=shipment-planning spring.flyway.enabled=true spring.jpa.hibernate.ddl-auto=none spring.jpa.show-sql=true spring.flyway.locations = h2/db/migration…
I'm a begginner learning to make "contact us" page (in a bit of an improvised way, as you'll see hehe). I defined some variables using global variables. But when write the query to save them to the database, MySQL understands…
I am using Snowflake (or MySQL is also fine) and I would like to assign a random number between 1 and 3 (both inclusive) to an ID column based on which group they are in - so that the 1s,…
I have a list of emails that can belong to multiple properties in a single table. Each email has an associated ISP, such as Gmail, Yahoo, etc. I am trying to count how many properties an email may fall under.…