User Profile

gurumoorthi · Jan 11 '14, 05:58 AM

Delete:
delete only rows and space allocated by mysql
data can be roll backed again
it can be used with WHERE clause
Syntax:

Code:

DELETE TABLE table_name (for delete whole table)
DELETE TABLE table_name WHERE column_name=condition (for delete particular row)

Truncate:
delete rows and space allocated by mysql
data cannot be roll backed again
it cann't be used with WHERE clause...

gurumoorthi · Jan 10 '14, 10:09 AM

your html link:

Code:

<a href="www.example.com/item/harddisk">Hard disk</a>

Your .htaccess

Code:

RewriteRule ^item/(.*)$ products.php?name=$1

Your products.php

Code:

$name=$_GET['name']

gurumoorthi · Jan 10 '14, 10:07 AM

your html link:

Code:

<a href="www.example.com/item/harddisk">Hard disk</a>

Your .htaccess

Code:

RewriteRule ^item/(.*)$ products.php?name=$1

Your products.php

Code:

$name=$_GET['name']

Profile Sidebar