As Mr. Priebe pointed out, SQL stands for Structured Query Language. It is a type of code used by programs to communicate with a relational database server. SQL is not a product of a particular company; common servers include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
In general, you can think of a SQL database to be similar to a giant spreadsheet. A database can contain one or more tables, each of which contain fields and records. A table can be thought of as similar to a spreadsheet, a field similar to a column, and a record is similar to a row in a spreadsheet application.
However, unlike a spreadsheet, a database can be accessed by more than one person (or web site visitor) at a time. There are a few sources you may wish to review for more information, including:
Suppose you have a simple database, called Directory, that includes three fields:
Name
Phone
City
A simple SQL query to list every record in the database would be:
SELECT * FROM Directory;
However, you can do interesting things such as only return results from a particular city with:
SELECT Name, Phone FROM Directory WHERE City LIKE 'Atlanta';
Clearly SQL can be used for much more interesting things than the above simple examples. I hope this helps.
MySQL is one of the most popularly used open source databases, and it's popular coz' it's free (of course if you've extensive requirements, it may no longer remain free). I guess too many people have already given the definition of SQL so i need not do it
Grab the latest tech news and SEO updates on SeoEncyclopedia.com
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.
timjpriebe posted this at 12:39 — 17th October 2006.
He has: 2,667 posts
Joined: Dec 2004
Structured Query Language.
But that's probably way less info than you were looking for. You might try Wikipedia's page on the subject:
http://en.wikipedia.org/wiki/Sql
Plenty of links in there to related subjects as well.
Tim
http://www.tandswebdesign.com
FrankR posted this at 13:41 — 25th October 2006.
He has: 45 posts
Joined: Oct 2006
As Mr. Priebe pointed out, SQL stands for Structured Query Language. It is a type of code used by programs to communicate with a relational database server. SQL is not a product of a particular company; common servers include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
In general, you can think of a SQL database to be similar to a giant spreadsheet. A database can contain one or more tables, each of which contain fields and records. A table can be thought of as similar to a spreadsheet, a field similar to a column, and a record is similar to a row in a spreadsheet application.
However, unlike a spreadsheet, a database can be accessed by more than one person (or web site visitor) at a time. There are a few sources you may wish to review for more information, including:
Suppose you have a simple database, called Directory, that includes three fields:
A simple SQL query to list every record in the database would be:
SELECT * FROM Directory;
However, you can do interesting things such as only return results from a particular city with:
SELECT Name, Phone FROM Directory WHERE City LIKE 'Atlanta';
Clearly SQL can be used for much more interesting things than the above simple examples. I hope this helps.
Best regards,
Frank R.
Author of SQL Converter for Excel, which is an Excel add-in for converting data to MySQL.
omthoke posted this at 12:12 — 12th October 2011.
They have: 58 posts
Joined: Dec 2010
MySQL is one of the most popularly used open source databases, and it's popular coz' it's free (of course if you've extensive requirements, it may no longer remain free). I guess too many people have already given the definition of SQL so i need not do it
Consult the best indian seo company to boost your SERP rankings.
Grab the latest tech news and SEO updates on SeoEncyclopedia.com
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.