How to specify multiple alterations for a table?

You can specify multiple alterations for a table with a single ALTER TABLE statement. Just separate the actions by commas. For example:

ALTER TABLE `buyers` RENAME TO `shoppers`,
    MODIFY ID BIGINT UNSIGNED NOT NULL,
    ADD Salutation CHAR(30) NULL AFTER FirstName;