I have the following tables: Teammate ID Teammate name Team id Teams 1 Amy 11 Sales 1 Amy 12 Support 1 Amy 13 Marketing 2 Peter 12 Support 2 Peter 13 Marketing And I want to group my results so…
so I am using MySQL as the database for my node app I can insert the date in YYYY-MM-DD format but when I get data from it returns it as yyyy-mm-ddT00:00:00.000Z so I want only the first part db.query(`SELECT agereement_date…
I have a 'users' table for general information of every user (primary key is 'user_id') and a table 'chat' to store messages (primary key is 'msg_id') that have 'incoming_msg_id' (which eventually corresponds with 'users.user_id') and 'outgoing_msg_id' (which eventually corresponds with…
I am running a finance related web portal which involve millions of debit credit transactions in MySQL , getting the balance of a specific user at a certain limit i.e. with 3 million rows becomes slow. Now I am thinking…
I know that this MariaDB version 5.5.68 is really out of date, but I have to stay with this old version for a while. Is there a way to prevent toxic selects, possibly blocking MyISAM tables for a longer time…
Let's say I have a table like this: id | amount ------------------------- 1 | 10 1 | 10 2 | 20 2 | 10 3 | 20 3 | 10 3 | 10 4 | 10 Let's say id 1…
Hello all how can get two same name column from two different table as single result in two different column as combine result. Eg: customer table have column customerid custmerId customerName 1 row 2 row Order Table it has also…
let's say i have this id center right 1 Two NULL 1 NULL Three and want to be like this id center right 1 Two Three my first table is just a representation of what actually I am encountering, everything…
I'm trying to sort a MySQL table data based on a column values. id record_number created_at updated_at 1 ent/4/2022 2022-10-24 20:34:25 2022-10-24 20:34:25 3 ent/6/2021 2022-10-24 20:35:03 2022-10-24 20:35:03 The column is named record_number and the values of column follow…
Before I state the issue I'll mention I'm using PHP and laravel 9, and my database is mysql with the following charset and collation: 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', I am working with ADIDs and a table called devices…