Show the provinces that has more patients identified as 'M' than 'F'. Must only show full province_name patient table : patient_id INT first_name TEXT last_name TEXT gender CHAR(1) birth_date DATE city TEXT province_id CHAR(2) allergies TEXT height INT weight INT…
I have a stored procedure where the column name is coming in the parameter as string - varchar How to convert this to a column name to query in the select/insert/update as column name should be colnName Thanks How to…
I have a large data table containing details by date and across 3 independent criteria with around 12 discreet values for each criteria. That is, each criteria field in the table is defined as a 12 value ENUM. Users pull…
Here is the query to find the address from a table where it matches to variable $fromCity, $fromCity= "324 West Gore Street, Orlando, FL 32806, USA"; $sql = "SELECT * FROM vendor_info WHERE mailing_address LIKE '$fromCity'"; $em = $this->getDoctrine()->getManager(); $stmt…
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…