常用到的sql语句

ALTER TABLE `news` ADD `adddate` VARCHAR( 50
) NOT NULL ;

ALTER TABLE `news` CHANGE `title` `title` VARCHAR( 250 ) NOT NULL;

CREATE TABLE `news` (
 `id` int(11) NOT NULL auto_increment,
 `type` varchar(10) NOT NULL default ‘’,
 `typeid` tinyint(2) NOT NULL default ‘0′,
 `content` tinytext NOT NULL,
 `title` varchar(250) NOT NULL default ‘’,
 `adddate` varchar(50) NOT NULL default ‘’,
 PRIMARY KEY  (`id`),
 KEY `typeid` (`typeid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;