2015/5/5 mysql command line export data

Export database: Mysqldump-u username-P database name > exported file name as I entered the command line: Mysqldump-u root-p ygeshop > Ygeshop.sql (Input will allow you to enter the password to MySQL) (if the Guide If you have a single table, enter a table name after the database name)

Mysqldump-uroot-hlocalhost-p54321-p qrcms > Qrcms.sql

Specify Port Login:

Mysql-uroot-hlocalhost-p54321-p

Import SQL Error:

Inquire:

CREATE TABLE ' T_book ' (

' ID ' bigint (a) not NULL auto_increment,

' short_name ' varchar (+) DEFAULT NULL COMMENT ' abbreviation ',

' Name ' varchar (+) DEFAULT NULL COMMENT ' book name ',

' Summary ' text COMMENT ' book profile ',

' Author ' varchar (+) DEFAULT NULL COMMENT ' author ',

' Press_name ' varchar (+) DEFAULT NULL COMMENT ' publisher ',

' press_time ' varchar DEFAULT ' current_timestamp ' COMMENT ' publication Time ',

' Qr_code_url ' varchar (4000) DEFAULT NULL COMMENT ' QR code image address ',

' Press_rev ' varchar (+) DEFAULT NULL COMMENT ' Edition ',

' Word_count ' varchar ($) DEFAULT NULL COMMENT ' word count ',

' Price ' varchar (+) DEFAULT NULL COMMENT ' Amount ',

' Price_unit ' varchar ($) DEFAULT NULL COMMENT ' Amount unit ',

' Press_num ' varchar ($) DEFAULT NULL COMMENT ' printing times ',

' Press_paper ' varchar ($) DEFAULT NULL COMMENT ' printing paper ',

' Language ' varchar ($) DEFAULT NULL COMMENT ' language ',

' page_numbers ' varchar ($) DEFAULT NULL COMMENT ' pages ',

' Folio ' varchar ($) DEFAULT NULL COMMENT ' folio ',

' Create_time ' timestamp NULL DEFAULT current_timestamp,

' Create_user ' bigint () DEFAULT NULL,

' Modify_time ' timestamp NULL DEFAULT current_timestamp,

' Modify_user ' bigint () DEFAULT NULL,

' Cover_url ' varchar (+) DEFAULT NULL COMMENT ' cover map address ',

' is_effect ' varchar DEFAULT NULL COMMENT ' is in effect: 1: Effective, 2: invalid, 3: Saved, 4: In Approval ',

' Module ' bigint (+) DEFAULT ' 1 ',

PRIMARY KEY (' id ')

) Engine=innodb auto_increment=18 DEFAULT charset=utf8 comment= ' Book table '

Error Place: 2015-05-05 15:35:39

Line number: 111

Error code: 1293-incorrect table definition; There can is only one TIMESTAMP column with Current_timestamp in DEFAULT or on UPDATE clause

Why always have such code, the name of the method of what can not be unified, to find the problem will be pit to good;

HTML5 Video does not play the remote connected videos files;

Browser Play video support is limited, MP4 format of video only support the video of H.

Video encoding: AVC1-built-in FFmpeg decoder (H264) can be played;

Video encoding: MP4V-built-in FFmpeg decoder (MPEG4) can not play, the example is in this format;

Finally used this https://html5media.info/.

2015/5/5 mysql command line export data