ALTER TABLE internal MODIFY COLUMN id INT(32) NOT NULL auto_increment PRIMARY KEY;
Related Articles
Decimal(5,3) in Mysql is always 99.999
The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
PHP Radio Button Example With Mysql DB
Simple PHP Radio button enable and disable textarea textbox example in php using Mysql
How to take Backup of MYSQL database sql file using MYSQLDUMP Command
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