表格數據導出一般格式為:
dbaccess databasename<<!
unload to 1.sql delimiter '|'
select "unload to ", tabname,"delimiter '#' select * from", tabname ,";"
from systables
where tabname not like "sys%" and tabtype="T"
!
dbaccess databasename 1.sql
正常的數據插入新表的格式為 insert into tabname select * from tabname_old? 不知道大俠是怎樣將語句組合起來的???