Top "Sql-insert" questions

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

Is there any way to show progress on a `gunzip < database.sql.gz | mysql ...` process?

Once a week I need to run a giant database update into my local development environment like so: $ gunzip < /…

mysql sql progress sql-insert gunzip
1292: Incorrect datetime value: '' for column at row 1

I am trying to load data from excel sheet to the below table on MYSQL 5.6 on windows 8.1 and I am …

mysql sql datetime sql-insert sql-mode
insert string which includes quotes in oracle

How can I insert string which includes quotes in oracle? my code is INSERT INTO TIZ_VADF_TL_MODELS (name) …

sql string oracle sql-insert clob
Insert query check if record exists - If not, Insert it

I have a mysql table ip_list... +----+---------------+ | id | ip_addr | +----+---------------+ | 1 | 192.168.100.1 | | 2 | 192.168.100.2 | | 3 | 192.168.100.3 | | 4 | 192.168.100.4 | | 5 | 192.168.100.5 | +----+---------------+ I want to add …

php mysql sql sql-insert
Insert Multiple Rows SQL Teradata

I am creating a volatile table and trying to insert rows to the table. I can upload one row like …

sql teradata sql-insert
"ORA-01733: virtual column not allowed here" when inserting into a view

I created a view called "view_employee" like this: CREATE VIEW view_employee AS SELECT employee.surname || ', ' || employee.…

sql oracle10g sql-insert sql-view
Escaping single quotes in REDSHIFT SQL

I've lots of string values containing single quotes which I need to insert to a column in REDSHIFT table. I …

sql escaping amazon-redshift sql-insert single-quotes
Best practices for inserting/updating large amount of data in SQL Server 2008

I'm building a system for updating large amounts of data through various CSV feeds. Normally I would just loop though …

sql csv sql-update feed sql-insert
How to reset an Access table's AutoNumber field? (it didn't start from 1)

I have a INSERT INTO ... SELECT statement that copies data from one table to another. The thing though is, the …

sql ms-access sql-insert autonumber
Postgres INSERT ON CONFLICT DO UPDATE vs INSERT or UPDATE

I have stock_price_alert table with 3 columns. stock_price_id is PRIMARY KEY & also FOREIGN KEY to other …

postgresql sql-update sql-insert