mysql创建表,默认系统当前时间
Jun 06, 2016 am 09:39 AMmysql
CREATE TABLE tmp_webservice_sql_log
(ID
INT(10) NOT NULL AUTO_INCREMENT,SEND_DATA_TIME
DATETIME DEFAULT NULL,SEND_STATE
VARCHAR(10) DEFAULT NULL,INTER_NAME
VARCHAR(100) NOT NULL,CREATE_TIME
DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,QUERY_SQL
TEXT,SEND_JSON
LONGTEXT,RETURN_JSON
VARCHAR(2000) DEFAULT NULL,SYS
TINYINT(2) DEFAULT NULL,
PRIMARY KEY (ID
,INTER_NAME
,CREATE_TIME
)
) ENGINE=INNODB AUTO_INCREMENT=343 DEFAULT CHARSET=utf8
create_time 字段和 QUERY_SQL字段SEND_JSON字段 报错

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP?

What are the application scenarios of Java enumeration types in databases?

How to insert data into a MySQL table using PHP?

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP?

Performance optimization strategies for PHP array paging
