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
db size query Mysql Mysql database query query to get db size

How to Get Size of a Database in Mysql

viveik

To Get Data Base Size in MB  and Free Space in MBSELECT table_schema “dbName”,    sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”,    sum( data_free )/ 1024 / 1024 “Free Space in MB”FROM information_schema.TABLESGROUP BY table_schema ; To Get Size in GB: SELECT  sum(round(((data_length + index_length) / 1024 […]
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 […]
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