How do you add a field to a table (MySQL) in ColdFusion?

I want to create a cold fusion(9) script that adds a field ('pageTitle') to a开发者_如何学运维 MySQL table ('pb_page'). Can someone enlighten me and teach me how this is done? Thx!

<cfquery name='alterdb' datasource='mydsn'>
alter table `mydatabase`.`mytable` add column `myfield` varchar(255) NULL after `lastfield`;
</cfquery>