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′));
Mysql PHP Sample PHP Mysql search program Sample Programs

Search and Retrieve Data from MySQL DB Using PHP

viveik

Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:

techfolks mysql tutorials
Mysql Tips&Tricks

How to Get MySql Query Result as an Email

viveik

If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]