Changing column datatype in mysql
From time to time I have been changing the column datatype for different reasons. Majorly being for performance and efficiency and some other time based on how the mysql engines would be strong on some types vs the other
here is the simple command i use for changing the column datatype
alter table table_name modify column column_name datatypegoeshere eg. ALTER TABLE members MODIFY COLUMN date_created TIMESTAMP;
Access MySQL from Host being on Vagrant
Setting new Vagrant machine for PHP-Mysql development
error duplicate entry for key when creating new unique key mysql
Using mysql keyword as column in Doctrine Entity – PHP
Connecting to Vagrant [PuPHPet] MySql from host