Get the last inserted row ID (with SQL statement)

Very important

To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
You will only see chat messages from people who are at or below your level.
More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

Thread Rating:

704 Vote(s) - 3.55 Average
1
2
3
4
5

Options

Get the last inserted row ID (with SQL statement)

repertoire29

Valued member

Posts: 1
Threads: 1
Joined: Jan 2020
Reputation: 0

Level: 1 [ Level

]
Total Points: 0
Rank 0 / 1
99% to upload Level

Activity 0 / 1
99% to upload your Rank

Experience 1
99% to upload Experience

Points: 50

07-31-2023, 01:36 AM

I want to get the new created ID when you insert a new record in table.

I read this:

[To see links please register here]

but it needs to create temporary table.

I want to return the ID after executing INSERT statement (assuming executing just one INSERT).

Example:

1 Joe Joe
2 Michael Mike
3 Zoe Zoe

When executing an INSERT statement, I want to return the created ID, means 4.

Can tell me how to do that using SQL statement or it is not possible ?

« Next Oldest

Next Newest »

Forum Jump:

Users browsing this thread:

1 Guest(s)