Top "Insert" questions

last insert id with zend db table abstract

variable $tablemodel in an instance of a model which extends Zend_Db_Table_Abstract, if i do $tablemodel->insert($…

php zend-framework insert zend-db

How to improve INSERT INTO ... SELECT locking behavior

In our production database, we ran the following pseudo-code SQL batch query running every hour: INSERT INTO TemporaryTable (SELECT FROM …

mysql select insert locking innodb

How to get the object id in PyMongo after an insert?

I'm doing a simple insert into Mongo... db.notes.insert({ title: "title", details: "note details"}) After the note document is …

mongodb insert pymongo

How can mysql insert millions records faster?

I wanted to insert about millions records into my database, but it went very slow with a speed about 40,000 records/…

mysql insert records

insert into database from Joomla form fields

I am beginner to Joomla! development and have created a very simple module. How do I create a form with 3 …

database forms joomla insert

Prevent auto increment on MySQL duplicate insert

Using MySQL 5.1.49, I'm trying to implement a tagging system the problem I have is with a table with two columns: …

mysql insert duplicates innodb auto-increment

SSIS - Delete rows

I'm new to SSIS and need help on this one. I found an article which describes how to detect rows …

ssis insert delete-row sql-delete

Copying data between Oracle schemas using SQL

I'm trying to copy data from one Oracle schema (CORE_DATA) into another (MY_DATA) using an INSERT INTO (...) SQL …

sql oracle insert oracle10g bulkinsert

Android: Insert text into EditText at current position

I want to insert a constant string into an EditText by the press of a button. The string should be …

android insert android-edittext

Python psycopg2 not inserting into postgresql table

I'm using the following to try and insert a record into a postgresql database table, but it's not working. I …

python postgresql insert psycopg2