Mysql

alter table and make id as auto increment

ALTER TABLE internal MODIFY COLUMN id INT(32) NOT NULL auto_increment PRIMARY KEY;

Related Articles

techfolks mysql tutorials
Current Timezone of database Current Timezone of mysql Current Timezone of mysql database Current Timezone of mysql server Mysql mysql timezone query

How to Get the Current Timezone of Mysql Database

viveik

By running below query you can able to get the Current Timezone of the database server. select timediff(now(),convert_tz(now(),@@session.time_zone,’+00:00′));
Javascript Mysql PHP

PHP Radio Button Example With Mysql DB

viveik

Simple PHP Radio button enable and disable textarea textbox example in php using Mysql
Mysql

How to take Backup of MYSQL database sql file using MYSQLDUMP Command

viveik

For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql