PDA

View Full Version : Sql


JohnCWms27
06.03.03, 01:13 PM
My question is this:

Are there more than one types of SQL? I know there are different versions, and I know there is postgrSQL (or something like that) as well as mySQL, but whats the difference if any?

if someone asks you if you know SQL, are they referring to mySQL? and does SQL have any functionality in projects involving Visual Basic, etc?

Munkeh
06.03.03, 01:36 PM
SQL is an ANSI standard language for accessing databases. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase,mysql,postgresql etc.
its the servers that differ and each have strong and low points.

JohnCWms27
06.03.03, 10:37 PM
that answered my question perfectly - thanks. you wouldnt happen to know of websites that are good at explaining the difference in how these servers use SQL, would you?

harmonic
06.04.03, 06:32 AM
it would be best to read their manuals...ie MySQL at

http://www.mysql.com

Postgre at:

http://www.postgresql.org/docs/

etc... just search for their websites.