Database Related Tutorials - LearnPHP.org
How to store images directly in the Sql database.
May 9,
2008
Today Views:
3 Total Views:
37
Chances are that at some point in the life of a web site you will need to be creating content on request. Fortunately (yeah, right...), I had to tackle this early in the development of our Metalloprotein Database site at TSRI.
May 8,
2008
Today Views:
6 Total Views:
47
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:
7 Total Views:
44
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:
7 Total Views:
50
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:
3 Total Views:
52
Entire rows can be deleted from a table using the delete clause.
May 6,
2008
Today Views:
4 Total Views:
48
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:
5 Total Views:
51
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:
4 Total Views:
61
Microsoft's SQL Server takes a little different approach to working with dates.
May 1,
2008
Today Views:
2 Total Views:
58
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:
4 Total Views:
52
