O’Reilly.MySQL.Cookbook.PDF

《O’Reilly.MySQL.Cookbook.PDF》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、MySQLCookbookByPaulDuBoisPublisher:O'ReillyPubDate:October2002ISBN:0-596-00145-2Pages:1022MySQLCookbookprovidesauniqueproblem-and-solutionformatthatofferspracticalexamplesforeverydayprogrammingdilemmas.Foreveryproblemaddressedinthebook,there'saworked-outsolutionor"recipe"--s

2、hort,focusedpiecesofcodethatyoucaninsertdirectlyintoyourapplications.Morethanacollectionofcut-and-pastecode,thisbookexplanationhowandwhythecodeworks,soyoucanlearntoadaptthetechniquestosimilarsituations.CopyrightPrefaceMySQLAPIsUsedinThisBookWhoThisBookIsForWhat'sinThisBookPl

3、atformNotesConventionsUsedinThisBookTheCompanionWebSiteCommentsandQuestionsAdditionalResourcesAcknowledgmentsChapter1.UsingthemysqlClientProgramSection1.1.IntroductionSection1.2.SettingUpaMySQLUserAccountSection1.3.CreatingaDatabaseandaSampleTableSection1.4.StartingandTermin

4、atingmysqlSection1.5.SpecifyingConnectionParametersbyUsingOptionFilesSection1.6.ProtectingOptionFilesSection1.7.MixingCommand-LineandOptionFileParametersSection1.8.WhattoDoifmysqlCannotBeFoundSection1.9.SettingEnvironmentVariablesSection1.10.IssuingQueriesSection1.11.Selecti

5、ngaDatabaseSection1.12.CancelingaPartiallyEnteredQuerySection1.13.RepeatingandEditingQueriesSection1.14.UsingAuto-CompletionforDatabaseandTableNamesSection1.15.UsingSQLVariablesinQueriesSection1.16.TellingmysqltoReadQueriesfromaFileSection1.17.TellingmysqltoReadQueriesfromOt

6、herProgramsSection1.18.SpecifyingQueriesontheCommandLineSection1.19.UsingCopyandPasteasamysqlInputSourceSection1.20.PreventingQueryOutputfromScrollingofftheScreenSection1.21.SendingQueryOutputtoaFileortoaProgramSection1.22.SelectingTabularorTab-DelimitedQueryOutputFormatSect

7、ion1.23.SpecifyingArbitraryOutputColumnDelimitersSection1.24.ProducingHTMLOutputSection1.25.ProducingXMLOutputSection1.26.SuppressingColumnHeadingsinQueryOutputSection1.27.NumberingQueryOutputLinesSection1.28.MakingLongOutputLinesMoreReadableSection1.29.Controllingmysql'sVer

8、bosityLevelSection1.30.LoggingInteractivemysqlSessionsSection1.31.Creatingm