Database Related Tutorials - LearnPHP.org
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:
69
Entire rows can be deleted from a table using the delete clause.
May 6,
2008
Today Views:
5 Total Views:
65
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:
65
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:
3 Total Views:
72
Microsoft's SQL Server takes a little different approach to working with dates.
May 1,
2008
Today Views:
1 Total Views:
68
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:
59
This tutorial explains how to create database driven (dynamic) website with Dreamweaver CS3, PHP and MySQL.
April 29,
2008
Today Views:
1 Total Views:
116
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:
2 Total Views:
56
This tutorial explains the basics of setting up OpenBSD as a database server using MySQL/PostgreSQL and PHP.
April 28,
2008
Today Views:
2 Total Views:
57
In the 60's database software required the use of complex mainframe machines that were difficult to maintain and run. Information technologists worked around the clock monitoring, updated, and manually uncorrupting these machines.
April 25,
2008
Today Views:
2 Total Views:
59
