资源描述：
《MySQL Pocket Reference》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、SECONDEDITIONMySQLPocketReferenceGeorgeReeseBeijing•Cambridge•Farnham•Köln•Paris•Sebastopol•Taipei•TokyoMySQLPocketReference,SecondEditionbyGeorgeReeseCopyright©2007,2003GeorgeReese.Allrightsreserved.PrintedinCanada.PublishedbyO’ReillyMedia,Inc.,1005Graven
2、steinHighwayNorth,Sebastopol,CA95472.O’Reillybooksmaybepurchasedforeducational,business,orsalespromotionaluse.Onlineeditionsarealsoavailableformosttitles(safari.oreilly.com).Formoreinformation,contactourcorporate/institutionalsalesdepartment:(800)998-9938o
3、rcorporate@oreilly.com.Editor:AndyOramIndexer:JohnnaVanHooseDinseProductionEditor:CoverDesigner:KarenMontgomeryLaurelR.T.RumaInteriorDesigner:DavidFutatoCopyeditor:Genevieved’EntremontProofreader:LaurelR.T.RumaPrintingHistory:February2003:FirstEdition.July
4、2007:SecondEdition.NutshellHandbook,theNutshellHandbooklogo,andtheO’ReillylogoareregisteredtrademarksofO’ReillyMedia,Inc.ThePocketReferenceseriesdesignations,MySQLPocketReference,theimageofakingfisher,andrelatedtradedressaretrademarksofO’ReillyMedia,Inc.Ma
5、nyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedastrademarks.Wherethosedesignationsappearinthisbook,andO’ReillyMedia,Inc.wasawareofatrademarkclaim,thedesignationshavebeenprintedincapsorinitialcaps.Whileeveryprecautionhas
6、beentakeninthepreparationofthisbook,thepublisherandauthorassumenoresponsibilityforerrorsoromissions,orfordamagesresultingfromtheuseoftheinformationcontainedherein.ISBN-10:0-596-51426-3ISBN-13:978-0-596-51426-6[TM]ContentsIntroduction1MySQL52Views3Triggers3
7、StoredProcedures3Cursors4NewStorageEngines4DatabaseEvents5Setup5DownloadingMySQL5Configuration6Startup8SettheRootPassword10Replication10Command-LineTools12DataTypes15Numerics16Strings21Dates26ComplexTypes28vSQL30CaseSensitivity31Literals31Identifiers33Comm
8、ents34Commands35TransactionRules86Operators87RulesofPrecedence87ArithmeticOperators88ComparisonOperators89LogicalOperators91Functions91AggregateFunctions91GeneralFunctions93StorageEngines114StoredProceduresan
