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
syntax
GRANT
and REVOKE
syntax
CREATE INDEX
syntax
DROP INDEX
syntax
CREATE FUNCTION/DROP FUNCTION
syntax
mysql
in batch mode
MySQL
with some common programs
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
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 6 March 2000 using the texi2html translator version 1.52 (extended by davida@detron.se).