Write an SQL query to report the patient_id, patient_name all conditions of patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix. +--------------+---------+ | Column Name | Type | +--------------+---------+ | patient_id | int | |…
I have mysql DB with important financial data, currently the data is stored as float type and I get incorrect data due to float rounding, I want to store it as DECIMAL. What is the safe way to convert the…
I am looking to replace the NULL values that occur as a result of a SQL JOIN statement, with 'N/A'. I have tried to set the default value of both related columns from both tables to N/A, however, every time…
I have a simple stored procedure with comma separated input params. I will send Database Names in Json or Comma separated values. Like DB1,DB2,DB3 etc..; When ever I send that parameter will be loading that table in each of the…
My paintings table looks like this | id | artist_id | name | 1 | 7 | landscape painting | 2 | 15 | flowers painting | 3 | 15 | scuffed painting The artist_id is indexed and the name…
I have 2 tables in a database, users and users_removed with columns "id(primary key), email(unique), password" and "id, user_id(foreign key (user_id) references users(id)" respectively. When a user registers the users table gets the data accordingly. And when the user wants…
For my assessment I have to obtain such result from mysql database: +---------------------------------------+---------------------------------------+-------+ | name | name | item | +---------------------------------------+---------------------------------------+-------+ | Krispy Kreme - Edinburgh Lothian Road | 6 Assorted Doughnuts | 12.95 | | Krispy Kreme - Edinburgh…
New to programming and looking for help please, i need to the set the value of $b_num based on the value of $egg_type i have tried using an if statement but not having any luck ` $egg_type = $row["egg_type"] ;…
I have two tables Table products : product_id,name,barcode1,barcode2,barcode3 Table more_barcodes: product_id,barcode How to join those two tables when user search barcode ? select products.* from products LEFT JOIN more_barcodes ON products.product_id=more_barcodes.product_id where ( (products.barcode1 LIKE '%$user_search%') OR (products.barcode2 LIKE '%$user_search%'…
I have a simple table like this, CREATE TABLE `domain` ( `id` varchar(191) NOT NULL, `time` bigint(20) DEFAULT NULL, `task_id` bigint(20) DEFAULT NULL, `name` varchar(512) DEFAULT NULL PRIMARY KEY (`id`), KEY `idx_domain_time` (`time`), KEY `idx_domain_task_id` (`task_id`), FULLTEXT KEY `idx_domain_name` (`name`),…