Top "Insert-into" questions

Why is MySQL 'insert into ... select ...' so much slower than a select alone?

I'm trying to store a query result in a temporary table for further processing. create temporary table tmpTest ( a FLOAT, …

mysql performance temp-tables insert-into mysql-cluster

SELECT INTO syntax for Snowflake Datawarehouse

I believe there's an SELECT INTO-like syntax in Snowflake, but I am unable to find documentation or examples to use …

sql insert-into snowflake-cloud-data-platform

In MySQL, how do I insert 1 when string value is 'true', 0 when false, while preserving nulls

I am using an INSERT query that SELECTs from a plain-text database into a more query-friendly database. The following is …

mysql boolean insert-into string-conversion

Using WITH clause with INSERT statement in POSTGRESQL

I have a requirement in which I need to get one column from another table and insert that column data …

postgresql with-statement insert-into

Rails 3.2 + MySQL: Error: Field 'created_at' doesn't have a default value: INSERT INTO

I created a new migration, where is mentioned ... t.timestamps in the created table are added these two columns ... | created_…

mysql ruby-on-rails ruby timestamp insert-into

Move row from one table to another?

I have two tables with the same column definitions. I need to move (not copy) a row from one table …

sql-server sql-server-2005 insert-into

INSERT INTO using a query, and add a default value

I want run an INSERT INTO table SELECT... FROM... The problem is that the table that I am inserting to …

sql oracle insert-into

Does INSERT INTO ... SELECT ... always match fields by ordinal position?

My tests seem to confirm that INSERT INTO a (x, y) SELECT y, x FROM b maps b.y to …

sql sql-server tsql insert-into