[SQL]auto_increment

#-- 利用 LAST_INSERT_ID() 取得上一筆 AUTO_INCREMENT
#-- *注意* 此函數僅返回此次 Connection所Insert之AUTO_INCREMENT, 故如未Insert則為 0
INSERT INTO [DB_name] (uid, name, mobile_phone, email, cretat_ts) VALUES (NULL, "Glenn", "0912345678", CONCAT(LAST_INSERT_ID() + 1, "@dkstu.com"), UNIX_TIMESTAMP());

#-- 獲取指定表的 AUTO_INCREMENT
select AUTO_INCREMENT from INFORMATION_SCHEMA.TABLES where TABLE_NAME = [DB_name] ;