Download presentation
Presentation is loading. Please wait.
1
学习目标 www.quzixueba.com去自学吧系统教程之Mysql小白入门教程 1、Mysql Workbench更新数据
2、Update语法介绍 3、课后练习
2
上节课练习 添加几个学习的成绩信息
3
Mysql Workbench更新数据 更新几个学生的信息
UPDATE `school`.`students` SET `age`='12' WHERE `id`='1'; UPDATE `school`.`students` SET `age`='12', `grade`='2', `phone`=' ' WHERE `id`='2'; update students set age='11' where `name`='张三' update students set age='14',phone=' ' where `name`='赵七'
4
Update语法介绍 UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [ORDER BY ...] [LIMIT row_count] update 4个关键字 update tablename set where
![Update语法介绍 UPDATE [LOW_PRIORITY] [IGNORE] tbl_name](http://slidesplayer.com/slide/16575877/96/images/4/Update%E8%AF%AD%E6%B3%95%E4%BB%8B%E7%BB%8D+UPDATE+%5BLOW_PRIORITY%5D+%5BIGNORE%5D+tbl_name.jpg "SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [ORDER BY ...] [LIMIT row_count] update 4个关键字 update tablename set where.")
5
课后练习 在成绩表中，把语文成绩小于59分的加上1分
6
谢谢观看 PPT下载: 自学QQ群:
Similar presentations
