~drizzle-trunk/drizzle/development : revision 76.1.1

1

2

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.

6

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.

11

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 */

15

16

/* Written by Sergei A. Golubchik, who has a shared copyright to this code */

17

18

#define NUPD 20

19

#define NDATAS 389

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"},

106

{"5.2.6", "Views"},

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"}

411

};

412

413

#define NQUERIES 5

414

const char *query[NQUERIES]={

415

"mysql information and manual",

416

"upgrading from previous version",

417

"column indexes",

418

"against about after more right the with/without", /* stopwords test */

419

"mysql license and copyright"

420

};