初学sql  用的软件是 postgreSQL ;输入 
COPY coupleVille FROM 'C:/Users/yucong/Documents/Downloads/bd1/coupleVille.dat' WITH DELIMITER ',' ; 
出现错误  ERROR: could not open file "C:/Users/yucong/Documents/Downloads/bd1/spectacle.dat" for reading: Permission denied 
État SQL :42501 
为什么我没有权限打开阿  怎么办啊  拜托回答一下阿

解决方案 »

  1.   


    mysql> source D:/bbs.sql
    Query OK, 1 row affected (0.20 sec)Database changed
    Query OK, 0 rows affected (0.89 sec)Query OK, 7 rows affected (0.13 sec)
    Records: 7  Duplicates: 0  Warnings: 0mysql> use bbs1;
    Database changed
    mysql> show tables;
    +----------------+
    | Tables_in_bbs1 |
    +----------------+
    | article        |
    +----------------+
    1 row in set (0.30 sec)mysql> select * from article;
    +----+-----+--------+--------------------------------------+
    | id | pid | isleaf | cont                                 |
    +----+-----+--------+--------------------------------------+
    |  0 |  -1 |      0 | 我想报考****学院,这个学校怎么样啊? |
    |  1 |   0 |      0 | 垃圾,很小一个学校                   |
    |  2 |   1 |      1 | 你才垃圾,你牛逼啊, 人家好坏也是.... |
    |  3 |   0 |      0 | 在,,,还是比较不错的               |
    |  4 |   3 |      0 | 说的没错                             |
    |  5 |   4 |      1 | 我支持                               |
    |  6 |   4 |      1 | 我也支持                             |
    +----+-----+--------+--------------------------------------+
    7 rows in set (0.06 sec)