InsertId Property

In This Topic

Returns the ID generated for an AUTO_INCREMENT column by the previous command.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property InsertId As Long

public long InsertId {get;}

Property Value

The ID generated for an AUTO_INCREMENT column.

Remarks

Use InsertId property after you have performed an INSERT command into a table that contains an AUTO_INCREMENT field.

If the command doesn't perform an insertion into a table that contains an AUTO_INCREMENT field the value of InsertId won't be defined.

When several rows are inserted, value of InsertId depends on FetchAll property. If FetchAll property is false, InsertId returns value for the first inserted row, otherwise it returns value for the last inserted row.

Example

In the following example an insert operation is performed assuming that DeptNo column in Test.Dept table has Autoincrement attribute. After running the query the value assigned to DeptNo for the inserted record is shown.

csharp

static void GetLastId(MySqlConnection myConnection)
{
  MySqlCommand myCommand = new MySqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", myConnection);
  myConnection.Open();
  try
  {
    myCommand.ExecuteNonQuery();
    Console.WriteLine(myCommand.InsertId);
  }
  finally
  {
    myConnection.Close();
  }
}

Visual Basic

Public Sub GetLastId(ByVal myConnection As MySqlConnection)
  Dim myCommand As New MySqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", myConnection)
  myConnection.Open()
  Try
    myCommand.ExecuteNonQuery()
    Console.WriteLine(myCommand.InsertId)
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

MySqlCommand Class
MySqlCommand Members

Send Feedback