Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql get last insert id

SELECT MAX(id) AS last_id FROM users
-- last_id --
-- 33 --
Comment

mysql set last_insert_id

SET @last_id = LAST_INSERT_ID();
Comment

mysql update LAST_INSERT_ID()

set LAST_INSERT_ID= 58 -- your last id
Comment

PREVIOUS NEXT
Code Example
Sql :: sql current timestamp table 
Sql :: create a sqlite database c# 
Sql :: select where duplicate mysql 
Sql :: sql pagination oracle 
Sql :: database dump mysql command 
Sql :: oracle sql select all days between two dates except weekends 
Sql :: remove unique key from a table 
Sql :: oracle log files 
Sql :: postgresql check privileges on schema 
Sql :: space not removing from column in sql 
Sql :: xampp import sql file command line 
Sql :: drop temp table if exists 
Sql :: check lock on table in sql server 
Sql :: postgres select as csv 
Sql :: select random sql 
Sql :: print hello world in plsql 
Sql :: use group_concat in concat 
Sql :: Cast for print sql 
Sql :: mysql if null 
Sql :: python sqlite3 update 
Sql :: SQL Greater Than or Equal to Operator 
Sql :: sql create database 
Sql :: SQL server how to see user permissions on objects 
Sql :: inner join distinct 
Sql :: sql format time 
Sql :: how to set a column as unique in sql server 
Sql :: mysql select distinct date from timestamp 
Sql :: mysql date format 
Sql :: create table with index mysql 
Sql :: sql stored procedure update if parameter is not null 
ADD CONTENT
Topic
Content
Source link
Name
6+8 =