MySQL零距离接触第一章_1

CREATE DATABASE t1;
SHOW DATABASES;
ALTER DATABASE t1 CHARACTER SET = _;
DROP DATABASE t1;
mysql UPDATE PASSWORD FOR 'root'@'password'=PASSWORD;
SELECT VERSION();
SELECT USER();
SELECT NOW();
prompt \u@\h \d>
mysql -v -uroot -proot -P3306 -h127.0.0.1;
exit; quit; \q; ctrl+C;
CREATE DATABASE IF NOT EXISTS t1;
SHOW WARMINGS;
SHOW CREATE DATABASE t1;
CREATE DATABASE t2 CHARACTER SET gbk;
ALTER DATABASE t2 CHARACTER SET =utf8;
DROP DATABASE IF EXISTS;