Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql id of inserted row

-- For mysql
INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);
SELECT LAST_INSERT_ID();
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle synonym 
Sql :: create email address from first and last name in sql 
Sql :: mysql random number between 1 and 100 
Sql :: sql remanecolumn 
Sql :: mysql bidirectional composite primary key 
Sql :: how to start mysql in terminal 
Sql :: mysql get domain from url 
Sql :: oracle list datafiles in tablespace 
Sql :: set permanent SET GLOBAL sql_mode ubuntu 
Sql :: sql comment header 
Sql :: oracle get nls settings 
Sql :: mysql add comment to column 
Sql :: how to connect mysql with specify port thorugh cmd 
Sql :: how to insert string variable into sqlite database 
Sql :: how to delete duplicate rows in oracle 
Sql :: sql update query 
Sql :: dbms_output.put_line 
Sql :: sql string_agg 
Sql :: oracle add months to sysdate 
Sql :: sql drop table statement 
Sql :: delete all table oracle 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: mysql delete 
Sql :: mysql sysdate - 1 day 
Sql :: ms sql truncate table vs delete 
Sql :: mysql persistence.xml 
Sql :: sql server select where date 
Sql :: show size database mysql 
Sql :: mysql reset root password 
Sql :: sql display number without decimals 
ADD CONTENT
Topic
Content
Source link
Name
5+6 =