Access denied errors
SELECT and WHERE clauses
GROUP BY clauses
CREATE DATABASE syntax
DROP DATABASE syntax
CREATE TABLE syntax
ALTER TABLE syntax
OPTIMIZE TABLE syntax
DROP TABLE syntax
DELETE syntax
SELECT syntax
JOIN syntax
INSERT syntax
REPLACE syntax
LOAD DATA INFILE syntax
UPDATE syntax
USE syntax
FLUSH syntax (clearing caches)
KILL syntax
SHOW syntax (Get information about tables, columns,...)
EXPLAIN syntax (Get information about a SELECT)
DESCRIBE syntax (Get information about columns)
LOCK TABLES/UNLOCK TABLES syntax
SET OPTION syntax
GRANT and REVOKE syntax
CREATE INDEX syntax
DROP INDEX syntax
CREATE FUNCTION/DROP FUNCTION syntax
mysql in batch mode
WHERE clauses
LEFT JOIN
LIMIT
INSERT statements
DELETE statements
VARCHAR/CHAR be used?
MySQL with some common programs
MySQL server has gone away error
Can't connect to [local] MySQL server error
Host '...' is blocked error
Out of memory error
Packet too large error
The table is full error
Commands out of sync error in client
Ignoring user error
Table 'xxx' doesn't exist error
Access denied error
DATE columns
NULL values
alias
ALTER TABLE.
mysql_affected_rows()
mysql_close()
mysql_connect()
mysql_change_user()
mysql_create_db()
mysql_data_seek()
mysql_debug()
mysql_drop_db()
mysql_dump_debug_info()
mysql_eof()
mysql_errno()
mysql_error()
mysql_escape_string()
mysql_fetch_field()
mysql_fetch_fields()
mysql_fetch_field_direct()
mysql_fetch_lengths()
mysql_fetch_row()
mysql_field_count()
mysql_field_seek()
mysql_field_tell()
mysql_free_result()
mysql_get_client_info()
mysql_get_host_info()
mysql_get_proto_info()
mysql_get_server_info()
mysql_info()
mysql_init()
mysql_insert_id()
mysql_kill()
mysql_list_dbs()
mysql_list_fields()
mysql_list_processes()
mysql_list_tables()
mysql_num_fields()
mysql_num_rows()
mysql_options()
mysql_ping()
mysql_query()
mysql_real_connect()
mysql_real_query()
mysql_reload()
mysql_row_seek()
mysql_row_tell()
mysql_select_db()
mysql_shutdown()
mysql_stat()
mysql_store_result()
mysql_thread_id()
mysql_use_result()
mysql_query() returns success, mysql_store_result() sometimes returns NULL?
PHP and MySQL
This document was generated on 18 October 1999 using the texi2html translator version 1.52 (extended by davida@detron.se).