MariaDB insert into where

Question

New to sql/mariaDB. Looking for the correct syntax when trying to insert a value into a column where another column equals something.

so far this is what i've tried however this doesn't correspond with mariaDB syntax

   INSERT INTO client(payment)
   values
   (50.00)
   where client_info = 5359;

looking to insert the value 50.00 into payment where the column client info equal 5359?

Madhur Bhaiya · Accepted Answer · 2018-11-18 16:02:22Z

2

You are looking for UPDATE clause, as you are not trying to insert a new row, but update the existing row:

UPDATE client
SET payment = 50.00
WHERE client_info = 5359;

answered Nov 18, 2018 at 16:02

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1