PHP笔记1

下面的词在 MySQL 中是被明确保留的。它们大多数被 ANSI SQL92 禁止作为列或表名(例如， GROUP)。一些被保留是因为 MySQL 需要它们并且它使用的是一个 yacc 语法分析器： 

单词	单词	单词
ADD	ALL	ALTER
ANALYZE	AND	AS
ASC	AUTO_INCREMENT	BDB
BEFORE	BERKELEYDB	BETWEEN
BIGINT	BINARY	BLOB
BOTH	BTREE	BY
CASCADE	CASE	CHANGE
CHAR	CHARACTER	CHECK
COLLATE	COLUMN	COLUMNS
CONSTRAINT	CREATE	CROSS
CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP
DATABASE	DATABASES	DAY_HOUR
DAY_MINUTE	DAY_SECOND	DEC
DECIMAL	DEFAULT	DELAYED
DELETE	DESC	DESCRIBE
DISTINCT	DISTINCTROW	DIV
DOUBLE	DROP	ELSE
ENCLOSED	ERRORS	ESCAPED
EXISTS	EXPLAIN	FALSE
FIELDS	FLOAT	FOR
FORCE	FOREIGN	FROM
FULLTEXT	FUNCTION	GRANT
GROUP	HASH	HAVING
HIGH_PRIORITY	HOUR_MINUTE	HOUR_SECOND
IF	IGNORE	IN
INDEX	INFILE	INNER
INNODB	INSERT	INT
INTEGER	INTERVAL	INTO
IS	JOIN	KEY
KEYS	KILL	LEADING
LEFT	LIKE	LIMIT
LINES	LOAD	LOCALTIME
LOCALTIMESTAMP	LOCK	LONG
LONGBLOB	LONGTEXT	LOW_PRIORITY
MASTER_SERVER_ID	MATCH	MEDIUMBLOB
MEDIUMINT	MEDIUMTEXT	MIDDLEINT
MINUTE_SECOND	MOD	MRG_MYISAM
NATURAL	NOT	NULL
NUMERIC	ON	OPTIMIZE
OPTION	OPTIONALLY	OR
ORDER	OUTER	OUTFILE
PRECISION	PRIMARY	PRIVILEGES
PROCEDURE	PURGE	READ
REAL	REFERENCES	REGEXP
RENAME	REPLACE	REQUIRE
RESTRICT	RETURNS	REVOKE
RIGHT	RLIKE	RTREE
SELECT	SET	SHOW
SMALLINT	SOME	SONAME
SPATIAL	SQL_BIG_RESULT	SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT	SSL	STARTING
STRAIGHT_JOIN	STRIPED	TABLE
TABLES	TERMINATED	THEN
TINYBLOB	TINYINT	TINYTEXT
TO	TRAILING	TRUE
TYPES	UNION	UNIQUE
UNLOCK	UNSIGNED	UPDATE
USAGE	USE	USER_RESOURCES
USING	VALUES	VARBINARY
VARCHAR	VARCHARACTER	VARYING
WARNINGS	WHEN	WHERE
WITH	WRITE	XOR
YEAR_MONTH	ZEROFILL
以下的符号(来自上表)是被 ANSI SQL 禁止的，但是可以被 MySQL 用于列/表名。这是由于用他们命名是很自然的并且有很多的人已经使用了它们。
· ACTION
· BIT
· DATE
· ENUM
· NO
· TEXT
· TIME
· TIMESTAMP

最简单的PHP上传案例          PHP连接MYSQL的方法和代码

<?php

//connect database,select database;

$link = mysql_connect('localhost','root','zzzzzz')

    or die('could not connect:' . mysql_error());

echo 'conected successfully';

mysql_select_db('mysql') or die('Could not select database');

//执行SQL查询

$query='select * from user';

$result= mysql_query($query) or die('Query failed:' . mysql_error()) ;

//用HTML显示结果

echo "<table>\n";

while ($line =mysql_fetch_array($result,MYSQL_ASSOC)){

    echo "\t<tr>\n";

    foreach($line as $col_value){

        echo"\t\t<td>$col_value</td>\n";

        }

        echo "\t</tr>\n";

        }

echo "</table>\n";

//释放数据集

mysql_free_result($result);

//关闭连接

mysql_close($link);

?>