Most of you know im not very smart in this webmaster stuff, but what is sql? I have no clue
JeffDevilThreads.com
Jeff
www.DevilThreads.com Funny t shirts for the masses
DevilThreads blog comedy and discounts from devilthreads.com
Most of you know im not very smart in this webmaster stuff, but what is sql? I have no clue
JeffDevilThreads.com
Jeff
www.DevilThreads.com Funny t shirts for the masses
DevilThreads blog comedy and discounts from devilthreads.com
timjpriebe posted this at 12:39 — 17th October 2006.
He has: 2,666 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.