Sometimes we might need to add multiple column to a table in MySQL, sample below work perfectly
ALTER TABLE pp_batch_detail
ADD `user_id` int(10) unsigned default NULL,
ADD `user_name` varchar(255) default NULL,
ADD `date_request` datetime default NULL;
No comments:
Post a Comment