Top "Sql-insert" questions

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

Setting an empty string to null on Insert into database

I haven't been able to find the right solution for this issue, and I know it's so simple but I …

c# .net string sql-insert dbnull
SQL INSERT INTO statement for MS Access

I am trying to learn how to use MS Access with my VB.net program. I am practicing learning how …

sql vb.net ms-access sql-insert oledbexception
Generating sql insert into for DataGrip

When you run a query (a SELECT statement) in the console, the data retrieved from the database are shown in …

insert sql-insert datagrip
Efficiently duplicate some rows in PostgreSQL table

I have PostgreSQL 9 database that uses auto-incrementing integers as primary keys. I want to duplicate some of the rows in …

sql postgresql sql-insert sql-returning
SQL Server Varchar to VarBinary Conversion

I have to insert the string "johnmelling" value into a table which has the column as [USERPASS] varbinary NOT NULL. …

varchar sql-insert varbinary
Insert in RMySQL from data frame

Im trying to add data to MySQL table by using RMySQL. I only need to add one row at a …

r dataframe sql-insert rmysql
Suppress "duplicate key value violates unique constraint" errors

I'm developing a Rails 3 app that uses Postgres as its database. I've got the table shown below: Table "public.test" …

sql ruby-on-rails postgresql duplicates sql-insert
MySQL "Insert ... On Duplicate Key" with more than one unique key

I've been reading up on how to use MySQL insert on duplicate key to see if it will allow me …

mysql sql sql-insert on-duplicate-key
Passing a record as function argument PL/pgSQL

First I am really new to pl/pgsql. Need it for a project. I am stuck with this (simplified) problem. …

postgresql types plpgsql common-table-expression sql-insert
android.database.sqlite.SQLiteConstraintException: error code 19: constraint failedexception

I created a table named resources but when I insert values in it, this exception is thrown: android.database.sqlite.…

android database sql-insert