Geek Answers Handbook

Causes of SQL Differences

Why are SQL distributions so non-standard despite the ANSI standard that exists for SQL? Are there really many significant differences in how SQL databases work, or are they just the two databases I worked with: MS-SQL and PostgreSQL? Why do these differences arise?

+5
source share
5 answers

ANSI . , . , , . SQLite , MySQL AUTO INCREMENT, PostgreSQL .. , OSS! Oracle, Microsoft IBM .

+8

-, , , , . , , , , SQL. , HTML, . , SQL . , -, .

-, , , , . , Oracle, MS SQL Server MySQL, , . Oracle MySQL, , , 100% Oracle , . , Oracle , , MySQL . IBM, Microsoft, PostgreSQL , . , . (, "" ).

-, , SQL -. , Oracle , . , . . , ( , ), . , SQL ontop . .

+5
: , , , , , upsert .. , , , ; , SQL .

Neall: , SQL . , CREATE ASSERTION, , , .

, (, SQL) : , /, , , .

+4

, , , 1800 . , SQL . , , . Microsoft SQL Server , , Ingres - , 70- . Postgres 80- Ingres. Oracle , , MySQL.

, .

+2

More articles:


All Articles