質問編集履歴

2

文言修正

2019/09/08 12:39

投稿

jam912sh
jam912sh

スコア25

test CHANGED
File without changes
test CHANGED
@@ -30,7 +30,7 @@
30
30
 
31
31
  //idを降順に並び替えて1件のみをCSVにする
32
32
 
33
- $query = "COPY (SELECT * FROM test ORDER BY id LIMIT 1) TO '/var/www/html/web/csv/list.csv' CSV HEADER";
33
+ $query = "COPY (SELECT * FROM test ORDER BY id DESC LIMIT 1) TO '/var/www/html/web/csv/list.csv' CSV HEADER";
34
34
 
35
35
 
36
36
 

1

文言修正

2019/09/08 12:38

投稿

jam912sh
jam912sh

スコア25

test CHANGED
File without changes
test CHANGED
@@ -50,7 +50,7 @@
50
50
 
51
51
  ```php
52
52
 
53
- //idを降順に並び替えて1件のみをCSVにする
53
+ //idを1件のみをCSVにする
54
54
 
55
55
  $query = "COPY (SELECT * FROM test LIMIT 1) TO '/var/www/html/web/csv/list.csv' CSV HEADER";
56
56