Basic SQL and MySQL terms

Primary key

The primary key of a relational table uniquely identifies each record in the table. http://databases.about.com/cs/administration/g/primarykey.htm

Relationship

A relationship exists between two database tables when one table has a foreign key that references the primary key of another table. http://databases.about.com/od/specificproducts/g/relationship.htm

Query

SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. http://www.tizag.com/sqlTutorial/sqlqueries.php

SELECT

Selects data from one or more database tables and/or views. http://www.sqlcommands.net/sql+select/

SQL

Structured Query Language - a programming language designed for managing data in relational database management systems. http://en.wikipedia.org/wiki/Sql

Field

a space allocated for a particular item of information. http://www.webopedia.com/TERM/F/field.html

Table

a table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. http://en.wikipedia.org/wiki/Table_%28database%29

Record

are composed of fields. http://www.webopedia.com/TERM/R/record.html

ORDER BY

defines in what order to return a data set retrieved with a SQL SELECT statement. http://www.sqlcommands.net/sql+order+by/

INSERT

facilitates the process of inserting data into a SQL table. http://www.sqlcommands.net/sql+insert/

Timestamp

is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes. http://msdn.microsoft.com/en-us/library/aa260631%28v=SQL.80%29.aspx

DELETE

is used to delete data from a database table. http://www.sqlcommands.net/sql+delete/

mysql_connect

opens or reuses a connection to a MySQL server. http://us.php.net/manual/en/function.mysql-connect.php

JOIN

selects data from two or more tables tied together by matching table columns. http://www.sqlcommands.net/sql+join/

mysql_query

sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier. http://us.php.net/manual/en/function.mysql-query.php

UPDATE

serves to update data in database table. http://www.sqlcommands.net/sql+update/

mysql_select_db

sets the current active database on the server that's associated with the specified link identifier. Every subsequent call to mysql_query() will be made on the active database. http://us.php.net/mysql_select_db

WHERE

works in conjunction with other SQL clauses like SELECT, INSERT and UPDATE to specify a search condition for these statements. http://www.sqlcommands.net/sql+where/