Access denied Errors
SELECT and WHERE Clauses
GROUP BY Clauses
CREATE DATABASE Syntax
DROP DATABASE Syntax
CREATE TABLE Syntax
ALTER TABLE Syntax
RENAME TABLE Syntax
DROP TABLE Syntax
OPTIMIZE TABLE Syntax
CHECK TABLE Syntax
BACKUP TABLE syntax
RESTORE TABLE syntax
ANALYZE TABLE syntax
REPAIR TABLE syntax
DELETE syntax
TRUNCATE 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)
BEGIN/COMMIT/ROLLBACK syntax
LOCK TABLES/UNLOCK TABLES syntax
SET syntax
GRANT and REVOKE syntax
CREATE INDEX syntax
DROP INDEX syntax
CREATE FUNCTION/DROP FUNCTION syntax
mysql in batch mode
SELECT queries
WHERE clauses
DISTINCT
LEFT JOIN and RIGHT JOIN
LIMIT
INSERT queries
UPDATE queries
DELETE queries
MySQL server has gone away error
Can't connect to [local] MySQL server error
Host '...' is blocked error
Too many connections error
Out of memory error
Packet too large error
The table is full error
Can't create/write to file 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_character_set_name()
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_escape_string()
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 November 2000 using the texi2html translator version 1.52 (extended by davida@detron.se).