A.drop database數(shù)據(jù)庫名;刪除數(shù)據(jù)庫 B.delete from表名;刪除表中所有記錄條 C.delete from表名where字段名=值;刪除符合條件的記錄條 D.drop table表名;刪除表
A.set password for root@'localhost'=password('123'); B.update mysql.user set password=password('123') where user='root' and host='localhost'; C.select password for root@'localhost'=password('123'); D.create user root@'localhost' identified by'123';
A.錯(cuò)誤日志:記錄啟動、運(yùn)行或停止mysqld時(shí)出現(xiàn)的問題 B.二進(jìn)制日志:該日志文件會以二進(jìn)制形式記錄數(shù)據(jù)庫的各種操作,但是不記錄查詢語句 C.查詢?nèi)罩荆悍譃橥ㄓ貌樵內(nèi)罩竞吐樵內(nèi)罩?br /> D.可用mysqlbinlog命令查看二進(jìn)制日志