MySQL: LAST_INSERT_ID() returns 0

tpope / vim-dadbod

dadbod.vim: Modern database interface for Vim

https://www.vim.org/scripts/script.php?script_id=5665

3.73k stars 132 forks source link

MySQL: LAST_INSERT_ID() returns 0 #165

Open Phantasimay opened 7 months ago

Phantasimay commented 7 months ago

hi master, i love your plugin, its great, but i have problen with command LAST_INSERT_ID() in mysql it return 0, not what really last insert in my auto_increment id. i was search relate topic on this. As far as i know it because new connection id every query so LAST_INSERT_ID not recorded. could you give me guide to fix it or to set PersistentConnections true. thanks.