I have my own sql search engine that I have been playing with. I would like to know if there is any generalized sites out there that will help me learn sql commands?


Thanks!

eautocad

mysql.com ?

google.com?

Actually, this site is pretty good.... http://www.w3schools.com/sql/default.asp

http://msdn2.microsoft.com/en-us/sqlserver/default.aspx


SQL really isn't a search engine tho. SQL = Structured (English Language) Query Language. It's a data manipulation and projection engine. For one thing, probably the main thing, it can only run queries against data that's been loaded into the database. Google has maybe the world's biggest database, but they also have in house software called a GoogleBot to collect data from the web and stuff it into their database. Without that, you can run a query but will only get results for what's already been loaded.

That said, most of SQL falls under four command types

SELECT - Gets data stored in the database and projects it in ways it's not stored, if you ask for that
UPDATE - Changes data in your database
INSERT - Adds new data
DELETE - Removes data

http://sqlzoo.net/

....???