mysql alter to table
I drop the mysql alter code below to database via phpmyadmin one by one, it it work fine, is there anyone could help me how to drop it all together at once? Or do you know the the samples of PHP code that may execute it? Just let me know please.
ALTER TABLE `user` ADD `title`
varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `user_id`
ALTER TABLE `customer` ADD `title`
varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `customer_id`;
ALTER TABLE `customer` ADD `date_birtdate` datetime NOT NULL
DEFAULT '0000-00-00 00:00:00' AFTER `lastname`;
ALTER TABLE `customer` ADD `security_question` varchar(96) COLLATE utf8_bin
NOT NULL DEFAULT '' AFTER `fax`;
ALTER TABLE `customer` ADD `security_answer` varchar(96) COLLATE utf8_bin
NOT NULL DEFAULT '' AFTER `fax`;
ALTER TABLE `customer` ADD `pin_number` text COLLATE utf8_bin AFTER `password`;
ALTER TABLE `customer` ADD `notes` text COLLATE utf8_bin AFTER `bank_number`;
ALT开发者_如何学运维ER TABLE `customer` ADD `last_active` datetime NOT NULL
DEFAULT '0000-00-00 00:00:00' AFTER `date_added`;
add ;
at end of each query ;-) then u can put them together as one block. with php you can't do it that easy way.
精彩评论