Answers for "gow to update a mysql table if the rows is not already present"

insert if not exists mysql

INSERT INTO table_listnames (name, address, tele)
SELECT * FROM (SELECT 'Unknown' AS name, 'Unknown' AS address, '022' AS tele) AS tmp
WHERE NOT EXISTS (
    SELECT name FROM table_listnames WHERE name = 'Rupert'
) LIMIT 1;

Posted by: Guest on April-27-2020

Code answers related to "gow to update a mysql table if the rows is not already present"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language

Answers for "gow to update a mysql table if the rows is not already present"

Code answers related to "gow to update a mysql table if the rows is not already present"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language

Answers for "gow to update a mysql table if the rows is not already present"

Code answers related to "gow to update a mysql table if the rows is not already present"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us