打开:brow
关闭:use
删除所有的数据:zap
删除点黑了的数据:pack
合并两个歌库文件的数据:append from ?
改字段:modi stru
改路径:repl file_loca with "D:\"+ID+".MP2" all
排序:sort to 1.dbf on lengthes,qindex asc/desc (asc 升序/desc 降序)
查找:brow for language="台语"
计算记录数:count for language="台语"
全部歌名数字都向左:repl lengthes with ltrim (lengthes) all
删除:dele
抽出歌曲:copy to vod1.dbf for file_loca="\\server3\data1"
改路径:repl sex with "F" for sex="HF"
在同一个歌库文件里提取不的相同的数据:select * from *.dbf group by id having count(id)>=1
在同一个歌库文件里提取相同的数据:select * from *.dbf group by id having count(id)=1
在同一个歌库文件里提取相同的数据:select * from *.dbf group by id having count(id)>=2
——
(文件名)
移动文件: move 1.mpg abc
---- ----- ---
(移动) (文件名) (存放目的文件夹)
拷贝0-2400条记录+路径:list off "copy "+file_loca for recn()<=2400 to copy1.bat
拷贝2400-4800条记录+路径:list off "copy "+file_loca for recn()>=2400 and recn()<=4800 to copy2.bat
对比三个字段:update 2 set d="o" where singname in (sele singname from 1)
update 2 set d1="k" where singer in (sele singer from 1)
brow for d="o" and d1="k"
update dd.dbf set ff="t" where id in (select id from 4000)