/// <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;
}
