1
/* Copyright (C) 2000-2001 MySQL AB
3
This program is free software; you can redistribute it and/or modify
4
it under the terms of the GNU General Public License as published by
5
the Free Software Foundation; version 2 of the License.
7
This program is distributed in the hope that it will be useful,
8
but WITHOUT ANY WARRANTY; without even the implied warranty of
9
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
10
GNU General Public License for more details.
12
You should have received a copy of the GNU General Public License
13
along with this program; if not, write to the Free Software
14
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
16
/* Written by Sergei A. Golubchik, who has a shared copyright to this code */
20
struct { const char *f0, *f2; } data[NDATAS] = {
21
{"1", "General Information about MySQL"},
22
{"1.1", "What is MySQL?"},
23
{"1.2", "About this manual"},
24
{"1.3", "History of MySQL"},
25
{"1.4", "The main features of MySQL"},
26
{"1.5", "General SQL information and tutorials"},
27
{"1.6", "Useful MySQL-related links"},
28
{"1.7", "What are stored procedures and triggers and so on?"},
29
{"2", "MySQL mailing lists and how to ask questions/give error (bug) reports"},
30
{"2.1", "Subscribing to/un-subscribing from the MySQL mailing list"},
31
{"2.2", "Asking questions or reporting bugs"},
32
{"2.3", "I think I have found a bug. What information do you need to help me?"},
33
{"2.3.1", "MySQL keeps crashing"},
34
{"2.4", "Guidelines for answering questions on the mailing list"},
35
{"3", "Licensing or When do I have/want to pay for MySQL?"},
36
{"3.1", "How much does MySQL cost?"},
37
{"3.2", "How do I get commercial support?"},
38
{"3.2.1", "Types of commercial support"},
39
{"3.2.1.1", "Basic email support"},
40
{"3.2.1.2", "Extended email support"},
41
/*------------------------------- NUPD=20 -------------------------------*/
42
{"3.2.1.3", "Asking: Login support"},
43
{"3.2.1.4", "Extended login support"},
44
{"3.3", "How do I pay for licenses/support?"},
45
{"3.4", "Who do I contact when I want more information about licensing/support?"},
46
{"3.5", "What Copyright does MySQL use?"},
47
{"3.6", "When may I distribute MySQL commercially without a fee?"},
48
{"3.7", "I want to sell a product that can be configured to use MySQL"},
49
{"3.8", "I am running a commercial web server using MySQL"},
50
{"3.9", "Do I need a license to sell commercial Perl/tcl/PHP/Web+ etc applications?"},
51
{"3.10", "Possible future changes in the licensing"},
52
{"4", "Compiling and installing MySQL"},
53
{"4.1", "How do I get MySQL?"},
54
{"4.2", "Which MySQL version should I use?"},
55
{"4.3", "How/when will you release updates?"},
56
{"4.4", "What operating systems does MySQL support?"},
57
{"4.5", "Compiling MySQL from source code"},
58
{"4.5.1", "Quick installation overview"},
59
{"4.5.2", "Usual configure switches"},
60
{"4.5.3", "Applying a patch"},
61
{"4.6", "Problems compiling?"},
62
{"4.7", "General compilation notes"},
63
{"4.8", "MIT-pthreads notes (FreeBSD)"},
64
{"4.9", "Perl installation comments"},
65
{"4.10", "Special things to consider for some machine/OS combinations"},
66
{"4.10.1", "Solaris notes"},
67
{"4.10.2", "SunOS 4 notes"},
68
{"4.10.3", "Linux notes for all versions"},
69
{"4.10.3.1", "Linux-x86 notes"},
70
{"4.10.3.2", "RedHat 5.0"},
71
{"4.10.3.3", "RedHat 5.1"},
72
{"4.10.3.4", "Linux-Sparc notes"},
73
{"4.10.3.5", "Linux-Alpha notes"},
74
{"4.10.3.6", "MkLinux notes"},
75
{"4.10.4", "Alpha-DEC-Unix notes"},
76
{"4.10.5", "Alpha-DEC-OSF1 notes"},
77
{"4.10.6", "SGI-IRIX notes"},
78
{"4.10.7", "FreeBSD notes"},
79
{"4.10.7.1", "FreeBSD-3.0 notes"},
80
{"4.10.8", "BSD/OS 2.# notes"},
81
{"4.10.8.1", "BSD/OS 3.# notes"},
82
{"4.10.9", "SCO notes"},
83
{"4.10.10", "SCO Unixware 7.0 notes"},
84
{"4.10.11", "IBM-AIX notes"},
85
{"4.10.12", "HP-UX notes"},
86
{"4.11", "TcX binaries"},
87
{"4.12", "Win32 notes"},
88
{"4.13", "Installation instructions for MySQL binary releases"},
89
{"4.13.1", "How to get MySQL Perl support working"},
90
{"4.13.2", "Linux notes"},
91
{"4.13.3", "HP-UX notes"},
92
{"4.13.4", "Linking client libraries"},
93
{"4.14", "Problems running mysql_install_db"},
94
{"4.15", "Problems starting MySQL"},
95
{"4.16", "Automatic start/stop of MySQL"},
96
{"4.17", "Option files"},
97
{"5", "How standards-compatible is MySQL?"},
98
{"5.1", "What extensions has MySQL to ANSI SQL92?"},
99
{"5.2", "What functionality is missing in MySQL?"},
100
{"5.2.1", "Sub-selects"},
101
{"5.2.2", "SELECT INTO TABLE"},
102
{"5.2.3", "Transactions"},
103
{"5.2.4", "Triggers"},
104
{"5.2.5", "Foreign Keys"},
105
{"5.2.5.1", "Some reasons NOT to use FOREIGN KEYS"},
107
{"5.2.7", "-- as start of a comment"},
108
{"5.3", "What standards does MySQL follow?"},
109
{"5.4", "What functions exist only for compatibility?"},
110
{"5.5", "Limitations of BLOB and TEXT types"},
111
{"5.6", "How to cope without COMMIT-ROLLBACK"},
112
{"6", "The MySQL access privilege system"},
113
{"6.1", "What the privilege system does"},
114
{"6.2", "Connecting to the MySQL server"},
115
{"6.2.1", "Keeping your password secure"},
116
{"6.3", "Privileges provided by MySQL"},
117
{"6.4", "How the privilege system works"},
118
{"6.5", "The privilege tables"},
119
{"6.6", "Setting up the initial MySQL privileges"},
120
{"6.7", "Adding new user privileges to MySQL"},
121
{"6.8", "An example permission setup"},
122
{"6.9", "Causes of Access denied errors"},
123
{"6.10", "How to make MySQL secure against crackers"},
124
{"7", "MySQL language reference"},
125
{"7.1", "Literals: how to write strings and numbers"},
126
{"7.1.1", "Strings"},
127
{"7.1.2", "Numbers"},
128
{"7.1.3", "NULL values"},
129
{"7.1.4", "Database, table, index, column and alias names"},
130
{"7.1.4.1", "Case sensitivity in names"},
131
{"7.2", "Column types"},
132
{"7.2.1", "Column type storage requirements"},
133
{"7.2.5", "Numeric types"},
134
{"7.2.6", "Date and time types"},
135
{"7.2.6.1", "The DATE type"},
136
{"7.2.6.2", "The TIME type"},
137
{"7.2.6.3", "The DATETIME type"},
138
{"7.2.6.4", "The TIMESTAMP type"},
139
{"7.2.6.5", "The YEAR type"},
140
{"7.2.6.6", "Miscellaneous date and time properties"},
141
{"7.2.7", "String types"},
142
{"7.2.7.1", "The CHAR and VARCHAR types"},
143
{"7.2.7.2", "The BLOB and TEXT types"},
144
{"7.2.7.3", "The ENUM type"},
145
{"7.2.7.4", "The SET type"},
146
{"7.2.8", "Choosing the right type for a column"},
147
{"7.2.9", "Column indexes"},
148
{"7.2.10", "Multiple-column indexes"},
149
{"7.2.11", "Using column types from other database engines"},
150
{"7.3", "Functions for use in SELECT and WHERE clauses"},
151
{"7.3.1", "Grouping functions"},
152
{"7.3.2", "Normal arithmetic operations"},
153
{"7.3.3", "Bit functions"},
154
{"7.3.4", "Logical operations"},
155
{"7.3.5", "Comparison operators"},
156
{"7.3.6", "String comparison functions"},
157
{"7.3.7", "Control flow functions"},
158
{"7.3.8", "Mathematical functions"},
159
{"7.3.9", "String functions"},
160
{"7.3.10", "Date and time functions"},
161
{"7.3.11", "Miscellaneous functions"},
162
{"7.3.12", "Functions for use with GROUP BY clauses"},
163
{"7.4", "CREATE DATABASE syntax"},
164
{"7.5", "DROP DATABASE syntax"},
165
{"7.6", "CREATE TABLE syntax"},
166
{"7.7", "ALTER TABLE syntax"},
167
{"7.8", "OPTIMIZE TABLE syntax"},
168
{"7.9", "DROP TABLE syntax"},
169
{"7.10", "DELETE syntax"},
170
{"7.11", "SELECT syntax"},
171
{"7.12", "JOIN syntax"},
172
{"7.13", "INSERT syntax"},
173
{"7.14", "REPLACE syntax"},
174
{"7.15", "LOAD DATA INFILE syntax"},
175
{"7.16", "UPDATE syntax"},
176
{"7.17", "USE syntax"},
177
{"7.18", "SHOW syntax (Get information about tables, columns...)"},
178
{"7.19", "EXPLAIN syntax (Get information about a SELECT)"},
179
{"7.20", "DESCRIBE syntax (Get information about columns)"},
180
{"7.21", "LOCK TABLES/UNLOCK TABLES syntax"},
181
{"7.22", "SET OPTION syntax"},
182
{"7.23", "GRANT syntax (Compatibility function)"},
183
{"7.24", "CREATE INDEX syntax (Compatibility function)"},
184
{"7.25", "DROP INDEX syntax (Compatibility function)"},
185
{"7.26", "Comment syntax"},
186
{"7.27", "CREATE FUNCTION/DROP FUNCTION syntax"},
187
{"7.28", "Is MySQL picky about reserved words?"},
188
{"8", "Example SQL queries"},
189
{"8.1", "Queries from twin project"},
190
{"8.1.1", "Find all non-distributed twins"},
191
{"8.1.2", "Show a table on twin pair status"},
192
{"9", "How safe/stable is MySQL?"},
193
{"9.1", "How stable is MySQL?"},
194
{"9.2", "Why are there is so many releases of MySQL?"},
195
{"9.3", "Checking a table for errors"},
196
{"9.4", "How to repair tables"},
197
{"9.5", "Is there anything special to do when upgrading/downgrading MySQL?"},
198
{"9.5.1", "Upgrading from a 3.21 version to 3.22"},
199
{"9.5.2", "Upgrading from a 3.20 version to 3.21"},
200
{"9.5.3", "Upgrading to another architecture"},
201
{"9.6", "Year 2000 compliance"},
202
{"10", "MySQL Server functions"},
203
{"10.1", "What languages are supported by MySQL?"},
204
{"10.1.1", "Character set used for data & sorting"},
205
{"10.2", "The update log"},
206
{"10.3", "How big can MySQL tables be?"},
207
{"11", "Getting maximum performance from MySQL"},
208
{"11.1", "How does one change the size of MySQL buffers?"},
209
{"11.2", "How compiling and linking affects the speed of MySQL"},
210
{"11.3", "How does MySQL use memory?"},
211
{"11.4", "How does MySQL use indexes?"},
212
{"11.5", "What optimizations are done on WHERE clauses?"},
213
{"11.6", "How does MySQL open & close tables?"},
214
{"11.6.0.1", "What are the drawbacks of creating possibly thousands of tables in a database?"},
215
{"11.7", "How does MySQL lock tables?"},
216
{"11.8", "How should I arrange my table to be as fast/small as possible?"},
217
{"11.9", "What affects the speed of INSERT statements?"},
218
{"11.10", "What affects the speed DELETE statements?"},
219
{"11.11", "How do I get MySQL to run at full speed?"},
220
{"11.12", "What are the different row formats? Or, when should VARCHAR/CHAR be used?"},
221
{"11.13", "Why so many open tables?"},
222
{"12", "MySQL benchmark suite"},
223
{"13", "MySQL Utilites"},
224
{"13.1", "Overview of the different MySQL programs"},
225
{"13.2", "The MySQL table check, optimize and repair program"},
226
{"13.2.1", "isamchk memory use"},
227
{"13.2.2", "Getting low-level table information"},
228
{"13.3", "The MySQL compressed read-only table generator"},
229
{"14", "Adding new functions to MySQL"},
230
{"15", "MySQL ODBC Support"},
231
{"15.1", "Operating systems supported by MyODBC"},
232
{"15.2", "How to report problems with MyODBC"},
233
{"15.3", "Programs known to work with MyODBC"},
234
{"15.4", "How to fill in the various fields in the ODBC administrator program"},
235
{"15.5", "How to get the value of an AUTO_INCREMENT column in ODBC"},
236
{"16", "Problems and common errors"},
237
{"16.1", "Some common errors when using MySQL"},
238
{"16.1.1", "MySQL server has gone away error"},
239
{"16.1.2", "Can't connect to local MySQL server error"},
240
{"16.1.3", "Out of memory error"},
241
{"16.1.4", "Packet too large error"},
242
{"16.1.5", "The table is full error"},
243
{"16.1.6", "Commands out of sync error in client"},
244
{"16.1.7", "Removing user error"},
245
{"16.2", "How MySQL handles a full disk"},
246
{"16.3", "How to run SQL commands from a text file"},
247
{"16.4", "Where MySQL stores temporary files"},
248
{"16.5", "Access denied error"},
249
{"16.6", "How to run MySQL as a normal user"},
250
{"16.7", "Problems with file permissions"},
251
{"16.8", "File not found"},
252
{"16.9", "Problems using DATE columns"},
253
{"16.10", "Case sensitivity in searches"},
254
{"16.11", "Problems with NULL values"},
255
{"17", "Solving some common problems with MySQL"},
256
{"17.1", "Database replication"},
257
{"17.2", "Database backups"},
258
{"18", "MySQL client tools and API's"},
259
{"18.1", "MySQL C API"},
260
{"18.2", "C API datatypes"},
261
{"18.3", "C API function overview"},
262
{"18.4", "C API function descriptions"},
263
{"18.4.1", "mysql_affected_rows()"},
264
{"18.4.2", "mysql_close()"},
265
{"18.4.3", "mysql_connect()"},
266
{"18.4.4", "mysql_create_db()"},
267
{"18.4.5", "mysql_data_seek()"},
268
{"18.4.6", "mysql_debug()"},
269
{"18.4.7", "mysql_drop_db()"},
270
{"18.4.8", "mysql_dump_debug_info()"},
271
{"18.4.9", "mysql_eof()"},
272
{"18.4.10", "mysql_errno()"},
273
{"18.4.11", "mysql_error()"},
274
{"18.4.12", "mysql_escape_string()"},
275
{"18.4.13", "mysql_fetch_field()"},
276
{"18.4.14", "mysql_fetch_fields()"},
277
{"18.4.15", "mysql_fetch_field_direct()"},
278
{"18.4.16", "mysql_fetch_lengths()"},
279
{"18.4.17", "mysql_fetch_row()"},
280
{"18.4.18", "mysql_field_seek()"},
281
{"18.4.19", "mysql_field_tell()"},
282
{"18.4.20", "mysql_free_result()"},
283
{"18.4.21", "mysql_get_client_info()"},
284
{"18.4.22", "mysql_get_host_info()"},
285
{"18.4.23", "mysql_get_proto_info()"},
286
{"18.4.24", "mysql_get_server_info()"},
287
{"18.4.25", "mysql_info()"},
288
{"18.4.26", "mysql_init()"},
289
{"18.4.27", "mysql_insert_id()"},
290
{"18.4.28", "mysql_kill()"},
291
{"18.4.29", "mysql_list_dbs()"},
292
{"18.4.30", "mysql_list_fields()"},
293
{"18.4.31", "mysql_list_processes()"},
294
{"18.4.32", "mysql_list_tables()"},
295
{"18.4.33", "mysql_num_fields()"},
296
{"18.4.34", "mysql_num_rows()"},
297
{"18.4.35", "mysql_query()"},
298
{"18.4.36", "mysql_real_connect()"},
299
{"18.4.37", "mysql_real_query()"},
300
{"18.4.38", "mysql_reload()"},
301
{"18.4.39", "mysql_row_tell()"},
302
{"18.4.40", "mysql_select_db()"},
303
{"18.4.41", "mysql_shutdown()"},
304
{"18.4.42", "mysql_stat()"},
305
{"18.4.43", "mysql_store_result()"},
306
{"18.4.44", "mysql_thread_id()"},
307
{"18.4.45", "mysql_use_result()"},
308
{"18.4.46", "Why is it that after mysql_query() returns success, mysql_store_result() sometimes returns NULL?"},
309
{"18.4.47", "What results can I get from a query?"},
310
{"18.4.48", "How can I get the unique ID for the last inserted row?"},
311
{"18.4.49", "Problems linking with the C API"},
312
{"18.4.50", "How to make a thread-safe client"},
313
{"18.5", "MySQL Perl API's"},
314
{"18.5.1", "DBI with DBD::mysql"},
315
{"18.5.1.1", "The DBI interface"},
316
{"18.5.1.2", "More DBI/DBD information"},
317
{"18.6", "MySQL Java connectivity (JDBC)"},
318
{"18.7", "MySQL PHP API's"},
319
{"18.8", "MySQL C++ API's"},
320
{"18.9", "MySQL Python API's"},
321
{"18.10", "MySQL TCL API's"},
322
{"19", "How MySQL compares to other databases"},
323
{"19.1", "How MySQL compares to mSQL"},
324
{"19.1.1", "How to convert mSQL tools for MySQL"},
325
{"19.1.2", "How mSQL and MySQL client/server communications protocols differ"},
326
{"19.1.3", "How mSQL 2.0 SQL syntax differs from MySQL"},
327
{"19.2", "How MySQL compares to PostgreSQL"},
328
{"A", "Some users of MySQL"},
329
{"B", "Contributed programs"},
330
{"C", "Contributors to MySQL"},
331
{"D", "MySQL change history"},
332
{"19.3", "Changes in release 3.22.x (Alpha version)"},
333
{"19.3.1", "Changes in release 3.22.7"},
334
{"19.3.2", "Changes in release 3.22.6"},
335
{"19.3.3", "Changes in release 3.22.5"},
336
{"19.3.4", "Changes in release 3.22.4"},
337
{"19.3.5", "Changes in release 3.22.3"},
338
{"19.3.6", "Changes in release 3.22.2"},
339
{"19.3.7", "Changes in release 3.22.1"},
340
{"19.3.8", "Changes in release 3.22.0"},
341
{"19.4", "Changes in release 3.21.x"},
342
{"19.4.1", "Changes in release 3.21.33"},
343
{"19.4.2", "Changes in release 3.21.32"},
344
{"19.4.3", "Changes in release 3.21.31"},
345
{"19.4.4", "Changes in release 3.21.30"},
346
{"19.4.5", "Changes in release 3.21.29"},
347
{"19.4.6", "Changes in release 3.21.28"},
348
{"19.4.7", "Changes in release 3.21.27"},
349
{"19.4.8", "Changes in release 3.21.26"},
350
{"19.4.9", "Changes in release 3.21.25"},
351
{"19.4.10", "Changes in release 3.21.24"},
352
{"19.4.11", "Changes in release 3.21.23"},
353
{"19.4.12", "Changes in release 3.21.22"},
354
{"19.4.13", "Changes in release 3.21.21a"},
355
{"19.4.14", "Changes in release 3.21.21"},
356
{"19.4.15", "Changes in release 3.21.20"},
357
{"19.4.16", "Changes in release 3.21.19"},
358
{"19.4.17", "Changes in release 3.21.18"},
359
{"19.4.18", "Changes in release 3.21.17"},
360
{"19.4.19", "Changes in release 3.21.16"},
361
{"19.4.20", "Changes in release 3.21.15"},
362
{"19.4.21", "Changes in release 3.21.14b"},
363
{"19.4.22", "Changes in release 3.21.14a"},
364
{"19.4.23", "Changes in release 3.21.13"},
365
{"19.4.24", "Changes in release 3.21.12"},
366
{"19.4.25", "Changes in release 3.21.11"},
367
{"19.4.26", "Changes in release 3.21.10"},
368
{"19.4.27", "Changes in release 3.21.9"},
369
{"19.4.28", "Changes in release 3.21.8"},
370
{"19.4.29", "Changes in release 3.21.7"},
371
{"19.4.30", "Changes in release 3.21.6"},
372
{"19.4.31", "Changes in release 3.21.5"},
373
{"19.4.32", "Changes in release 3.21.4"},
374
{"19.4.33", "Changes in release 3.21.3"},
375
{"19.4.34", "Changes in release 3.21.2"},
376
{"19.4.35", "Changes in release 3.21.0"},
377
{"19.5", "Changes in release 3.20.x"},
378
{"19.5.1", "Changes in release 3.20.18"},
379
{"19.5.2", "Changes in release 3.20.17"},
380
{"19.5.3", "Changes in release 3.20.16"},
381
{"19.5.4", "Changes in release 3.20.15"},
382
{"19.5.5", "Changes in release 3.20.14"},
383
{"19.5.6", "Changes in release 3.20.13"},
384
{"19.5.7", "Changes in release 3.20.11"},
385
{"19.5.8", "Changes in release 3.20.10"},
386
{"19.5.9", "Changes in release 3.20.9"},
387
{"19.5.10", "Changes in release 3.20.8"},
388
{"19.5.11", "Changes in release 3.20.7"},
389
{"19.5.12", "Changes in release 3.20.6"},
390
{"19.5.13", "Changes in release 3.20.3"},
391
{"19.5.14", "Changes in release 3.20.0"},
392
{"19.6", "Changes in release 3.19.x"},
393
{"19.6.1", "Changes in release 3.19.5"},
394
{"19.6.2", "Changes in release 3.19.4"},
395
{"19.6.3", "Changes in release 3.19.3"},
396
{"E", "Known errors and design deficiencies in MySQL"},
397
{"F", "List of things we want to add to MySQL in the future (The TODO)"},
398
{"19.7", "Things that must done in the real near future"},
399
{"19.8", "Things that have to be done sometime"},
400
{"19.9", "Some things we don't have any plans to do"},
401
{"G", "Comments on porting to other systems"},
402
{"19.10", "Debugging MySQL"},
403
{"19.11", "Comments about RTS threads"},
404
{"19.12", "What is the difference between different thread packages?"},
405
{"H", "Description of MySQL regular expression syntax"},
406
{"I", "What is Unireg?"},
407
{"J", "The MySQL server license"},
408
{"K", "The MySQL license for Microsoft operating systems"},
409
{"*", "SQL command, type and function index"},
410
{"*", "Concept Index"}
414
const char *query[NQUERIES]={
415
"mysql information and manual",
416
"upgrading from previous version",
418
"against about after more right the with/without", /* stopwords test */
419
"mysql license and copyright"
added
removed
storage/myisam/ft_test1.h
