Q&A
| Q1: | Does SQL have a statement for file import/export operations? |
| A1: | No. Import and export are implementation-specific operations. In other words, the ANSI committee allows individual manufacturers to create whatever features or enhancements they feel are necessary. |
| Q2: | Can I copy data from a table into itself using the INSERT command? I would like to make duplicate copies of all the existing records and change the value of one field. |
| A2: | No. You cannot insert data into the same table that you selected from. However, you can select the original data into a temporary table, modify the data in this temporary table, and then select back into the original table. (True temporary tables are discussed on Bonus Day 6.) Make sure that you watch out for ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
