Related Articles
10 Mistakes Which PHP MySQL Developers Make
1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re most likely to encounter MyISAM and InnoDB. MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions, which are essential for […]
Difference between UTF-8 Vs ISO-8859-1
UTF-8 is a multibyte encoding that can represent any Unicode character. ISO 8859-1 is a single-byte encoding that can represent the first 256 Unicode characters. Both encode ASCII exactly the same way. ISO-8859-1 vs UTF-8 ISO-8859-1 is a legacy standard from back in the 1980s. It can only represent 256 characters so only suitable for […]
How to Add Column to Mysql Table and Auto Increment with Primary Key
Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY auto_increment; ALTER TABLE users ADD id […]