修改student表的字符集

ALTER TABLE student CONVERT TO CHARACTER SET “utf8”;

修改数据 表示条件需要用where

UPDATE student SET gender = ‘女’;
UPDATE student SET gender = ‘男’ WHERE NAME = ‘王五’;
UPDATE student SET gender = ‘秘’,age = 1000 WHERE id = 101;