|
|
|
|
|
|
|
|
|
|
|
|
|
|
今天给客户导数据,内容表100万条记录,表字段不到100个。用程序分批导。
由于标识列 id 里的值有用,所以在导入时把id改为了不自增。导完后,再加为自增列时,提示超时。
用语句 alter table rcms_contents alter column [id] bigint identity(1,1) 修改,在sql08下提示语法错误。
标注:rcms_contents为源表;content为临时表
于是上网查,解决了。方法如下:
1、先把数据加到临时表里,一会儿会用到 select * into content from rcms_contents
2、先加一列id_1设为自增列 alter table rcms_contents add id_1 bigint identity(1,1)
3、(一定要备份数据库)然后把源表里的数据删掉 truncate table rcms_contents
4、打开此表设计,把id列改为自增,保存表
5、执行 set identity_insert rcms_contents on (可更改标识列)
6、设置表rcms_contents列id_1可以为空
7、用 insert into rcms_contents(字段) select 字段 from content 从临时表里进行导入数据
8、把可更改标识列的值关闭,执行 set identity_insert rcms_contents off
9、删除rcms_contents的id_1
这样就大功告成了。数据库方面还要再加强。
vlcPlayer是一款免费开源的播放器项目,可以播放几乎所有的视频格式。
|
|
Usage: vlc [options] [stream] …
You can specify multiple streams on the commandline. They will be enqueued in the playlist.
The first item specified will be played first.
Options-styles:
–option A global option that is set for the duration of the program.
-option A single letter version of a global –option.
:option An option that only applies to the stream directly before it
and that overrides previous settings.
Stream MRL syntax:
[[access][/demux]://]URL[@[title][:chapter][-[title][:chapter]]] [:option=value …]
Many of the global –options can also be used as MRL specific :options.
Multiple :option=value pairs can be specified.
URL syntax:
[file://]filename Plain media file
http://ip:port/file HTTP URL
ftp://ip:port/file FTP URL
mms://ip:port/file MMS URL
screen:// Screen capture
[dvd://][device][@raw_device] DVD device
[vcd://][device] VCD device
[cdda://][device] Audio CD device
udp:[[
UDP stream sent by a streaming server
vlc:pause:
vlc:quit Special item to quit VLC
|
|
tag:
缺失模块。
1、请确保node版本大于6.2
2、在博客根目录(注意不是yilia根目录)执行以下命令:
npm i hexo-generator-json-content --save
3、在根目录_config.yml里添加配置:
jsonContent: meta: false pages: false posts: title: true date: true path: true text: false raw: false content: false slug: false updated: false comments: false link: false permalink: false excerpt: false categories: false tags: true