Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
K
K
khodos_dmitry2018-03-01 12:05:22
MySQL
khodos_dmitry, 2018-03-01 12:05:22

What is @lastID in this entry: SET @lastID := LAST_INSERT_ID()?

Haven't come across this yet.
And another question: does LAST_INSERT_ID() take the value of the last updated row? Not inserted, but updated.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
O
OKyJIucT, 2018-03-01
@khodos_dmitry

This is a variable that can be used in further queries. No, it only takes the value of the last inserted row.

Similar questions
N
NyxDeveloper2021-05-04 16:15:55
How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply
E
emerysh2017-06-09 00:18:28
How to compare fields from different tables? 1Reply
V
viktorross2019-11-09 23:29:52
How to make a record in 2 mysql tables? 2Reply
Q
Questions00012021-05-07 16:07:05
How to bypass intrusive Youtube ads? ad blockers don't help. You need to switch to a paid plan to stop ads. What can be done? 4Reply
#
#FFFFFF2019-11-19 14:39:34
What is better to use for e2e testing Vue? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question