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 is supported?
  • 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
  • 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?
  • 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 mysql 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 get the unique ID for the last row?
  • What does mysql_use_result() do?
• Mysql Syntax
  • Literals. That is how are strings and numbers written?
  • 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.
  • CREATE INDEX syntax
  • DROP INDEX syntax
  • Is mysql picky about reserved words?
• Mysql Use
  • What does the executables do?
  • How can I use BLOB in the WHERE clause?
  • 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?
• Porting
  • What files must be changed when porting to another system ?
• ODBC
  • Which operating systems will mysql ODBC support?
  • How should I report problems with mysql ODBC?

This document was generated on 5 March 1997 using the texi2html translator version 1.51.