一般用mysql的函数now()就可以了
$sql = "insert into tbl_name (date) values (now())";也可以用php的时间
$t = date("Y-m-d H:i:s");
$sql = "insert into tbl_name (date) values ('$t')";
$sql = "insert into tbl_name (date) values (now())";也可以用php的时间
$t = date("Y-m-d H:i:s");
$sql = "insert into tbl_name (date) values ('$t')";
mysql_query($sql);
$sql="CREATE TABLE FORUM_TABLE_NAME(
name varchar(20),datetime DATETIME(),//??
manager varchar(20),PRIMARY KEY (name),UNIQUE id (name))";
[table_options] [select_statement]create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
or FULLTEXT [INDEX] [index_name] (index_col_name,...)
or [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...)
[reference_definition]
or CHECK (expr)type:
TINYINT[(length)] [UNSIGNED] [ZEROFILL]
or SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
or MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
or DATETIME