Top "Insert" questions

Python and SQLite: insert into table

I have a list that has 3 rows each representing a table row: >>> print list [laks,444,M] [kam,445,…

python sqlite list insert

SQL Server: Cannot insert an explicit value into a timestamp column

When using this statement create table demo ( ts timestamp ) insert into demo select current_timestamp I get the following error: …

sql sql-server-2008 insert timestamp

How to insert current datetime in postgresql insert query

INSERT into Group (Name,CreatedDate) VALUES ('Test',UTC_TIMESTAMP(), 1); This is the query I have used for mysql to insert …

postgresql datetime insert

How to create a new column in a select query

In MS Access, I want to insert a new column into the returned result of a select query. The new …

sql ms-access select insert

MySql Table Insert if not exist otherwise update

UPDATE AggregatedData SET datenum="734152.979166667", Timestamp="2010-01-14 23:30:00.000" WHERE datenum="734152.979166667"; It works if the datenum exists, but I want to insert …

mysql insert

MySQL error 1241: Operand should contain 1 column(s)

I am trying to Insert data from a table1 into table2 insert into table2(Name,Subject,student_id,result) select (…

mysql sql select insert mysql-error-1241

Inserting Data into Hive Table

I am new to hive. I have successfully setup a single node hadoop cluster for development purpose and on top …

sql insert hadoop hive

java: use StringBuilder to insert at the beginning

I could only do this with String, for example: String str=""; for(int i=0;i<100;i++){ str=i+str; } …

java string insert append stringbuilder

MySQL - How to parse a string value to DATETIME format inside an INSERT statement?

I have a MySQL database, with a column that is date type DATETIME. I am getting a string value for …

mysql datetime insert

Add row to query result using select

Is it possible to extend query results with literals like this? select name from users union select name from ('JASON'); …

sql sql-server tsql select insert