MYSQL C#.net

Question

hi, In sql, insert into TABLENAME (COLUMNS..) values(1,2...);select scope_identity. above query gives primary key of inseted row. \how this in MYsql query.? help me pls