SQL

nike_guy_man's picture

They have: 840 posts

Joined: Sep 2000

What is SQL and how can it help me with my pages?
thanks
i'm still learning Smiling

Vincent Puglia's picture

They have: 634 posts

Joined: Dec 1999

Hi nike_guy_man,

SQL stands for Structured Query Language, a language developed by Codd & Date in the woebegotten days of mainframes. Today it is used as the standard querying language for relational DBMSes (database management systems). Its first popular incarnation was IBM's DB2. Since then, it is incorporated with some proprietary code in such dbmses as: mySQL, SQL Server, Oracle, Access, etc.. The language itself is simple to learn, consisting of few commands (select, update, delete, etc).

That being said: SQL can enhance any site that has heavy demands on data that can be stored in a database -- e-commerce, forums (this site uses mySQL & php), etc.
To use SQL, you need:
1) a relational DBMS;
2) server access
3) an intermediary language (php/asp/etc)

Hope this answers your question,

Vinny

Where the world once stood
the blades of grass cut me still

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.