Top "Insert-update" questions

A mixed flavour of data entry mode and data modification mode.

Insert character into SQL string

I have an nvarchar column I need to insert a hyphen at fixed points within the string. The hyphen need …

sql insert-update
Is there possible to use createQueryBuilder for insert/update? If not, what function should I use?

For now I succeded to create a function that retrieves data from the database using Doctrine's function createQueryBuilder. Does anybody …

symfony doctrine-orm insert-update createquery
Update the value of a field in database by 1 using codeigniter

I want to implement a SQL statement using codeigniter active record. UPDATE tags SET usage = usage+1 WHERE tag="java"; How …

database activerecord codeigniter insert-update
How do I Insert or Update (or overwrite) a record using NHibernate?

I need to write a row to the database regardless of whether it already exists or not. Before using NHibernate …

nhibernate insert-update overwrite upsert
T-SQL Insert or update

I have a question regarding performance of SQL Server. Suppose I have a table persons with the following columns: id, …

sql-server tsql insert-update
Prolog Create a List

I have to create list of n elements for example, do_list(5,L1). should return, L1=[1,2,3,4,5]. This is what I …

list prolog insert-update
Why are 2 rows affected in my `INSERT ... ON DUPLICATE KEY UPDATE`?

I'm doing an INSERT ... ON DUPLICATE KEY UPDATE for a PRIMARY KEY in the following table: DESCRIBE users_interests; +------------+…

mysql insert insert-update
Is there a way to do an "INSERT...ON DUPLICATE KEY UPDATE" in Zend Framework 1.5?

I would like to use ON DUPLICATE KEY UPDATE in Zend Framework 1.5, is this possible? Example INSERT INTO sometable (...) VALUES (...) …

php mysql zend-framework insert-update
Android/SQLite: Insert-Update table columns to keep the identifier

Currently, I am using the following statement to create a table in an SQLite database on an Android device. CREATE …

android sqlite android-contentprovider insert-update
Django - save() update on duplicate key

I have little application which allows a user to rate a video. The user can rate only once. So I …

django save unique-constraint insert-update