Difference between revisions of "Portable SQL"
From Linuxnetworks
(added "replacing records") |
(added "Generating IDs") |
||
| Line 11: | Line 11: | ||
## [[Portable SQL/Statements/Data manipulation|Data manipulation]] | ## [[Portable SQL/Statements/Data manipulation|Data manipulation]] | ||
## [[Portable SQL/Statements/Data retrieval|Data retrieval]] | ## [[Portable SQL/Statements/Data retrieval|Data retrieval]] | ||
| + | ## [[Portable SQL/Statements/Generating IDs|Generating IDs]] | ||
# SQL tips | # SQL tips | ||
## [[Portable SQL/Tips/Handling generated IDs|Handling generated IDs]] | ## [[Portable SQL/Tips/Handling generated IDs|Handling generated IDs]] | ||
## [[Portable SQL/Tips/Replacing records|Replacing records]] | ## [[Portable SQL/Tips/Replacing records|Replacing records]] | ||
Revision as of 22:17, 29 August 2007
The ANSI SQL standard exists for years but it's still difficult to write SQL statements which are portable across most database engine implementations. This guide tries to give you tips about what is possible keeping the most common database implementations in mind and where the limits of portable SQL for this engines are.
Feel free to add your own tips if you like ...
- Common tips
- SQL statements
- SQL tips
