Top "Insert" questions

How do I use an INSERT statement's OUTPUT clause to get the identity value?

If I have an insert statement such as: INSERT INTO MyTable ( Name, Address, PhoneNo ) VALUES ( 'Yatrix', '1234 Address Stuff', '1112223333…

sql sql-server-2005 insert

Get the new record primary key ID from MySQL insert query?

Let's say I am doing a MySQL INSERT into one of my tables and the table has the column item_…

mysql insert key auto-increment

PostgreSQL function for last inserted ID

In PostgreSQL, how do I get the last id inserted into a table? In MS SQL there is SCOPE_IDENTITY(). …

postgresql insert lastinsertid

How to insert data to MySQL having auto incremented primary key?

I've created a table with a primary key and enabled AUTO_INCREMENT, how do I get MYSQL use AUTO_INCREMENT? …

mysql insert

MySQL date formats - difficulty Inserting a date

I am trying to further a question I asked yesterday where I wanted to know how to query a date …

mysql date insert format

How to do a batch insert in MySQL

I have 1-many number of records that need to be entered into a table. What is the best way to …

mysql sql database insert

Field 'id' doesn't have a default value?

I am new to this SQL; I have seen similar question with much bigger programs, which I can't understand at …

mysql insert create-table

insert multiple rows via a php array into mysql

I'm passing a large dataset into a MySQL table via PHP using insert commands and I'm wondering if its possible …

php mysql codeigniter insert bulkinsert

Insert at first position of a list in Python

How can I insert an element at the first index of a list ? If I use list.insert(0,elem), do …

python list insert

Insert an element at a specific index in a list and return the updated list

I have this: >>> a = [1, 2, 4] >>> print a [1, 2, 4] >>> print a.insert(2, 3) None >&…

python python-2.7 list insert