[Home]
[Edit this page]
[Recent Changes]
[Special Pages]
[Help]
Sql
SQL is a popular query language used to work with databases. By running a query on a database we can extract, insert, update and delete data and more.
Note that SQL has many dialects, e.g. MySql, IBM DB2, Oracle, etc.
[Edit this page] [Page history] [What links here] [Discuss this topic] [Printer Friendly]
Sql
SQL
Short for 'Structured Query Language'.SQL is a popular query language used to work with databases. By running a query on a database we can extract, insert, update and delete data and more.
Note that SQL has many dialects, e.g. MySql, IBM DB2, Oracle, etc.
Glossary
Standard ANSI SQL Commands
- SELECT - To extract data and interrogate the database.
- INSERT INTO - To insert new records.
- UPDATE - To update an existing record.
- ?REPLACE INTO - To insert or update if exists.
- DELETE - To delete an exising record.
- CREATE TABLE - To create a table.
- DROP TABLE - To delete a table.
Related internal links
External links
- Good SQL Tutorial with Examples: http://beginner-sql-tutorial.com/
- Wikipedia: http://en.wikipedia.org/wiki/SQL
- SQL Tutorial and Programming Examples: http://www.1keydata.com/sql/sql.html
- SQL Tutorial: http://www.w3schools.com/sql/default.asp
- IBM DB2 Reference: http://www-306.ibm.com/software/data/db2/udb/support/manualsv7.html
- http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
[Edit this page] [Page history] [What links here] [Discuss this topic] [Printer Friendly]
