MySQL Reference Manual.pdf

MySQLReferenceManual

Copyrightc ° 1997-2004MySQLAB

TableofContents

1GeneralInformation ....................... 1

1.1AboutThisManual ..................................... 2

1.1.1ConventionsUsedinThisManual ................ 2

1.2OverviewoftheMySQLDatabaseManagementSystem .... 4

1.2.1HistoryofMySQL .............................. 5

1.2.2TheMainFeaturesofMySQL ................... 6

1.2.3MySQLStability ............................... 8

1.2.4HowBigMySQLTablesCanBe ................. 9

1.2.5Year2000Compliance ......................... 10

1.3OverviewofMySQLAB ................................ 12

1.3.1TheBusinessModelandServicesofMySQLAB .. 13

1.3.1.1Support .............................. 13

1.3.1.2TrainingandCertiﬁcation ............. 13

1.3.1.3Consulting ........................... 14

1.3.1.4CommercialLicenses .................. 14

1.3.1.5Partnering ............................ 15

1.3.2ContactInformation ........................... 15

1.4MySQLSupportandLicensing .......................... 16

1.4.1SupportO®eredbyMySQLAB ................. 16

1.4.2CopyrightsandLicensesUsedbyMySQL ........ 17

1.4.3MySQLLicenses ............................... 17

1.4.3.1UsingtheMySQLSoftwareUndera

CommercialLicense ....................... 18

1.4.3.2UsingtheMySQLSoftwareforFreeUnder

GPL ..................................... 19

1.4.4MySQLABLogosandTrademarks ............. 19

1.4.4.1TheOriginalMySQLLogo ............. 20

1.4.4.2MySQLLogosThatMayBeUsedWithout

WrittenPermission ....................... 20

1.4.4.3WhenYouNeedWrittenPermissiontoUse

MySQLLogos ............................ 20

1.4.4.4MySQLABPartnershipLogos ......... 21

1.4.4.5UsingtheWordMySQLinPrintedTextor

Presentations ............................. 21

1.4.4.6UsingtheWordMySQLinCompanyand

ProductNames ........................... 21

1.5MySQLDevelopmentRoadmap ......................... 21

1.5.1MySQL4.0inaNutshell ....................... 22

1.5.1.1FeaturesAvailableinMySQL4.0 ....... 22

1.5.1.2TheEmbeddedMySQLServer ......... 23

1.5.2MySQL4.1inaNutshell ....................... 24

1.5.2.1FeaturesAvailableinMySQL4.1 ....... 24

1.5.2.2StepwiseRollout ...................... 25

1.5.2.3ReadyforImmediateDevelopmentUse

......................................... 25

1.5.3MySQL5.0:TheNextDevelopmentRelease ..... 26

1.6MySQLandtheFuture(theTODO) .................... 26

1.6.1NewFeaturesPlannedfor5.0 ................... 26

1.6.2NewFeaturesPlannedfor5.1 ................... 27

1.6.3NewFeaturesPlannedfortheNearFuture ...... 28

1.6.4NewFeaturesPlannedfortheMid-TermFuture .. 30

1.6.5NewFeaturesWeDon’tPlantoImplement ...... 31

1.7MySQLInformationSources ............................ 31

1.7.1MySQLMailingLists .......................... 32

1.7.1.1TheMySQLMailingLists ............. 32

1.7.1.2AskingQuestionsorReportingBugs .... 33

1.7.1.3HowtoReportBugsorProblems ...... 34

1.7.1.4GuidelinesforAnsweringQuestionsonthe

MailingList .............................. 38

1.7.2MySQLCommunitySupportonIRC(InternetRelay

Chat) ........................................... 39

1.8MySQLStandardsCompliance .......................... 39

1.8.1WhatStandardsMySQLFollows ............... 40

1.8.2SelectingSQLModes .......................... 40

1.8.3RunningMySQLinANSIMode ................ 40

1.8.4MySQLExtensionstoStandardSQL ............ 41

1.8.5MySQLDi®erencesfromStandardSQL ......... 44

1.8.5.1Subqueries ........................... 44

1.8.5.2 SELECTINTOTABLE ................... 44

1.8.5.3TransactionsandAtomicOperations ... 45

1.8.5.4StoredProceduresandTriggers ........ 47

1.8.5.5ForeignKeys ......................... 47

1.8.5.6Views ................................ 49

1.8.5.7‘ -- ’astheStartofaComment ......... 49

1.8.6HowMySQLDealswithConstraints ............ 50

1.8.6.1Constraint PRIMARYKEY / UNIQUE ...... 50

1.8.6.2Constraint NOTNULL and DEFAULT Values

......................................... 51

1.8.6.3Constraint ENUM and SET .............. 52

1.8.7KnownErrorsandDesignDeﬁcienciesinMySQL

................................................ 52

1.8.7.1Errorsin3.23FixedinaLaterMySQL

Version ................................... 52

1.8.7.2Errorsin4.0FixedinaLaterMySQL

Version ................................... 53

1.8.7.3OpenBugsandDesignDeﬁcienciesin

MySQL .................................. 53

iii

2InstallingMySQL ......................... 59

2.1GeneralInstallationIssues .............................. 59

2.1.1OperatingSystemsSupportedbyMySQL ....... 60

2.1.2ChoosingWhichMySQLDistributiontoInstall .. 61

2.1.2.1ChoosingWhichVersionofMySQLto

Install .................................... 62

2.1.2.2ChoosingaDistributionFormat ........ 64

2.1.2.3HowandWhenUpdatesAreReleased .. 65

2.1.2.4ReleasePhilosophy—NoKnownBugsin

Releases .................................. 65

2.1.2.5MySQLBinariesCompiledbyMySQLAB

......................................... 66

2.1.3HowtoGetMySQL ........................... 73

2.1.4VerifyingPackageIntegrityUsingMD5Checksums

or GnuPG ........................................ 73

2.1.4.1VerifyingtheMD5Checksum .......... 73

2.1.4.2SignatureCheckingUsing GnuPG ....... 74

2.1.4.3SignatureCheckingUsing RPM .......... 75

2.1.5InstallationLayouts ............................ 76

2.2StandardMySQLInstallationUsingaBinaryDistribution

....................................................... 77

2.2.1InstallingMySQLonWindows ................. 77

2.2.1.1WindowsSystemRequirements ........ 78

2.2.1.2InstallingaWindowsBinaryDistribution

......................................... 78

2.2.1.3PreparingtheWindowsMySQL

Environment ............................. 79

2.2.1.4SelectingaWindowsServer ............ 81

2.2.1.5StartingtheServerfortheFirstTime .. 82

2.2.1.6StartingMySQLfromtheWindows

CommandLine ........................... 83

2.2.1.7StartingMySQLasaWindowsService .. 84

2.2.1.8TroubleshootingaMySQLInstallation

UnderWindows .......................... 86

2.2.1.9RunningMySQLClientProgramson

Windows ................................. 87

2.2.1.10MySQLonWindowsComparedto

MySQLonUnix .......................... 88

2.2.2InstallingMySQLonLinux ..................... 90

2.2.3InstallingMySQLonMacOSX ................ 93

2.2.4InstallingMySQLonNetWare .................. 95

2.2.5InstallingMySQLonOtherUnix-LikeSystems ... 97

2.3MySQLInstallationUsingaSourceDistribution ......... 100

2.3.1SourceInstallationOverview .................. 101

2.3.2Typical configure Options ................... 103

2.3.3InstallingfromtheDevelopmentSourceTree ... 106

2.3.4DealingwithProblemsCompilingMySQL ...... 109

2.3.5MIT-pthreadsNotes .......................... 112

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: