Top "Insert" questions

INSERT INTO SELECT CASE

I have two tables, Variables and Processes. I want to implement a INSERT INTO SELECT CASE, but I've never done …

sql sql-server select insert select-case

MySQL 5.6 Error 1054: Unknown column in 'field list' on INSERT

I'm using MySQL Workbench to create and manage a comic book store database. I'm having a problem inserting rows into …

mysql sql database insert mysql-error-1054

Insert xml into XmlType field

I have this table in Oracle 11g: create table tmp_test_xml ( name_xml varchar2(4000), file_xml xmltype ); At this …

sql oracle insert oracle11g xmltype

Move SQL Server data in limited (1000 row) chunks

I'm writing a process that archives rows from a SQL Server table based on a datetime column. I want to …

sql-server insert rowcount

ORA-00984 column not allowed here

I am getting error "Execute-984 ORA-00984: column not allowed here" while I am inserting values in my table Registred_Customer …

sql oracle insert oracle-pro-c ora-00984

Change elements positions in an array and shift elements in between

I would like to pick an element in an array, move it to another index, and then "shift/rotate" the "…

javascript arrays insert rotation shift

How to insert null value in Database through parameterized query

I have a datetime datatype : dttm Also the database field type is datatime Now I am doing this: if (dttm.…

c# sql datetime insert parameterized-query

Kotlin prepend element

I am searching for Kotlin alternative to: (cons 1 '(2 3)) in lisp or 1 : [2, 3] in haskell or 1 :: List(2, 3) in scala, (which all …

list insert kotlin prepend cons

Visual Studio Permanently Disable Overwrite

I have a minor annoyance with Visual Studio. In the bottom right hand corner of Visual Studio, there is a …

visual-studio insert overwrite

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