l10 03老男孩linux运维实战培训lamp系列mysql常用基础命令操作讲解

：：： （适合全体朋友老男孩Linux培训VIP初级群： ，违者直接取消VIP学员资格。请 ：[root@oldboy[root@oldboy~]#/etc/init.d/mysqldStartingMySQL.[OK[root@oldboy~]#netstat-lnt|grep00[root@oldboy~]#/etc/init.d/mysqldShuttingShuttingdownMySQL[OK killallmysqldkillall-9mysqldmysqld:noprocesskilled: ③mysql-uroot-p<==这里标 令行登陆命令④mysql-uroot-p’oldboy123’<== 。[root@oldboy[root@oldboy~]#mysql-uroot-p-S[root@oldboy[root@oldboy~]#mysql-uroot-EnteretotheMySQLmonitor.Commandsendwith;orYourMySQLconnectionidisServerversion:5.1.62SourceCopyright(c)2000,2011,Oracleand/oritsaffiliates.All.OracleisaregisteredtrademarkofOracleCorporationand/oraffiliates.OthernamesmaybetrademarksoftheirType'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>mysql> /Fordeveloperinformation,includingtheMySQLReferenceManual,visit:/TobuyMySQLEnterprisesupport,training,orotherproducts,visit:/ListofallMySQLNotethatalltextcommandsmustbefirstonlineandendwith?(\?)Synonymfor(\c)Clearthecurrentinput(\G)Sendcommandtomysqlserver, yresult(\q)Exitmysql.Sameas(\g)Sendcommandtomysql(\h) ythis(\P)SetPAGER[to_pager].Printthequeryresultsvia(\p)Printcurrent (\R)Changeyourmysql(\q)Quit (\s)Getstatusinformationfromtheserver. (\!)Executeasystems Forserversidehelp,type'helpcontents'mysql>helpshow;Name:SHOWhasmanyformsthatprovideinformationaboutdatabases,tables,columns,orstatusinformationabouttheserver.Thissectiondescribesthosefollowing:SHOWSHOW{BINARY|MASTER}SHOWBINLOGEVENTS[IN'log_name'][FROMpos][LIMIT[offset,]row_count]SHOWCHARACTERSET[like_or_where]SHOWCOLLATIONSHOW[FULL]COLUMNSFROMtbl_name[FROMdb_name][like_or_where]SHOWCONTRIBUTORSSHOWCREATEDATABASESHOWCREATEEVENTevent_nameSHOWCREATEFUNCTIONfunc_nameSHOWCREATEPROCEDUREproc_nameSHOWCREATETABLEtbl_nameSHOWCREATEVIEWview_nameSHOWDATABASESSHOWENGINEengine_name{STATUS|MUTEX}SHOW[STORAGE]ENGINESSHOWEVENTSSHOWFUNCTIONCODESHOWGRANTSFORusermysql>helpgrant;Name:'GRANT'[,priv_type[(column_list)]]...ON[object_type]priv_levelTOuser_specification[,user_specification]...[REQUIRE{NONE|ssl_option[[AND]ssl_option]...}][WITHwith_option...]||*||||||user[IDENTIFIEDBY[PASSWORD]'password']||CIPHER|ISSUERGRANT|MAX_QUERIES_PER_HOUR|MAX_UPDATES_PER_HOUR|MAX_USER_CONNECTIONScountCREATEUSER'jeffrey'@'localhost'IDENTIFIEDBYGRANTALLONdb1.*TOGRANTSELECTONTOGRANTUSAGEON*.*TO'jeffrey'@'localhost'WITHMAX_QUERIES_PER_HOURURL: mysql>quitmysql>quit(\q)Quit(\q)Exitmysql.Sameasmysqladminmysqladmin-urootpasswordmysqladminmysqladmin-uroot-p'oldboy456'passwordmysql>mysql>UPDATEmysql.userSETpassword=PASSWORD("oldboy123")WHEREQueryOK,2rowsaffected(0.00sec)RowsQueryOK,2rowsaffected(0.00sec)Rowsmatched:2Changed:2Warnings:0mysql>FLUSHPRIVILEGES;MysqlMysql，rootrootQueryOK,0rowsaffected(0.00sec)killallkillallmysql-uroot-pkillallkillallmysql-uroot-p-S修改QueryOK,2rowsaffected(0.00sec)Rowsmatched:2Changed:2Warnings:0mysql>FLUSHPRIVILEGES;QueryOK,0rowsaffected(0.00sec)mysql>quitkillallkillall命令：create mysql>showcreatedatabase+++||Create|++++++SHOWCREATEDATABASEmysql>SHOWCREATEDATABASE+++|+++| |CREATEDATABASE`oldboy`/*!40100DEFAULTCHARACTERSETlatin1*/+++1rowinset(0.00QueryOK,1rowaffected(0.00mysql>SHOWCREATEDATABASE+++|++++++1rowinset(0.00mysql>SHOWCREATEDATABASE+++| |Create|+++|oldboy_utf8|CREATEDATABASE`oldboy_utf8`/*!40100DEFAULTCHARACTERSETutf8*/+++1rowinset(0.00createcreatedatabasecreatedatabaseoldboy_utf8CHARACTERSETutf8COLLATEmysql>helpcreateName:'CREATECREATE{DATABASE|SCHEMA}[IFNOTEXISTS]|[DEFAULT]COLLATE[=]CREATEDATABASEcreatesadatabasewiththegivenname.Tousestatement,youneedtheCREATEprivilegeforthedatabase.CREATESCHEMAisasynonymforCREATEDATABASE.URL:mysql>showcreatedatabase+++|+++||CREATEDATABASE`ett`/*!40100DEFAULTCHARACTERSETlatin1*/+++1rowinset(0.01命令：showmysql>mysql>show++|| |information_schema|||| ||||||++6rowsinset(0.00sec)mysql>helpshowSHOWDATABASESmysql>showdatabaseslike ++||++1rowinset(0.00mysql>showdatabaseslike |Database(%oldboy%)++||||||++3rowsinset(0.00oldboymysql>mysql>dropdatabaseQueryOK,0rowsaffected(0.00sec)mysql>showdatabaseslike'test';Emptyset(0.01sec)命令： Databasechangedmysql>select |database() |oldboy_gbk++1rowinset(0.00sec)mysql>helpuseName:'USE'USETheUSEdb_namestatement lsMySQLtousethedb_namedatabaseasthedefault(current)databaseforsubsequentstatements.ThedatabaseremainsthedefaultuntiltheendofthesessionoranotherUSEstatementisissued:USESELECTCOUNT(*)FROMmytable;#selectsfromdb1.mytableUSEdb2; URL: mysql>mysql>select++|database()++|oldboy_gbk++1rowinset(0.00mysql>select |version()++| ++1rowinset(0.00mysql>select+++|| ++1rowinset(0.00mysql>mysql>showEmptyset(0.00sec语法：dropuseruser"@"主机域mysql>mysql>dropuserQueryOK,0rowsaffected(0.00sec)mysql>dropuser''@’oldboy’;QueryOK,0rowsaffected(0.00sec)mysql>dropuser''@'localhost';mysql>selectuser,hostfrom+++|user||+++|root||root|localhost+++2rowsinset(0.00Name:'GRANT'[,priv_type[(column_list)]]...ON[object_type]priv_levelTOuser_specification[,user_specification]...[WITHwith_option||*|||||user[IDENTIFIEDBY[PASSWORD]||CIPHER|ISSUER|SUBJECTGRANT|MAX_QUERIES_PER_HOUR|MAX_UPDATES_PER_HOUR|MAX_USER_CONNECTIONSTheGRANTstatementgrantsprivilegestoMySQLuseraccounts.GRANTalsoservestospecifyotheraccountcharacteristicssuchasuseofsecureconnectionsandlimitsonaccesstoserverresources.Touseprivilegesthatyouaregranting.Normally,adatabaseadministratorfirstusesCREATEUSERtocreateanCREATEUSER'jeffrey'@'localhost'IDENTIFIEDBYGRANTALLONdb1.*TOGRANTSELECTONTOGRANTUSAGEON*.*TO'jeffrey'@'localhost'WITHMAX_QUERIES_PER_HOURHowever,ifanaccountnamedinaGRANTstatementdoesnotexist,GRANTmaycreateitundertheconditionsdescribedlaterinthediscussionoftheNO_AUTO_CREATE_USERSQLmode.TheREVOKEstatementisrelatedtoGRANTandenablesadministratorsremoveaccountprivileges.See[HELPTodeterminewhatprivilegesanaccounthas,useSHOWGRANTS.SeeSHOWURL:grantgrantallprivilegesondbname.*tousername@localhostidentifiedby其中username，dbname,passwd可根据自己的情况修改。mysql>mysql>grantALLon*.*totest@localhostidentifiedby'123';QueryOK,0rowsaffected(0.00sec)mysql>SHOWGRANTSFOR '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257'|1rowinset(0.01QueryOK,0rowsaffected(0.01sec)mysql>SHOWGRANTSFORSHOWDATABASES,SUPER,CREATETEMPORARYTABLES,LOCKTABLES,EXECUTE,REPLICATIONSLAVE,REPLICATION,11rowinset(0.01提示：此时ALLPRIVILEGESselect我们就可以得出结论了，ALLPRIVILEGES包括权限为：CREATETEMPORARYTABLES,LOCKTABLES,REPLICATION,CREATESHOWVIEW,ALTERROUTINE,CREATEUSER,博客，CMS等产品的数据库mysql>mysql>createdatabaseblogDEFAULTCHARACTERSETgbkCOLLATEQueryOK,1rowaffected(0.00QueryOK,0rowsaffected(0.00 mysql>help REVOKEREVOKEALLPRIVILEGES,GRANTREVOKEcreateonblog.*FROM'blog'@'10.0.0.%';mysql>showgrantsforblog@'10.0.0.%';++||++ D24E489A0096DCFA036B166446FDDD992'| |++2rowsinset(0.00限（SELECT为oldboy456。[root@oldboy[root@oldboy~]#mysql-ublog-[root@oldboy~]#mysql-ublog-p'oldboy'-h79etotheMySQLmonitor.Commandsendwith;orYourMySQLconnectionidismysql>showdatabases;++|| |information_schema||+++2rowsinset(0.00mysql>mysql>select++|| ++1rowinset(0.00sec) 令非常相似，select[root@oldboy[root@oldboy~]#mysql-uroot-etotheMySQLmonitor.Commandsendwith;orYourMySQLconnectionidisType'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>selectuser,hostfrommysql.user;+++| ||+++| |10.0.0.%| ||oldboy|localhost| |localhost| |localhost+++5rowsinset(0.00mysql>mysql>createdatabaseoldboyDEFAULTCHARACTERSETgbkCOLLATEmysql>showdatabaseslike |Database(oldboy)++||++1rowinset(0.01mysql>showcreatedatabase+++|+++| |CREATEDATABASE`oldboy`/*!40100DEFAULTCHARACTERSETgbk*/+++1rowinset(0.00mysql>mysql>createtableidint(4)notnullprimarykeyauto_increment,namechar(20)notnullat_creet,增长1,2,3,char(20)为定长字符串，不超过20个字符。可以用下表表示：name1234Databasemysql>createtable->namechar(20)not->->TIMESTAMP createtableSnoint(10NOTNULLCOMMENTSnamevarchar(16)NOTNULLCOMMENT' char(2)NOTNULLCOMMENT' Sdeptvarchar(16)defaultNULLCOMMENT))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULT createtableCnoint(10NOTNULLCOMMENTCnamevarchar(64NOTNULLCOMMENTPRIMARYKEY(Cno))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULT CREATETABLE`SC`(SCidint(12NOTNULLauto_incrementCOMMENT`Cno`int(10NOTNULLCOMMENT`Sno`int(10NOTNULLCOMMENT`Grade`tinyint(2NOTNULLCOMMENTPRIMARYKEY(`SCid`)A、查表结构descshowcolumnsfrom表名mysql>mysql>descmysql>showcolumnsfrommysql>mysql>desc+++ ++|Field||Null|Key|Default||+++ ++| | | |PRI| |name|char(20)| | |+++ ++2rowsinset(0.01mysql>mysql>showcolumnsfrom+++ ++|Field||Null|Key|Default||+++ ++| | | |PRI| |name|char(20)| | |+++ ++2rowsinset(0.00mysql>mysql>showcreatetabletestmysql>mysql>showcreatetabletest\G(\G)Sendcommandtomysqlserver, y***************************1.rowTable:CreateTable:CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTNULL,PRIMARYKEY(`id`))1rowinset(0.00命令：insertinto表名1>[,..<nvalues(1)[,(ninsertintotestvalues(3,' ceninsertintotestvalues(4,'elain'),(5,'wodi)mysql>select*fromtest; +|id| +|1|zhaoyue rowinset(0.00QueryOK,1rowaffected(0.01sec)mysql>select*from |id| |1|zhaoyue|2| rowsinset(0.00mysql>insertintotestvalues('mysql>insertintotestvalues(3,'cen');mysql>select*from |id| |1|zhaoyue|2| |3|cen rowsinset(0.00mysql>insertintotestvalues(4,'elain'),(5,'wodi');QueryOK,2rowsaffected(0.00sec)Records:2Duplicates:0Warnings:mysql>select*from |id| |1|zhaoyue||2| |3 cen|4| |5| +5rowsinset(0.00mysql>insertintotest(name)QueryOK,3rowsaffected(0.01sec)Records:3Duplicates:0Warnings:mysql>select*from +|id|| +|1| |2|||3 ||4|||5|||6| |7| |8|zaixiangpan +8rowsinset(0.00mysql>mysql>systemmysqldump-uroot-p'oldboy'-A-B>/tmp/oldboybak.sqlmysql>systemls-l/tmp/oldboybak.sql-rw-r--r--1rootroot503161Apr900:40提示：4.1节会用到此处备份的数据还原填充数据。select12，from<where<testmysql>mysql>select*from +|id||+++|1|||2|||3|||4|||5|||6|||7|||8||test2mysql>mysql>select*from +|id|| +|1| |2|||3 ||4|||5|||6| |7| |8|zaixiangpan +8rowsinset(0.00select*fromselect*fromtestlimit2;select*fromtestlimitselect*fromtestorderbyidasclimit0,2;select*fromtestwhereid=1;select*fromtestwhereidselect*fromtestwherename=' |id| |1|zhaoyue|2| 2rowsinset(0.00 |id| |1|zhaoyue|2| 2rowsinset(0.00mysql>select*fromtestorderbyiddesclimit |id| |8|zaixiangpan|7| 2rowsinset(0.01 |id| |1|zhaoyue|2| 2rowsinset(0.00 |id| ||1|zhaoyue +1rowinset(0.00 +|id|| +|7| |8|zaixiangpan +2rowsinset(0.00 +|id| +|3 cen +1rowinset(0.00updateset字段=新值,wheremysql>mysql>updatetestsetname='oldboy'whereidQueryOK,1rowaffected(0.01sec)Rowsmatched:1Changed:1Warnings:0 +|id| +|1|oldboy +1rowinset(0.00mysql>updatetestsetname='oldboy';<==如果不加条件要十 QueryOK,7rowsaffected(0.00sec)Rowsmatched:8Changed:7Warnings:0mysql>mysql>select*from +|id| +|1|oldboy|2|oldboy|3|oldboy|4|oldboy|5|oldboy|6|oldboy|7|oldboy|8|oldboy +8rowsinset(0.00命令：deletefromwhere表达式test1的记录mysql>deletefromtestwhereid=1;mysql>mysql>select*from +|id| +|1|oldboy|2|oldboy|3|oldboy|4|oldboy|5|oldboy|6|oldboy|7|oldboy|8|oldboy +8rowsinset(0.00mysql>deletefromtestwhereid=1id1mysql>select*from +||id| +|2|oldboy|3|oldboy|4|oldboy7rowsinset(0.00|5|||6|||7|||8||+++命令：truncatetable表名truncatetruncatetabletestmysqlselect*fromtest; +|id| +|6|oldboy|7|oldboy|8|oldboy +3rowsinset(0.00mysqltruncatetabletestEmptyset(0.00命令：altertableadd alteraltertabletest altertabletestaddageint(4aftername;nameagemysql>mysql>desc+++ ++|Field||Null|Key|Default||+++ ++| | | |PRI| |name|char(20)| | |+++ ++2rowsinset(0.01Name:'ALTERTABLE'|ADD[COLUMN]col_namecolumn_definition[FIRST|AFTERcol_name]|DROP[COLUMN]|DROP{INDEX|KEY}mysql>altertabletest char(4);#←增 QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:mysql>desc+++ ++|Field||Null|Key|Default||+++ ++| | | |PRI| |name|char(20)| | | |char(4)|YES | 3rowsinset(0.00mysqlaltertabletestaddageint(4afternamenameageQueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>desc |Field| |Null|Key|Default| +++++++||||||||||||||||||||||||||||+++++++4rowsinset(0.01sec)Table:testCreateTable:CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTPRIMARYKEY(`id`)1rowinset(0.00mysql>altertabletestdrop;QueryOK,0rowsaffected(0.03sec)Records:0Duplicates:0Warnings:0mysql>desc |Field| |Null|Key|Default| | | | |PRI| |name|char(20)| | || | |YES| |++ ++3rowsinset(0.02命令：renametableto新表名;例如：在表test名字更改为oldboymysql>mysql>show ++||++1rowinset(0.00mysql>mysql>renametabletesttomysql>show ++||++1rowinset(0.00mysql>mysql>altertableoldboyrenametomysql>showtables; ++||++1rowinset(0.00sec)mysqlhelprenameName:'RENAMERENAMETABLEtbl_nameTOnew_tbl_name[,tbl_name2TOnew_tbl_name2]mysql>helpManyhelpitemsforyourrequestTomakeamorespecificrequest,pleasetype'help<item>',where<item>isoneofthefollowingALTEREVENTALTERTABLERENAMEUSERmysql>RENAMETABLEtestTOmysql>show ++||++1rowinset(0.00mysql>mysql>show ++||++1rowinset(0.00mysql>droptablemysql>mysql>showEmptyset(0.00许你使用字符串或数字把值赋给DATE列 TIMESTAMPmysql>mysql>showEmptyset(0.01mysql>systemmysqlurootp'oldboy123'oldboytmp/oldboybak.sqlmysql>show++|Tables_in_oldboy++||++1rowinset(0.00mysql>select*from +|1|||2|||4|||5|||6|||7|||1|||2|||4|||5|||6|||7|||8|||1|||2|||4|||5|||6|||7|||8|||9||字符集就是一套文字符号及其编码、比较规则的集合第一个计算机字符集ASC2 双字节不是国际标准，支持的系统不少。 非定 1-4字节广泛支持，MYSQL也使用UTF-是UTF-8（每个汉字三双字节）UTF-8setnamesgbk[root@oldboy[root@oldboy~]#mysql-uroot-etotheMySQLmonitor.Commandsendwith;orYourMySQLconnectionidisServerversion:5.1.62SourceType'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>useoldboyDatabasemysql>show |Tables_in_oldboy | 1rowinset(0.00mysql>select*from |id| +++|1|||2|||4|||5|||6|||7|||8|||9|||10||11| 10rowsinset(0.00mysql>showvariableslike | | | | |character_set_connection| | | |character_set_filesystem| | | | | | | | |/usr/local/mysql/share/mysql/charsets/ 8rowsinset(0.00mysql>setnamesQueryOK,0rowsaffected(0.01mysql>showvariableslike | | | | |character_set_connection| | | |character_set_filesystem| | | | | | | | |/usr/local/mysql/share/mysql/charsets/ 8rowsinset(0.01| | #客户 |character_set_connection| #连 | | #返回结果字符 mysql>setnames mysql-uroot-p'oldboy123'--default-character-mysql-uroot-p'oldboy123'-S/data/3306/mysql.sock--default-character-[root@oldboy~]#mysql-uroot-p'oldboy123'-e"showvariableslike | | | | ||||||||||||+++||character_set_connection||| |||character_set_filesystem||[root@oldboy-uroot-p'oldboy123'--default-character-set=gbk-e"showvariables+++|||+++||||character_set_connection||| |||character_set_filesystem||| |||||||||+++mysqldump-u用户–p’’--default-character-set=latin1数据库名>备份文件名(数据库默认编码是mysqldump-uroot-p'oldboy123'oldboy>mysqldump-uroot-p'oldboy123'oldboy|gzip>mysqldump-uroot-p'oldboy123'oldboy--default-character-set=gbk|gzip>[root@oldboy[root@oldboy~]#mkdir/server/bak-[root@oldboy~]#mysqldump-uroot-p'oldboy123'oldboy>/server/babackup/bak/[root@oldboy~]#mysqldump-uroot-p'oldboy123'oldboy>/server/bak/oldboy.sql[root@oldboy~]#mysqldump-uroot-p'oldboy123'oldboy|gzip>/server/bak/oldboy.sql.gz[root@oldboy~]#ls-ltotaltotal-rw-r--r--1rootroot1991Apr900:51-rw-r--r--1rootroot801Apr900:51 [root@oldboy~]#egrep-v"\*|--|^$"/server/bak/oldboy.sqlDROPTABLEIFEXISTS`test`;CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTNULL,PRIMARYKEY(`id`))ENGINE=MyISAMAUTO_INCREMENT=12DEFAULTCHARSET=gbk;LOCKTABLES`test`WRITE;INSERTINTO`test`(10,'鑰佺敺瀛?),(11,'鎴?);<==这里是乱码，是因为导出时的格式没加字符集，而系统当前字符集又是 会正常，只是系统外查看不正常而已。另外insert是批量插入的方式,这样在恢复时效率很高。UNLOCK - - [root@oldboy~]#egrep-v"\*|--|^$"/server/bak/oldboy-gbk.sqlDROPTABLEIFEXISTS`test`;CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTNULL,PRIMARYKEY(`id`))ENGINE=MyISAMAUTO_INCREMENT=12DEFAULT,'我');UNLOCK[root@oldboy[root@oldboy~]#mysqldump-uroot-p'oldboy123'-Boldboymysql--default-character-set=gbk※※※※※（生产环境常用-B,--databases To-B,--databases Todumpseveraldatabases.Notethedifferenceinusage;Inthiscasenotablesaregiven.Allnameargumentsareregardedasdatabasenames.'USEdb_name;'willbeincludedintheoutput.mysqldumpu-p>mysqldump-uroot-poldboytest>[root@oldboy[root@oldboy~]#mysqldump-uroot-p'oldboy123'oldboytest--default-character-set=gbk[root@oldboy[root@oldboy~]#mysqldump-uroot-p'oldboy123'oldboytestett--default-character-set=gbk[root@oldboy~]#egrep-v"\*|--|^$"/server/bak/oldboy-gbk-muti-tables.sqlDROPTABLEIFEXISTS`test`;CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTNULL,PRIMARYKEY(`id`))ENGINE=MyISAMAUTO_INCREMENT=12DEFAULTCHARSET=gbk;LOCKTABLES`test`WRITE;INSERTINTO`test`UNLOCKDROPTABLEIFEXISTS`ett`;CREATETABLE`ett`(`id`int(11)DEFAULT)ENGINE=MyISAMDEFAULTCHARSET=gbk;LOCKTABLES`ett`WRITE;mysqldump-uroot-d-p'oldboy'oldboyoldboy>-d[root@oldboy[root@oldboy~]#mysqldump-uroot-p'oldboy123'-doldboy[root@oldboy~]#egrep-v"\*|--|^$"/tmp/desc.sqlDROPTABLEIFEXISTS`ett`;CREATETABLE`ett``id`int(11)DEFAULT)ENGINE=MyISAMDEFAULTCHARSET=gbk;DROPTABLEIFEXISTS`test`;CREATETABLE`test``id`int(4)NOTNULL`name`char(20)NOTNULL,PRIMARYKEY(`id`))ENGINE=MyISAMAUTO_INCREMENT=12DEFAULTmysql>use[root@oldboy[root@oldboybak]#mysql-uroot-etotheMySQLmonitor.Commandsendwith;orType'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputmysql>useDatabasechanged |Tables_in_oldboy++||||++2rowsinset(0.00mysql>droptablesQueryOK,0rowsaffected(0.01mysql>systemls oldboy-gbk-single.sqloldboy.sqloldboy-gbk-muti-tables.sqloldboy-gbk.sql mysql>sourceoldboy.sqlQueryOK,0rowsaffected(0.00sec)QueryOK,0rowsaffected(0.00sec)Q