|
| Extending MySQL | |
| | |
|
| |
| Common questions and problems when using the C API | |
| | |
|
| |
| C API Function Descriptions | |
| | |
|
| |
| MySQL Internals | |
| This chapter describes a lot of things that you need to know when working on the MySQL code. | |
|
| |
| MySQL Java Connectivity (JDBC) | |
| | |
|
| |
| Installation Related Issues | |
| Problems When Linking with the MySQL Client Library | |
|
| |
| Administration Related Issues | |
| What To Do If MySQL Keeps Crashing | |
|
| |
| MySQL C++ APIs | |
| Two APIs are available in the MySQL Contrib directory | |
|
| |
| Table Definition Related Issues | |
| Problems with ALTER TABLE.
ALTER TABLE changes a table to the current character set. If you during ALTER TABLE get a duplicate key error, then the cause is either that the new character sets maps to keys to the same value or that the table is corrupted, in which case you should run REPAIR TABLE on the table.
| |
|
| |
| Some Common Errors When Using MySQL | |
| This section lists some errors that users frequently get. You will find descriptions of the errors, and how to solve the problem here. | |
|
| |
| Query Related Issues | |
| Case Sensitivity in Searches | |
|
| |
| How to Get the Value of an AUTO_INCREMENT Column in ODBC | |
| A common problem is how to get the value of an automatically generated ID from an INSERT. With ODBC, you can do something like this (assuming that auto is an AUTO_INCREMENT field): | |
|
| |
| Building Client Programs | |
| If you compile MySQL clients that you've written yourself or that you obtain from a third party, they must be linked using the -lmysqlclient -lz option on the link command. You may also need to specify a -L option to tell the linker where to find the library. For example, if the library is installed in `/usr/local/mysql/lib', use -L/usr/local/mysql/lib -lmysqlclient -lz on the link command. | |
|
| |
| Reporting Problems with MyODBC | |
| If you encounter difficulties with MyODBC, you should start by making a log file from the ODBC manager (the log you get when requesting logs from ODBCADMIN) and a MyODBC log | |
|
| |
| C API Datatypes | |
| This structure represents a handle to one database connection. It is used for almost all MySQL functions. | |
|
| |
| Common questions and problems when using the C API | |
| Why Is It that After mysql_query() Returns Success, mysql_store_result() Sometimes Returns NULL? | |
|
| |
| MySQL C API | |
| The C API code is distributed with MySQL. It is included in the mysqlclient library and allows C programs to access a database. | |
|
| |
| Programs Known to Work with MyODBC | |
| Most programs should work with MyODBC, but for each of those listed below, we have tested it ourselves or received confirmation from some user that it works | |
|
| |
| Threaded Function Descriptions | |
| You need to use the following functions when you want to create a threaded client. See section 8.4.7 How to Make a Threaded Client | |
|
| |
