Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 
MySQL
PHP With Forms PHP Tutorial
Introduction In the last part, I showed you how to use PHP to send e-mail messages using a script. In this part I will continue this and also show you how to use PHP and forms together to make your PHP scripts useful.

Posted : Sep/24/2009   By: pankaj    Category: MySQL    Total Views :76   Vote Up: 0   Vote Down: 0

Database Table Maintenance Statements in MySQL
MySQL provides a bunch of statements to allow you to maintain database table more efficiently. Those statements enable you to analyze, optimize, check, and repair the database table. Here you will learn them all together

Posted : Sep/24/2009    By: nikhil    Category: MySQL   Total Views :67   Vote Up: 0   Vote Down: 0

Deleting Data by Using SQL DELETE Statement
To remove a data row or all rows from a table you can use SQL DELETE statement. The syntax of SQL DELETE statement in MySQL is as follows: DELETE [LOW_PRIORITY] [QUICK] FROM table_name [WHERE conditions] [ORDER BY

Posted : Sep/24/2009   By: nikhil    Category: MySQL    Total Views :81   Vote Up: 1   Vote Down: 0

Updating Data by Using SQL UPDATE statement
SQL UPDATE statement is used to update existing data in a data table. It can be used to change values of single row, group of rows or even all rows in a table. In MySQL, the SQL UPDATE statement form is as follows: U

Posted : Sep/24/2009    By: nikhil    Category: MySQL   Total Views :82   Vote Up: 0   Vote Down: 0

Inserting Data into Table
In this tutorial, you will learn how to insert data into database tables by using SQL INSERT statement. INSERT Statement INSERT statement allows you to insert one or more rows to the table. In MySQL, the INSERT statem

Posted : Sep/24/2009   By: nikhil    Category: MySQL    Total Views :65   Vote Up: 0   Vote Down: 0

MySQL Aggregate Functions
In some cases, the information we need is not actually stored in the database but we can retrieve it by computing in some ways from stored data. For example, we have OrderDetails table to store order data, we don't know

Posted : Sep/24/2009    By: nikhil    Category: MySQL   Total Views :64   Vote Up: 0   Vote Down: 0

Learning Advanced Query
In the previous tutorial, you've learn how to retrieve data from one table by using SELECT statement. But in the real database programming task, you usually does not select data from just one table because of the normali

Posted : Sep/24/2009   By: nikhil    Category: MySQL    Total Views :66   Vote Up: 0   Vote Down: 0

SQL UNION in MySQL
SQL UNION allows you to combine two or more result sets from select statements into a single result set. The usage of using SQL UNION is as follows: SELECT statement UNION [DISTINCT | ALL] SELECT statement UNION [DI

Posted : Sep/24/2009    By: nikhil    Category: MySQL   Total Views :67   Vote Up: 0   Vote Down: 0

SQL LIKE Operator in MySQL
SQL LIKE allows you to perform pattern matching in your characters column in a database table. SQL LIKE is often used with SELECT statement in WHERE clause. MySQL provides you two wildcard characters for use with LIKE, th

Posted : Sep/24/2009   By: nikhil    Category: MySQL    Total Views :75   Vote Up: 0   Vote Down: 0

Retrieving Data in a Range with SQL BETWEEN
SQL BETWEEN allows you to retrieve values within a specific range. The usage of SQL BETWEEN is as follows: SELECT column_list FROM table_name WHERE column_1 BETWEEN lower_range AND upper_range

Posted : Sep/24/2009    By: nikhil    Category: MySQL   Total Views :66   Vote Up: 0   Vote Down: 0

« Previous12Next »
 
 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge