MySQL數(shù)據(jù)庫系統(tǒng)及應(yīng)用章節(jié)練習(xí)(2020.06.09)

A.SELECT*FROM sh_goods WHERE 0；
B.SELECT*FROM sh_goods GROUP BY category_id WHERE price>5；
C.SELECT*FROM sh_goods LIMIT 3 ORDER BY price；
D.以上選項都不正確

A.查看數(shù)據(jù)庫用show關(guān)鍵字
B.查看一張表用show關(guān)鍵字
C.查看表中的一個字段用desc關(guān)鍵字
D.查看表中的數(shù)據(jù)用query關(guān)鍵字

A.user
B.db
C.tables_priv
D.columns_priv

A.use xscj
B.use xs
C.rename table xs to xs1
D.rename database xscj to xscj1