mardi 21 juillet 2020

canon set a variable using the if statement

I have a problem with setting the @temp variable. The if statement below fails. I have tried various combinations with quotes, using the SELECT command, but I can't get it to work.

What am I doing wrong?

Thanks! Mike

SET @Stime := '6:30PM';

IF ( CHAR_LENGTH(@Stime) = 6, SET @temp := 'one', SET @temp := 'two');

Aucun commentaire:

Enregistrer un commentaire