Mysql command line data export, 2015 mysql

Mysql command line data export, 2015 mysql

Export Database: mysqldump-u user name-p Database Name> export file name, as shown in the command line I entered: mysqldump-u root-p ygeshop> ygeshop. SQL (you will be asked to enter the MySQL password after the input) (if you export a single table, enter the table name after the database name)

Mysqldump-uroot-hlocalhost-P54321-p qrcms> qrcms. SQL

Specify port Logon:

Mysql-uroot-hlocalhost-P54321-p

Import SQL error:

Query:

Create table 't_ Book '(

'Id' bigint (20) not null AUTO_INCREMENT,

'Short _ name' varchar (2000) default null comment' abbreviation ',

'Name' varchar (2000) default null comment' book name ',

'Summary 'text comment' book introduction ',

'Author' varchar (2000) default null comment' author ',

'Press _ name' varchar (2000) default null comment' press ',

'Press _ time' varchar (20) DEFAULT 'current _ TIMESTAMP 'comment' publication time ',

'Qr _ code_url 'varchar (4000) default null comment 'qr code image address ',

'Press _ rev' varchar (2000) default null comment 'moderate ',

'Word _ count' varchar (200) default null comment 'wordcount ',

'Price' varchar (200) default null comment 'ant ',

'Price _ unit 'varchar (200) default null comment 'amount unit ',

'Press _ num' varchar (200) default null comment 'print times ',

'Press _ paper 'varchar (200) default null comment 'paper output ',

'Language 'varchar (200) default null comment' language ',

'Page _ numbers 'varchar (200) default null comment 'page ',

'Folio' varchar (200) default null comment' open local ',

'Create _ time' timestamp null default CURRENT_TIMESTAMP,

'Create _ user' bigint (20) default null,

'Modify _ time' timestamp null default CURRENT_TIMESTAMP,

'Modify _ user' bigint (20) default null,

'Cover _ url' varchar (2000) default null comment 'Cover image address ',

'Is _ effect 'varchar (45) default null comment': 1: valid; 2: Invalid; 3: saved; 4: Under Approval ',

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

Primary key ('id ')

) ENGINE = InnoDB AUTO_INCREMENT = 18 default charset = utf8 COMMENT = 'books table'

Error: 15:35:39

Row: 111

Error code: 1293-Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or on update clause

Why is there always such code? Why can't the naming of methods be uniform? Is it okay to find a problem;

HTML5 video cannot play remotely connected video files;

The browser only supports video playback. MP4 videos only support H.264 videos;

Video Encoding: AVC1-built-in FFmpeg Decoder (h264) for playback;

Video Encoding: mp4v-built-in FFmpeg Decoder (mpeg4) cannot be played. This format is used in this example;

Finally used this https://html5media.info/