We have a table bids(id,auction_id, vendor_id,bid_price,created_at) where one vendor will have multiple bids but we take the latest using the created_at column We need to find the position of the vendor from the bids of all vendors where his position…
I have a censored name & surname value. I want to search this value on mysql. Censored Name = "A*** K***" Censored Surname = "L***" I need a mysql command to be able to run this query. My Code: SELECT…
My project is a combination of Mysql, Spring Boot and Docker but when I try to dockerize it I am facing with an error. I searched for it but couldn't find any solution. Here is my Dockerfile : FROM maven:3.8.3-openjdk-17…
The source of the below data is a csv file that comes from a warehouse. System reads the csv file and saves in the table called warehouse_feedback. Warehouse splits the quantity and sends in multiple packages. That is the reason…
private void startPoll() { System.Diagnostics.Debug.WriteLine("dbForm created"); timer = new Timer(int.Parse(Properties.Settings.Default.DbPoll) * 1000); // ElapsedEventHandler OnEventExecution = null; timer.Elapsed += OnEventExecution; timer.Start(); System.Diagnostics.Debug.WriteLine("Timer Started " + Properties.Settings.Default.DbPoll + " secs"); string connectionString; // MySqlConnection conn; connectionString = "server=" + Properties.Settings.Default.DbServer +…
I need to get the difference of two rows. The issue is that I can get it done but only for the next row, I need the difference for the higher row. So row with id 1686 has 275 purchases…
im a beginner and using mysql workbench8.0 ,and it seems like i cant get this to work. ive got three tables. these are my tables: 1.books(id=pk) id title author 1 my first book sara 2 my second book maman 3…
Here is schema of table:- INSERT INTO cars(id,model,brand,color,make) VALUES (1, 'Model S', 'Tesla', 'Blue', 2018), (2, 'EQS', 'Mercedes-Benz', 'Black', 2022), (3, 'iX', 'BMW', 'Red', 2022), (4, 'Ioniq 5', 'Hyundai', 'White', 2021), (5, 'Model S', 'Tesla', 'Silver', 2018), (6, 'Ioniq 5',…
There is a code, it works, a lot of results are found: SELECT * FROM `modx_site_content` AS `msProduct` WHERE `msProduct`.`pagetitle` REGEXP '300х250х625' But I want the number separator to be not only the Russian letter "x", but also the English…
I have the following query: delete from customers_cards where id not in ( select min(id) from customers_cards group by number_card ) and belongs_to = "ezpay" It throws: #1093 - You can't specify target table 'customers_cards' for update in FROM clause…