把生日为19990101之前的学生姓名改为张三:
mysql:update student set name = '张三' where DATE(birthday) <DATE(19990101);
oracle:update student set name = '张三' where to_date(birthday,'yyyymmdd') < to_date(19990101,'yyyymmdd');
把生日为19990101之前的学生姓名改为张三:
mysql:update student set name = '张三' where DATE(birthday) <DATE(19990101);
oracle:update student set name = '张三' where to_date(birthday,'yyyymmdd') < to_date(19990101,'yyyymmdd');