The following result is quite surprising. MySQL [emicall_cc_man]> SELECT count(DISTINCT `id`) from call_record; +----------------------+ | count(DISTINCT `id`) | +----------------------+ | 2197537 | +----------------------+ 1 row in set (1.32 sec) MySQL [emicall_cc_man]> SELECT count(`id`) from call_record; +-------------+ | count(`id`) | +-------------+…
I have been given a leaderboard, I need to return the row correspond to 4th to 8th rank in a leaderboard? id name score 1 gongy 3001 2 urandom 2401 3 eduardische 2477 4 Gassa 2999 5 bcc32 2658 6…
I am trying to understand the syntaxes for defining tables and I noticed that the column definitions include an option to indiciate that the column references a column from another table. If I can already define this here, do I…
I'm trying to show a table with information gathered from 4 different tables. orden_trabajo_pk concepto descripcion importe ing_responsable_id 159460 concept example1 description 18000 1 159461 concept example2 description 8000 1 cotizacion_pk concepto descripcion importe orden_trabajo_id 2010633 concept example1 description 20000…
Ok, Let's say I have two tables with identical structures but different values : TABLE1 : column.A, column.B, column.C TABLE2 : column.A, column.B, column.C I add columns in table 1, it becomes : TABLE1 : column.A, column.B, column.C, column.D, column.E,…
I try to multiple select in MySql but it doesn't work. Example : SELECT (SELECT column1, column2 FROM table1 WHERE column3='something') AS query1, (SELECT column4 FROM table1 WHERE column4='something') AS query2 And the result i try to have is something…
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…