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
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:
Mysql PHP

Best way to loop through a PHP mysql Resultset

viveik

If you want to loop throuh the mysql result set twice then use below way. $result = mysql_query(“SELECT * FROM my_table”);while($row = mysql_fetch_assoc($result)) {// inside the loop} The problem is, if you want to loop through the same result set again, you will get an error because the internal pointer is currently at the end […]

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′));