初学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
为什么我没有权限打开阿 怎么办啊 拜托回答一下阿
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
为什么我没有权限打开阿 怎么办啊 拜托回答一下阿
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)