Frequently Asked Questions about MySQL.

• Introduction
• Absolutely Important
  • Subscribing to/un-subscribing from the MySQL mailing list.
  • Asking questions or reporting bugs.
  • Guidelines for answering questions on the mailing list.
• General Information
  • What is MySQL?
  • History of MySQL
  • What is the current MySQL version?
  • How do I get MySQL?
  • Should I get MySQL in source form or binary?
  • Which operating systems does MySQL support?
  • Which languages does MySQL support.
  • How/when will you release updates?
  • What is UNIREG ?
• Licensing. When do I have to pay for MySQL?
  • How much does MySQL cost?
  • How do I get support
  • How do I pay for a licence?
  • Who do I contact when I want support/a licence?
  • What Copyright does MySQL use?
  • When may I distribute MySQL commercially without a fee
  • I'm selling a product that can be configured to use MySQL
  • I am running a commercial web server using MySQL.
  • Possible future changes in the licensing.
• Features of MySQL
  • Main features of MySQL
  • What column (column) types are available with MySQL?
  • What is a BLOB?
  • What extension has MySQL to ANSI SQL?
• Compiling and installing MySQL
  • Compiling MySQL
  • Problems starting MySQL
  • Automatic start/stop of MySQL
• Compatibility
  • What functionality is missing in MySQL.
  • How about msql tools like msql-tcl, msqljava?
  • How different from mSQL are the MySQL client/server communications protocols?
  • What are the differences in the SQL syntax between MySQL & mSQL 2.0?
  • Problems with AND and OR priority
  • What standards do MySQL follow
  • What functions exist only for compability?
• Optimizations
  • How does MySQL use memory ?
  • How should I arrange my table to be as fast/small as possible.
  • What factors MySQL insert statement speeds.
  • What kind of optimization is done on the WHERE clause?
  • How can I change the buffer sizes of mysqld ?
  • What options to use to get mysqld to run at full speed?
  • What is the different row formats? Or when to use VARCHAR/CHAR?
• MySQL C API
  • After mysql_query() returns success, mysql_store_result() sometimes returns NULL.
  • What results can I get from a query?
  • How can I get the unique ID for the last row?
  • What is the difference between mysql_use_result() and mysql_store_result() modes?
• MySQL Syntax
  • Literals. How do you write strings and numbers?
  • CREATE TABLE syntax.
  • ALTER TABLE syntax
  • DROP TABLE syntax.
  • DELETE syntax.
  • SELECT syntax
  • INSERT syntax
  • LOAD DATA INFILE syntax
  • UPDATE syntax
  • SHOW syntax. Get information about names of columns.
  • DESCRIBE syntax. Get information about names of columns.
  • SET OPTION syntax.
  • GRANT syntax. (Compability function).
  • CREATE INDEX syntax (Compability function).
  • DROP INDEX syntax (Compability function).
  • Is MySQL picky about reserved words?
• MySQL Use
  • What does the executables do?
  • Limitations of BLOB's
  • How do you check/repair/reconstruct an MySQL table?
  • How to get a description of a table.
  • How does the privilege system work?
  • Adding new user privileges to MySQL
  • Default privileges.
  • A example of permission setup.
  • Can I install MySQL without root access?
  • Why so many open tables?
• Adding functionality to mysql
  • Adding new functions to MySQL
• Porting
  • What files must be changed when porting to another system ?
• ODBC
  • Which operating systems does MySQL ODBC support?
  • How should I report problems with MySQL ODBC?
  • How do I fill in the various fields in the ODBC administrator program.
• Problems
  • Why do I get 'Access denied'?
  • Problems using DATE fields.

This document was generated on 12 May 1997 using the texi2html translator version 1.51.