X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=db-mysql%2Fmysql-sql.lisp;h=80d9ce13e8e31b20444b803748ffa3de28debe56;hp=eef9f42283db629062d267572eed5970a7950c18;hb=3c3aa36478f0609e60d83e6c936bf2096fcae726;hpb=d723e681ead5613b5ad8ad463c0bbd0c8f6aba1f diff --git a/db-mysql/mysql-sql.lisp b/db-mysql/mysql-sql.lisp index eef9f42..80d9ce1 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)