《MySQL數(shù)據(jù)庫》課件-任務(wù)一 網(wǎng)站數(shù)據(jù)庫的創(chuàng)建、修改、查看與刪除

構(gòu)建網(wǎng)站數(shù)據(jù)庫網(wǎng)站數(shù)據(jù)庫的創(chuàng)建、修改、查看和刪除電子商務(wù)網(wǎng)站數(shù)據(jù)庫的設(shè)計(jì)1創(chuàng)建淘淘網(wǎng)數(shù)據(jù)庫2在淘淘網(wǎng)數(shù)據(jù)庫中創(chuàng)建核心數(shù)據(jù)表（買家表，賣家表、商品表、訂單表、購物車表）3在核心數(shù)據(jù)表中添加數(shù)據(jù)、修改數(shù)據(jù)、刪除數(shù)據(jù)和查看數(shù)據(jù)一、創(chuàng)建數(shù)據(jù)庫建庫語句createdatabase數(shù)據(jù)庫名字;創(chuàng)建數(shù)據(jù)庫淘淘網(wǎng)語句語句createdatabase淘淘網(wǎng);一、創(chuàng)建數(shù)據(jù)庫數(shù)據(jù)庫名字的命名規(guī)則由英文字母、數(shù)字、下劃線組合或者文字都是可以的，數(shù)字不能獨(dú)立作為數(shù)據(jù)庫名字。注意語句必須以英文分號表示結(jié)束都是合法的數(shù)據(jù)庫名字a22a2__amysql>createdatabase淘淘網(wǎng);QueryOK,1rowaffected(0.00sec)一、創(chuàng)建數(shù)據(jù)庫二、查看數(shù)據(jù)庫查看所有數(shù)據(jù)庫showdatabases;mysql>showdatabases;+-------------------------------------------+|Database|+-------------------------------------------+|information_schema||淘淘網(wǎng)||Mysql||performance_schma||test|+--------------------------------------------+5rowsinset(0.00sec)Showcreatedatabase淘淘網(wǎng);mysql>showcreatedatabases淘淘網(wǎng);+-----------------------------------------------------------+|Database|CreateDatabase|+-----------------------------------------------------------+|淘淘網(wǎng)|CREATEDATABASE‘淘淘網(wǎng)’/*！40100DEFAULTCHARACTERSETgbk*/|+-----------------------------------------------------------+1rowsinset(0.00sec)1.查看指定數(shù)據(jù)庫的創(chuàng)建信息二、查看數(shù)據(jù)庫兩種字符集編碼utf8和gbk區(qū)別utf8是國際碼，一個(gè)漢字占3個(gè)字節(jié)。gbk是中國碼，一個(gè)漢字占2個(gè)字節(jié)。Showcreatedatabase淘淘網(wǎng);1.查看指定數(shù)據(jù)庫的創(chuàng)建信息二、查看數(shù)據(jù)庫三、打開數(shù)據(jù)庫打開某個(gè)數(shù)據(jù)庫Use數(shù)據(jù)庫名字;mysql>USE淘淘網(wǎng)；Databasechanged四、修改數(shù)據(jù)庫增創(chuàng)建數(shù)據(jù)庫刪刪除數(shù)據(jù)庫改修改數(shù)據(jù)庫查查看數(shù)據(jù)庫四、修改數(shù)據(jù)庫修改數(shù)據(jù)庫的字符集編碼由gbk改為utf8mysql>showcreatedatabases淘淘網(wǎng);+-----------------------------------------------------------+|Database|CreateDatabase|+-----------------------------------------------------------+|淘淘網(wǎng)|CREATEDATABASE‘淘淘網(wǎng)’/*！40100DEFAULTCHARACTERSETgbk*/|+-----------------------------------------------------------+1rowsinset(0.00sec)四、修改數(shù)據(jù)庫語句alterdatabase淘淘網(wǎng)charactersetutf8;mysql>alterdatabase淘淘網(wǎng)charactersetutf8;QueryOK,1rowaffected(0.00sec)mysql>showcreatedatabase淘淘網(wǎng)；+-----------------------------------------------------------+|Database|CreateDatabase|+-----------------------------------------------------------+|淘淘網(wǎng)|CREATEDATABASE‘淘淘網(wǎng)’/*！40100DEFAULTCHARACTERSETutf-8*/|+-----------------------------------------------------------+1rowsinset(0.00sec)五、刪除數(shù)據(jù)庫語句dropdatabase數(shù)據(jù)