X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=db-mysql%2Fmysql-sql.lisp;h=503da2a71ddd5f3a16150e76248f67e94ea9e6cb;hb=1a446890f95ab363af82529a133546d722ef21b1;hp=eef9f42283db629062d267572eed5970a7950c18;hpb=1976149b4ba76ce4fcaca8a53c1fad89374e2be1;p=clsql.git diff --git a/db-mysql/mysql-sql.lisp b/db-mysql/mysql-sql.lisp index eef9f42..503da2a 100644 --- a/db-mysql/mysql-sql.lisp +++ b/db-mysql/mysql-sql.lisp @@ -487,6 +487,12 @@ (%sequence-name-to-table sequence-name)) database :auto nil)))) +(defmethod database-last-auto-increment-id ((database mysql-database) table column) + (declare (ignore table column)) + (car (query "SELECT LAST_INSERT_ID();" + :flatp t :field-names nil + :database database))) + (defmethod database-create (connection-spec (type (eql :mysql))) (destructuring-bind (host name user password) connection-spec (let ((database (database-connect (list host "" user password)