Top "Insert" questions

How do I switch between command and insert mode in Vim?

I just started using Vim as an IDE. I was using it as a test editor for a while now, …

vim insert command

Escaping single quote in PHP when inserting into MySQL

I have a perplexing issue that I can't seem to comprehend... I have two SQL statements: The first enters information …

php mysql insert escaping

Combining INSERT INTO and WITH/CTE

I have a very complex CTE and I would like to insert the result into a physical table. Is the …

tsql insert common-table-expression

Object of class DateTime could not be converted to string

I have a table with string values in the format of Friday 20th April 2012 in a field called Film_Release …

php mysql datetime insert

Export specific rows from a PostgreSQL table as INSERT SQL script

I have a database schema named: nyummy and a table named cimory: create table nyummy.cimory ( id numeric(10,0) not null, …

postgresql insert export sql-scripts postgresql-copy

Increment a database field by 1

With MySQL, if I have a field, of say logins, how would I go about updating that field by 1 within …

mysql insert increment

Replace an element into a specific position of a vector

I want to replace an element into a specific position of a vector, can I just use an assignment: // vec1 …

c++ visual-c++ vector stl insert

Oracle SQL: Use sequence in insert with Select Statement

Basically I want to run the following query: INSERT INTO historical_car_stats (historical_car_stats_id, year, month, make, …

sql oracle plsql insert sequence

Java - Including variables within strings?

Ok, so we all should know that you can include variables into strings by doing: String string = "A string " + aVariable; …

java variables insert include quotation-marks

PHP mySQL - Insert new record into table with auto-increment on primary key

Wondering if there is a shorthand version to insert a new record into a table that has the primary key …

php mysql insert auto-increment