Hear us Roar
Article:
 |
|
What I Hate About Your Programming Language
|
| Subject: |
|
Re: What I Hate About SQL |
| Date: |
|
2005-12-29 09:53:44 |
| From: |
|
ababiec
|
Response to: Re: What I Hate About SQL
|
|
Don't forget you can also use a subquery instead of a values list, so I'm not sure how your example address that scenario...
INSERT INTO <table> (<columns>) SELECT <columns> FROM <tables> WHERE <conditionals>
And INSERTs don't require a columns list if the values match the column order of the table.
Never mind examples such as...
INSERT ALL
WHEN order_total < 1000000 THEN
INTO small_orders
WHEN order_total > 1000000 AND order_total < 2000000 THEN
INTO medium_orders
WHEN order_total > 2000000 THEN
INTO large_orders
SELECT order_id, order_total, sales_rep_id, customer_id
FROM orders;
|
|
| |
