I am trying to create a CTE in Oracle that doesn’t select from an existing table but instead has data inserted into it. Currently, I am creating a table and then dropping it after the query is done. …
Tag: insert
Hive Insert Overwrite Table
I’m new to Hive and I wanted to know if insert overwrite will overwrite an existing table I have created. I want to filter an already created table, let’s call it TableA, to only select the rows where …
SqlCommand INSERT INTO query does not execute
Hello guys I have got this code: It should insert data from textboxes: kname, ksurname, but it closes the form without showing them in MS SQL table klient Answer Missing the ExecuteNonQuery call A command should be executed to update the database…
Oracle equivalent of INSERT IGNORE
I found a very similar topic on Oracle Equivalent to MySQL INSERT IGNORE? However, I could not make work any of the proposed solutions. My case is a little special as my table does contains only 1 field, which is the primary key. Let’s call the field “id” and the table “myTable” in the following. Using MERGE This first attempt
MySQL INSERT INTO … VALUES and SELECT
Is there a way to insert pre-set values and values I get from a select-query? For example: I have the value of “A string” and the number 5, but I’ve to find the [int] value from a select like this: that gives me that id to put inside table1. How to merge this into one statement? Answer Use an insert
MySQL Error 1264: out of range value for column
As I SET cust_fax in a table in MySQL like this: and then I insert value like this: but then it say `error 1264` out of value for column And I want to know where the error is? My set? Or other? Any answer will be appreciated! Answer The value 3172978990 is greater than 2147483647 – the maximum value for
SQL Server: Cannot insert an explicit value into a timestamp column
When using this statement I get the following error: Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column How do I insert the current time to a timestamp column? Answer According to MSDN, timestamp Is a data type that exposes automatically
VB.net SQL error Must Declare the Scalar Variable
Hi I have been stuck for a long time on this simple but obtuse message “Must Declare the Scalar Variable” I have a vb.net and SQL code that inserts data into a simple table. It works OK with sample …
0 rows inserted – How can I fix this?
I an trying to INSERT multiple rows into an SQL, Oracle table though SQL Developer v3.0.04 the Database was set-up by Uni so I don’t know what version it is. after looking on-line I have come up with the code below but it will not INSERT any data. I have tested the insert with just one row and that is
How to copy a row and insert in same table with a autoincrement field in MySQL?
In MySQL I am trying to copy a row with an autoincrement column ID=1 and insert the data into same table as a new row with column ID=2. How can I do this in a single query? Answer Use INSERT … SELECT: where c1, c2, … are all the columns except id. If you want to explicitly insert with an