用SQL语句进行数据库备份和恢复

use xscj;            #XSCJ是数据库名

select * from kc                                                         #kc是表名

   into outfile 'd:/file/myfile1.txt'                                   #  '  ' 里的是备份地址，txt

  fields  terminated by ','                                             #  每项数据之间用英文的逗号隔开

   optionally enclosed by '"'                                         #  如果数据为字符就用双引号标出

  lines terminated by '?';                                              #  每行用问号做结束标志