Top "Sql-insert" questions

How to speed up insertion performance in PostgreSQL

I am testing Postgres insertion performance. I have a table with one column with number as its data type. There …

sql postgresql bulkinsert sql-insert

MySQL and PHP - insert NULL rather than empty string

I have a MySQL statement that inserts some variables into the database. I recently added 2 fields which are optional ($intLat, $…

php mysql null sql-insert

"Insert if not exists" statement in SQLite

I have an SQLite database. I am trying to insert values (users_id, lessoninfo_id) in table bookmarks, only if …

sqlite constraints sql-insert

"column not allowed here" error in INSERT statement

I created this table called LOCATION by doing this: CREATE TABLE LOCATION( POSTCODE VARCHAR(10) PRIMARY KEY, STREET_NAME VARCHAR(20), CITY …

sql oracle sql-insert

C# with MySQL INSERT parameters

Good day to all, I'm using Visual C# 2010 and MySQL Version 5.1.48-community. I hope you can help me with this …

c# mysql database sql-insert

Insert the same fixed value into multiple rows

I've got a table with a column, lets call it table_column that is currently null for all rows of …

mysql sql sql-update sql-insert

In SQL, is UPDATE always faster than DELETE+INSERT?

Say I have a simple table that has the following fields: ID: int, autoincremental (identity), primary key Name: varchar(50), unique, …

sql sql-insert sql-delete

Inserting data to table (mysqli insert)

I've been looking at this code for a while now and I can't see where the problem is. I have …

php database mysqli sql-insert

How do I insert NULL values using PDO?

I'm using this code and I'm beyond frustration: try { $dbh = new PDO('mysql:dbname=' . DB . ';host=' . HOST, …

php mysql pdo null sql-insert

In Oracle SQL: How do you insert the current date + time into a table?

I've written below code, but it only seems to insert the current date and not the current time. Anyone knows …

sql oracle datetime sql-insert