醉墨涵湫的博客

命令：1：MySQL 设置root密码：mysqladmin -u root  password "1234"2：MySQL 修改root密码：mysqladmin -u root password oldpass "newpassword"3：列出MySQL所有的字符集：SHOW CHARACTER SET;4：当前MySQL字符集设置：SHOW VARIABLE

INSERT INTO sstud(sno,sname,sage,saddress,ssex) VALUES(‘1013’,’Big’,25,’自己人’,’男’); DELETE FROM sstud WHERE sno=’1013’; UPDATE sstud SET saddress=’中国北京’ WHERE sno=’1013’; SELECT * FROM sstud ;