Mysql – Sql like with without leading 0's
I have a table like this Id Number (string) 1 0000231 2 00232 3 231 4 24 5 A1233 Ex: I need to search by value 23 ( may vary) Expected Result: Id Number 1 0000231 2 00232 3 23…
Mysql – Problems with executeQuery
I'm trying to use MySQL and jdbc, but I can't use the executeQuery command, do you know why? It's the first time I've programmed in Java and integrated SQL into the program, I don't know what's wrong. import java.beans.Statement; import…
Mysql – How can I optimize this simple join query? It takes a long time
I am not sure on how to begin optimizing this High Latency SQL query that my platform runs. Other than reducing the datasets, what are some things that I can do? SELECT ctm.* FROM compound_transaction_map ctm JOIN bustransaction_map btm ON…
MYSQL insert row in the table only if the day of execution is the last day of the month
I'm trying to write a very simple query that inserts a count of accounts in my ns_monthly_count table. The catch is, I want this query to execute only if the day of execution is the last day of the month.…
Mysql – Cummulative substraction of 2 values using SQL or Python
rake_name origin destination created_At bpc_issue_date departure_time journey_distance bpc_balance_distance_km abc rn logic ARIL-05 a b 09-02-2024 06:37 08-02-2024 18:30 09-02-2024 13:40 173.4600067 5271 5097.539993 1 5271-173.4600067 ARIL-05 a b 11-02-2024 02:58 08-02-2024 18:30 11-02-2024 04:15 1099.369995 5271 3998 2 5097-1099 ARIL-05…
Xpath 1.0 Mysql issue
I have this sample xml <ProductSaleItem> <ItemReference>100</ItemReference> <Discount> <Modifier>1</Modifier> </Discount> </ProductSaleItem> <ProductSaleItem> <ItemReference>101</ItemReference> <Discount> <Modifier>1</Modifier> </Discount> <Discount> <Modifier>2</Modifier> </Discount> </ProductSaleItem> <ProductSaleItem> <ItemReference>102</ItemReference> </ProductSaleItem> and this xpath //ProductSaleItem[Discount/Modifier]/ItemReference i am hoping to get 100 101 but all i get is 100…
Mysql on duplicate key condition (IF) setting of one field
I am using on duplicate key to update data in a mySQL DB v 8.0.35 (AWS RDS instance) I want to update a selection of fields with the new value. Plus set a further field (up[dated) to 1 only if…
How to optimize MySQL query for matching multiple comma-separated values in a single column?
I am working with a MySQL database and I have a column (let's call it status_column) which contains comma-separated values. The possible values in this column are 'NA', 'NON_NA', 'PSG_REQUIRED', or any combination of these, such as 'NA,PSG_REQUIRED' or 'PSG_REQUIRED,NON_NA',…
Mysql – Test DDL statements before committing?
I am developing a PHP-based web application, in which I use the MySQLi driver. I make fairly standard use of this resource - I have a list of prepared statements, which I call at various points in my application, checks…
Im goining to connect Mysql using Spring boot Java. but i gave errors. im new for this
Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution [Access denied for user 'root'@'localhost' (using password: YES)] [n/a] Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution [Access denied for user 'root'@'localhost'@'localhost' (using password: YES)] [n/a]…