Top "Sql-insert" questions

The SQL INSERT statement allows you to insert a single or multiple rows into a table.

MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields

From MySQL 4.1.0 onwards, it is possible to add ON DUPLICATE KEY UPDATE statement to specify behavior when values inserted (with …

mysql sql-update sql-insert upsert
Why Bulk Import is faster than bunch of INSERTs?

I'm writing my graduate work about methods of importing data from a file to SQL Server table. I have created …

sql sql-server performance sql-insert bulkinsert
Insert Null into SQLite3 in Python

I am trying to insert a None value into a row entry of my db. The table present exists db.…

python sqlite sql-insert
Inserting values from my TextField in Java into a database

I'm a newbie here and I would have one question that I'm having hard times getting an answer to. I …

java swing jtextfield sql-insert actionevent
MSSQL Trigger - Updating newly inserted record on INSERT

I wish to make a modification (Set Deleted = 1) to rows being inserted into my table CustomerContact if the SELECT statement …

sql-server triggers sql-update sql-insert last-insert-id
REPLACE INTO, does it re-use the PRIMARY KEY?

The REPLACE INTO function in MySQL works in such a way that it deletes and inserts the row. In my …

mysql sql duplicates sql-insert sql-delete
mysql: insert record if not exists else return the id of record

i need to insert unique values in a table, and need the ids of records, need to insert those id's …

mysql sql sql-insert
SQLMAP - how to insert into a database if stacked queries are not possible on a MYSQL server?

Pulling database tables and columns works fine using SQLMAP, but as I try to execute an INSERT statement I get …

mysql sql sql-insert stacked sqlmap
MySQL - insert if doesn't exist yet

I want to execute this MySQL query: INSERT INTO `cron-stats` (`user`) VALUES (".(int)$d['by-user'].") Whenever such user doesn't exist …

php mysql sql sql-insert
How can I insert the return of DELETE into INSERT in postgresql?

I am trying to delete a row from one table and insert it with some additional data into another. I …

postgresql sql-insert sql-delete