{"id":129,"title":"show\/alter\/drop\u6570\u636e\u5e93","good":0,"bad":0,"hit":1820,"created_at":"2014-12-19 16:57:33","content":"<p>\u67e5\u8be2\u5df2\u6709\u7684\u6570\u636e\u5e93\u540d\u5b57<\/p><p>show databases;<\/p><p>show databases likes;<\/p><p>like \u5173\u952e\u5b57\u7528\u4e8e\u8fc7\u6ee4\u591a\u4e2a\u6570\u636e\u5e93\uff01<\/p><p>\u53ef\u4ee5\u4f7f\u7528\u901a\u914d\u7b26\uff08\u901a\u7528\u5339\u914d\u7b26\uff0c\u53ef\u4ee5\u5339\u914d\u591a\u4e2a\u5b57\u7b26\uff09<\/p><p>% \u5339\u914d\u4efb\u610f\u5b57\u7b26\u7684\u4efb\u610f\u6b21\u6570\uff08\u5305\u62ec0\u6b21\uff09\u7684\u7ec4\u5408\uff01<\/p><p>_ \u5339\u914d\u4efb\u610f\u5b57\u7b26\u7684\u4e00\u6b21\uff01<\/p><p>\u6ce8\u610f\u5982\u9700\u8981\u5339\u914d\u7279\u5b9a\u7684\u901a\u914d\u7b26\uff0c\u5219\u9700\u8981\u5bf9\u901a\u914d\u7b26\u8f6c\u4e49\uff0c\u4f7f\u7528\u53cd\u659c\u6760\u5b8c\u6210\u8f6c\u4e49\uff01<\/p><p>\u5982\uff1a<\/p><p>show databases `test_1`;<\/p><p><br\/><\/p><p>\u67e5\u770b\u67d0\u4e2a\u6570\u636e\u5e93\u7684\u5b9a\u4e49<\/p><p>showcreate database \u5e93\u540d\uff1b<\/p><p>\u53ef\u4ee5\u663e\u793a\u5efa\u5e93sql\u8bed\u53e5\uff0c\u5b57\u7b26\u96c6\u7b49<img src=\"https:\/\/api.hu-rong.com\/uploads\/editor\/php\/upload1\/20141219\/14189795027362.jpg\"\/><\/p><p><br\/><\/p><p><br\/><\/p><p>alter database \u6570\u636e\u5e93\u540d<\/p><p>\u53ea\u80fd\u4fee\u6539\u6570\u636e\u5e93\u9009\u9879<\/p><p>\u5982\uff1aalter databas test charset gbk;<\/p><p><br\/><\/p><p>\u5220\u9664\u6570\u636e\u5e93<\/p><p>drop database \u540d\u5b57<\/p>"}