INSERT/UPDATE full row without specification

[Laffern]

While I can read a whole row of a database table with SELECT *, how it works with pushing data into Tables ?

Actually, I read row from an external server and want push it into my local database. Both databases, the server and mine have the same table schema already. Due to the number of columns (more than 100) it can be time-consuming reading each column.

Thanks, in advance.

 

[vongrunt]

Typically:

INSERT INTO <targettable>
SELECT *
FROM <sourcetable>
WHERE blah blah

... or if target table doesn't exist:

SELECT *
INTO <targettable>
FROM <sourcetable>
WHERE blah blah

This construct is also known as singleton SELECT.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)