mysql语言.docxVIP

mysql语言：添加表中的字段项：例1ALTER TABLE`yz1` ADD `ximing` VARCHAR( 10 ) CHARACTER SET big5 COLLATE big5_chinese_ci NULL AFTER `xuehao` ;ALTER : ?改变；更改. TABLE表格···········AFTER在怎么之后。注意：``这不是单引号，是用的键盘上右上方的健上的符号。删除表中的字段ALTER TABLE`yz1` DROP`zhushi`DROP’; .放弃，停止DROP TABLE `yz1`例1CREATE TABLE `xs`.`yz1`(`id` INT( 10 ) NOT NULL ,`xuhao` INT( 10 ) NULL ,`ximing` VARCHAR( 10 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL ,`nannv` VARCHAR( 2 ) CHARACTER SET big5 COLLATE big5_chinese_ci NULL ,`beizhu` TEXT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL ,`shijian` DATE NULL ,PRIMARY KEY (`id`)) ENGINE