MySQL Reference Manual.pdf
(
5788 KB
)
Pobierz
MySQL Reference Manual v5.0.1-alpha - 2004 - MySQL AB - Fully Bookmarked Version
MySQLReferenceManual
Copyrightc
°
1997-2004MySQLAB
i
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.2TrainingandCertification
.............
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
ii
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.7KnownErrorsandDesignDeficienciesinMySQL
................................................
52
1.8.7.1Errorsin3.23FixedinaLaterMySQL
Version
...................................
52
1.8.7.2Errorsin4.0FixedinaLaterMySQL
Version
...................................
53
1.8.7.3OpenBugsandDesignDeficienciesin
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:
pionko
Inne pliki z tego folderu:
Steve Suehring - MySQL Bible.pdf
(6402 KB)
Russell Dyer - MySQL in a Nutshell.chm
(525 KB)
Randy J. Jarger, George Reese, Tim King, Hugh E. Williams - Managing and Using MySQL, 2nd Edition.chm
(914 KB)
Paul DuBois - MySQL Cookbook.pdf
(4074 KB)
Paul DuBois - MySQL and Perl for the Web.chm
(820 KB)
Inne foldery tego chomika:
3000 Javascript
Ajax
CSS
css jquery html5 php
html5
Zgłoś jeśli
naruszono regulamin