How to set the parameter of the cell so that information is recorded there when you import data if its length is equal to exactly five characters and starts at a certain number, for example 2?
Answer 1
create trigger check_available
BEFORE INSERT ON TABLE
For Each Row
Begin.
SELECT if.stringcolunm & lt; & gt; 5 and substring (new.stringcolunm, 1, 1) & lt; & gt; 2) Then.
Set new.stringcolunm = ''
END IF;
End.