SQL: SELECT INTO flash cards

Set: SQL: SELECT INTO

Familiarize		Learn		Test
Play Scatter			Play Space Race

Term	Definition
SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename	selects data from one table and inserts it into a different table; often used from backups; maybe used with JOIN or WHERE
SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_tablename	selects data from certain columns of a table and inserts it into a different table; often used from backups; maybe used with JOIN or WHERE

No Messages

Report as inappropriate