Download presentation
Presentation is loading. Please wait.
1
学习目标 www.quzixueba.com去自学吧系统教程之Mysql小白入门教程 1、使用Mysql Workbench修改表
2、alert table语法分析
2
使用Mysql Workbench修改表 看实例操作
3
alert table语法分析 ALTER [IGNORE] TABLE tbl_name
alter_specification [, alter_specification] ... 这里主要讲添加删除修改列 添加的关键字是add ALTER TABLE `students` ADD COLUMN `street1` VARCHAR(45) NULL AFTER `address`; 删除的关键字是drop ALTER TABLE `students` DROP COLUMN `street1`; 修改的关键字是change ALTER TABLE `students` CHANGE COLUMN `street1` `street1` VARCHAR(80) NULL DEFAULT NULL ;
![alert table语法分析 ALTER [IGNORE] TABLE tbl_name](http://slidesplayer.com/slide/17313922/100/images/3/alert+table%E8%AF%AD%E6%B3%95%E5%88%86%E6%9E%90+ALTER+%5BIGNORE%5D+TABLE+tbl_name.jpg "alter_specification [, alter_specification] ... 这里主要讲添加删除修改列. 添加的关键字是add. ALTER TABLE `students` ADD COLUMN `street1` VARCHAR(45) NULL AFTER `address`; 删除的关键字是drop. ALTER TABLE `students` DROP COLUMN `street1`; 修改的关键字是change. ALTER TABLE `students` CHANGE COLUMN `street1` `street1` VARCHAR(80) NULL DEFAULT NULL ;")
4
谢谢观看 PPT下载: 自学QQ群:
Similar presentations
