I want a select that if/exists it returns the ‘link’ value instead of regular output. so instead of ‘1’ it returns the ‘link’ Is that possible? SELECT IF( EXISTS( SELECT link FROM modules WHERE module=’license’ ), 1, ‘/dashboard/’ ) >Solution : Use aggregation with MAX() (or MIN()): SELECT COALESCE(MAX(link), ‘/dashboard/’) link FROM modules WHERE module… Read More mysql if exists return the record value instead of regular output

I want to write a SQL Query to fetch 1st rehire, termination date and 2nd rehire, termination dates of employee if employee doesn’t having those dates then it will display blank(null) in result. Having table name as per_periods and date start column is contains hire/rehire date and actual termination date contains terminations dates.In image 1st&2nd… Read More retrieving first rehire and terminated dates and second rehire and termination of employee

My table with value id ssid_no end_date 1 5415345 18/12/2020 2 4656845 18/12/2020 3 8554511 01/05/2019 I want to make group but eliminite dublicate and select first id row. in example eliminate after group select id=’1′ row(1,2 row have dublicate select first one) and id= ‘3’ row >Solution : SELECT * FROM (SELECT id, ssid_no,… Read More How get first row from duplicate values mysql query

I am using this code: WHERE date > DATE_SUB(CURDATE(), INTERVAL 3 DAY) And result will be like this: 2022-05-12 2022-05-11 2022-05-10 But I want this: 2022-05-11 2022-05-10 2022-05-09 >Solution : Use a range here: WHERE date < CURDATE() AND date >= DATE_SUB(CURDATE(), INTERVAL 3 DAY) Assuming today’s date be 2022-05-12, the above logic would exclude… Read More How to get last 3 days records from database without today?

I have an INSERT statement below, taking from 3 inputs that will be passed from a php post request. The statement below returns an error INSERT INTO orderitems (orderId, productId, quantity, productName, price) (korderid, kproductid,kquantity, SELECT p.productName, p.price from products p WHERE p.id=kproductid) The error being: The following query has failed: "CREATE PROCEDURE `CreateOrderItem`(IN `korderid`… Read More MySQL stored prod insert from IN data and other table

I have a table with records in TableA.ColumnA like this: New York City New York New Rochelle York Town I am doing Select group_concat(ColumnA SEPARATOR ‘;’) from TableA but naturally end up with; New York City; New York; New Rochelle; York Town when what I am looking for is: New; York; City; Rochelle; Town In… Read More How to remove duplicate words within columns using group_concat?

I want to save text separated by \ as a category. I have to save each \ to represent a subcategory. How can I go about this? $cats = "Category \ SubCategory \ SubSubCategory"; $categories = explode ("\\",$cats); foreach($categories as $category){ $db->query("INSERT INTO `cat` SET name = ‘" . $category . "’, parent_id = ‘0’… Read More Saving slash-separated texts as categories

If I have a table with an id column (Autoincrement). How to get the value of the next insert id before actually inserting a new record in the same transaction? >Solution : You can do this query: SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA, TABLE_NAME) = (‘mydatabase’, ‘mytable’); (Of course you would name your database and… Read More How to determine next insert id value (inside a transaction) before actually inserting a new record?

how do i show all values from this table +——+———+——-+——–+—–+ | A | B | C | D | E | +——+———+——-+——–+—–+ | 2 | K | M | NULL | S | | 3 | L | C | NULL | N | | 4 | R | P | NULL | N |… Read More How do i show values from the table

I have a field in a MySQL table called quantity. I would like the quantity field to be able to store the following numbers: 0.25, 0.5, 0.75 and 1. I currently have the field set as DECIMAL(2,2) as according to the MySQL docs. It all works well, except for the 1, it always stores in… Read More Can a MySQL field store an INT and a Decimal?