我找到了这个例子RichardTheKiwi信息丰富。
只是为了提供另一种方法,如果你想要的是IF EXISTS (SELECT 1 ..) THEN ...
-我用MSSQL写的东西IF EXISTS (SELECT 1 FROM Table WHERE FieldValue='')BEGIN
SELECT TableID FROM Table WHERE FieldValue=''ENDELSEBEGIN
INSERT INTO TABLE(FieldValue) VALUES('')
SELECT SCOPE_IDENTITY() AS TableIDEND
-为MySQL重写IF (SELECT 1 = 1 FROM Table WHERE FieldValue='') THENBEGIN
SELECT TableID FROM Table WHERE FieldValue='';END;ELSEBEGIN
INSERT INTO Table (FieldValue) VALUES('');
SELECT LAST_INSERT_ID() AS TableID;END;END IF;