I have a table that must have only one row. if this row exist don't do nothing if there is no row insert data that does NOT contain the indexs field
I tried to use the below code but I get an error:
select count(id) into @myvar from customer;
IF(@myvar>0)
BEGIN
INSERT INTO customer
(dateformat, alarmDays, backup, pastPass, loginFails, passLength, timetochangepass)
values('d,m,y',30, 30, 3, 5, 8, 90)
END