Different between primary key and unique key? 

One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.
 
Unique key allow us NULL values where Primary key not allow us null values. 
 
 

Most Popular

Customize wordpress register form wp_register()

<div>             <h3>Register for this site!</h3>             <p>Sign up now for the good stuff.</p>             <form method="post" action="<?php echo site_url('wp-login.php?action=register', 'login_post') ?>" class="wp-user-form">                 <div class="username">                     <label for="user_login"><?php _e('Username'); ?>: </label>                     <input type="text" name="user_login" value="<?php echo esc_attr(stripslashes($user_login)); ?>" size="20" id="user_login" tabindex="101" />             ...
Keep reading

Tutorials Programme

Image
Loops Tutorials     Example While Loop #include <stdio.h> int main() { int count; count = 0; while (count < 4) { printf("The value of count is %d\n", count); count += 1; } return 0; } /* Result The value of count is 0 The value of count is 1 The value of count is 2 The value of count is 3 */
Keep reading

Database backup using ssh linux

Here we are creating gz backup files using shell programming step1 . create backup file backup.sh step2. set cron job in control panel. #!/bin/bash ### MySQL Server Login Info ### MUSER="user" MPASS="Password" MHOST="localhost" MYSQL="$(which mysql)" MYSQLDUMP="$(which mysqldump)" BAK="backup/mysql" GZIP="$(which gzip)" NOW=$(date +"%d-%m-%Y") [ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* FILE=$BAK/"databasename".gz $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS "databasename" | $GZIP -9 > $FILE
Keep reading