[MySQL袖珍参考手册(第2版)].(MySQL.Pocket.Reference).George.Reese.文字版

《[MySQL袖珍参考手册(第2版)].(MySQL.Pocket.Reference).George.Reese.文字版》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、MySQLPocketReferenceSECONDEDITIONMySQLPocketReferenceGeorgeReeseBeijing•Cambridge•Farnham•Köln•Paris•Sebastopol•Taipei•TokyoMySQLPocketReference,SecondEditionbyGeorgeReeseCopyright©2007,2003GeorgeReese.Allrightsreserved.PrintedinCanada.PublishedbyO’ReillyMedia,Inc.,1005GravensteinHighwayNorth

2、,Sebastopol,CA95472.O’Reillybooksmaybepurchasedforeducational,business,orsalespromotionaluse.Onlineeditionsarealsoavailableformosttitles(safari.oreilly.com).Formoreinformation,contactourcorporate/institutionalsalesdepartment:(800)998-9938orcorporate@oreilly.com.Editor:AndyOramIndexer:JohnnaVa

3、nHooseDinseProductionEditor:CoverDesigner:KarenMontgomeryLaurelR.T.RumaInteriorDesigner:DavidFutatoCopyeditor:Genevieved’EntremontProofreader:LaurelR.T.RumaPrintingHistory:February2003:FirstEdition.July2007:SecondEdition.NutshellHandbook,theNutshellHandbooklogo,andtheO’Reillylogoareregistered

4、trademarksofO’ReillyMedia,Inc.ThePocketReferenceseriesdesignations,MySQLPocketReference,theimageofakingfisher,andrelatedtradedressaretrademarksofO’ReillyMedia,Inc.Manyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedastrademarks.Wherethosedesignationsappearint

5、hisbook,andO’ReillyMedia,Inc.wasawareofatrademarkclaim,thedesignationshavebeenprintedincapsorinitialcaps.Whileeveryprecautionhasbeentakeninthepreparationofthisbook,thepublisherandauthorassumenoresponsibilityforerrorsoromissions,orfordamagesresultingfromtheuseoftheinformationcontainedherein.IS

6、BN-10:0-596-51426-3ISBN-13:978-0-596-51426-6[TM]ContentsIntroduction1MySQL52Views3Triggers3StoredProcedures3Cursors4NewStorageEngines4DatabaseEvents5Setup5DownloadingMySQL5Configuration6Startup8SettheRootPassword10Replication10Command-LineTools12DataTypes15Numerics16Strings21Dates26ComplexTyp

7、es28vSQL30CaseSensitivity31Literals31Identifiers33Comments34Commands35TransactionRules86Operators87RulesofPrecedence87ArithmeticOperators88ComparisonOperators89LogicalOperators91Functions91AggregateFunctions91GeneralFunctions93StorageEngines1