Home / Questions / 235419
Accepted
Bernardo Harreguy
Asked: 2020-02-06 08:51:28 +0800 CST 2020-02-06 08:51:28 +0800 CST

Insert new record if condition is met

  • 772

I would like to know how a new record can be inserted in a table when a condition is met. In SQLlite you can as far as I know, but in MARIADB I can't do it. An example of what I would like to do:

INSERT INTO rubros (nombre) SELECT 'Articulos varios' WHERE nombre != 'Articulos varios' ;

This code is tested and returns the following error:

sql error(1064): Something is wrong in your syntax near "WHERE name != 'Miscellaneous Items'" on line 1

In this case, it would be to enter in the table "Items" the record with the name "Miscellaneous articles" if it does not exist. Namely

INSERT INTO table (value) SELECT * WHERE (Condition) In condition, if it is fulfilled, the record is inserted.

PS: I have tried this answer and it didn't work, I have MariaDB version 10.3.12. The code I used to try to use "EXISTS" is the following code:

INSERT INTO rubros (nombre, descripcion) 
SELECT 'Articulos varios', '' 
WHERE EXISTS (
    SELECT nombre FROM rubros WHERE nombre = 'Articulos varios'
)  ;

The error that I get is the following:

sql error(1064): Something is wrong in your syntax near " WHERE EXISTS (SELECT name FROM items WHERE name = 'Miscellaneous Items') " on line 1

From already thank you very much

mariadb

2 Answers

  1. Best Answer

    Try using a FROM in your query, using the table dual.

    INSERT INTO rubros (nombre, descripcion) 
SELECT 'Articulos varios', '' 
FROM dual
WHERE EXISTS (
    SELECT nombre FROM rubros WHERE nombre = 'Articulos varios'
)  ;

    This following the logic in this answer .

    • 3

  2. Shouldn't your query have a from?

    INSERT INTO rubros (nombre) SELECT 'Artículos varios' From rubros WHERE nombre != 'Artículos varios' ;
    • -3