Tutorials by tizag.com
However, what would you do if you wanted to check if your $employee variable was the company owner Bob, the Vice President Ms. Tanner, or a regular employee? To check for these different conditions you would need the elseif statement.
May 9,
2008
Today Views:
1 Total Views:
195
The union clause places two serarate queries together forming one table. A union works best when using two tables with similar columns because each cloumn must have the same data type.
May 8,
2008
Today Views:
1 Total Views:
212
MySQL offers a very limited support for subqueries, however Oracle and DB2 fully support them. Subqueries are Select queries placed within an existing SQL statement. They may exist in any of the following types of SQL statements.
May 7,
2008
Today Views:
3 Total Views:
265
Queries are the backbone of SQL. Query is a loose term that refers to a widely available set of SQL commands called clauses.
May 6,
2008
Today Views:
1 Total Views:
249
Entire rows can be deleted from a table using the delete clause.
May 6,
2008
Today Views:
1 Total Views:
234
The insert clause has one function; to insert data into a table. Insert populates each table column with a value. Rows are inserted one right after another into the corresponding column.
May 5,
2008
Today Views:
1 Total Views:
235
SQL commands can be categorized into three distinct groups. Each type of command plays an essential role while working with your database.
May 2,
2008
Today Views:
1 Total Views:
270
Microsoft's SQL Server takes a little different approach to working with dates.
May 1,
2008
Today Views:
7 Total Views:
282
Unfortunately, every SQL platform has its own version of date functions, the few listed work in DB2, Oracle, and MySQL.
April 30,
2008
Today Views:
1 Total Views:
213
In SQL case works with either the select or update clauses. It provides when-then-else functionality (WHEN this_happens THEN do_this) also known as conditional statements.
April 29,
2008
Today Views:
5 Total Views:
600
