Connection1: BEGIN; SELECT * FROM world.city WHERE ID = 130 FOR SHARE; Connection2: SELECT engine, thread_id, object_schema, object_name, lock_type, lock_mode, lock_status, lock_data FROM performance_schema.data_locks; +--------+-----------+---------------+-------------+-----------+---------------+-------------+-----------+ | engine | thread_id | object_schema | object_name | lock_type | lock_mode | lock_status |…
In mysql, I tried to print '-1' if 3 conditions are satisfied. SELECT '-1' WHERE not exists(select * from acq_staff where acq_person_id = staffID) OR not exists(select * from acq_training_course_session where training_course_id = course_id) OR exists(select * from acq_training_enrolment where…
This is my table MySQL 5.5.62 host version uID Next_control Next_control_2 Date_alert 45265 2023-09-07 2023-07-07 NULL 45265 2022-12-16 2022-10-16 NULL 45265 2019-04-19 2019-02-19 NULL 45265 2016-09-18 2016-07-18 NULL 45265 2014-11-23 2014-09-23 NULL 45265 2009-08-11 2009-06-11 NULL I need to update…
select count(user_id) from photos group by user_id ; 4 3 1 2 1 1 12 5 1 4 8 2 1 4 5 2 1 2 1 1 3 5 4 4 5 1 3 5 5 1 1 8…
I wanted to add more users for a shift. But it's a foreign key. How to do I make it? It does add, but if I choose more than one user, it shows this. Field 'id' expected a number but…
i consider myself a pretty well-versed developer, but this one has me stumped. The actual use case is somewhat more complicated than this (i have built a data-view framework that allows you to filter and search data), but at its…
I have a mySQL database with several tables. But one tabel contains af 1,400,000 rows. I need to get the 50,000 rows with the highest value in one field. A field that counts visitors. SELECT uid, title, number, views FROM…
I'm new to multithreading and don't even understand what to do with a thread in my application. The application is a console game. The player chooses a hero, clan and actions. Gold is credited to the treasury for various actions.…
I have this following query that needs to be optimized Select 1 As status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, e.name, e.short_description, e.image, e.small_image, e.thumbnail, e.url_key, e.free, e.number_of_downloads, e.sentence1, e.url_path From catalog_product_flat_1 As e Inner Join catalog_category_product_index_store1 As cat_index On…
Hello I had an sql getting the number of orders this week. My sample query below: SELECT products.name, (SELECT COUNT(orders.product_id) FROM orders WHERE orders.product_id = products.id AND DATE(orders.order_date) >= [from] AND DATE(orders.order_date) [to]) as total_orders FROM products p; Now I…