INSERT INTO SELECT Statement in sql
The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table. Any existing rows in the target table are unaffected. SQL INSERT Syntax The syntax for the SQL INSERT statement when inserting a record using the another table. INSERT INTO table (column1, column2, ... ) SELECT expression1, expression2, ... FROM source_table WHERE conditions; SQL INSERT INTO SELECT Examples Copy only a few columns from another table...... INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'Newark';
মন্তব্যসমূহ
একটি মন্তব্য পোস্ট করুন