I've created a regex pattern to match sequences of digits that can be ascending or descending, like 12345, 123, 321, 6789, 7654, etc. However, I believe this approach may not be the most efficient or professional way to achieve this…
I have the following MySQL query: SELECT tbPacientesComunicacao.id FROM tbPacientesComunicacao WHERE tbPacientesComunicacao.idRefUser = 1 AND tbPacientesComunicacao.idRefPaciente = 4 AND tbPacientesComunicacao.id IN ( SELECT idRefComunicacao FROM tbPacientesComunicacaoDestinatarios WHERE idRefUser IN (2,8) ); The issue is that MySQL returns the ID if…
I've been required while online self learning to do as title shows. this is the info of the quesion: Accounting Instruction Write a query to select the amount of sales by country. Order the result by descending amount. Produce exactly…
I'm implementing a classic "Three-Table Tag System" using MySQL 8 and PHP: the first Table ("Posts") contains posts (PostId, PostTitle, PostSummary, ...); the second Table ("Tags") contains tags (TagId, TagName, TagSlug); the third Table ("TagsMap") contains tags associated to each…
I have a Mysql InnoDB table with storage size(+index) over 2,000GB, There are 14 billion rows in that table.. I need to drop data added over 1 month ago, and figure out a way to always keep recent 1 month…
I would like to establish a connection to my MYSQL database. Unfortunately, I haven't found the right one for me anywhere. Does anyone have a solution that is similar to this one? I have tried this but i want to…
I have imported a CSV file into mysql 5.7 and need to modify the date so that I can manage it later. The imported data is currently in a column called localDate which needs to be modified. It looks like…
I have a query with multiple joins. Most joins are a 1 to 1 but two are 1 to man. My sql query returns results as expected with data from the 1 to many joins flattened into a single value.…
I came across this question on a coding platform One single table is given. It is of the following format: Temperature_records Record_date Data_type Data_value 2020-07-01 max 92 2020-07-01 min 71 2020-07-01 avg 74 2020-07-02 max 90 2020-07-02 min 67 2020-07-02…
I have this query: Explain select SQL_NO_CACHE p.id as product_id, p.price_amount, p.is_male, p.is_female, p.is_accessories, p.is_contact_lens, c.id as color_id, b.name as brand, p.name, c.color, c.code, c.pohoda_sku, c.on_stock, c.not_send_to_kiosks, (p.is_active && !p.is_archive && c.is_active && !c.is_archive) as is_active, c.is_visible, c.abbr from product_colors…