mysql alter to table
- by user485783
Hi,
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. thanks in advace
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 ALTER TABLE customer
ADD last_active datetime NOT NULL
DEFAULT '0000-00-00 00:00:00' AFTER
date_added
