/// <summary> /// Should return a SELECT statement that can be used to obtain the value from a auto increment / identity field /// after an INSERT statement. /// </summary> public virtual string SerializeAutoIncrementValue(SQLAutoIncrementValue autoIncrementValue) { return "SELECT @@IDENTITY AS " + SerializeIdentifier(autoIncrementValue.ReturnFieldName); }
public override string SerializeAutoIncrementValue(SQLAutoIncrementValue autoIncrementValue) { // The @@IDENTITY function is supported by MySQL from version 3.23.25. // The original function is being used just in case. return "SELECT LAST_INSERT_ID() AS " + SerializeIdentifier(autoIncrementValue.ReturnFieldName); }
public override string SerializeAutoIncrementValue(SQLAutoIncrementValue autoIncrementValue) { return "SELECT IDENTITY() AS " + SerializeIdentifier(autoIncrementValue.ReturnFieldName); }
public override string SerializeAutoIncrementValue(SQLAutoIncrementValue autoIncrementValue) { return "SELECT last_insert_rowid() AS " + autoIncrementValue.ReturnFieldName; }