回答編集履歴
1
変更
test
CHANGED
|
@@ -20,7 +20,9 @@
|
|
|
20
20
|
|
|
21
21
|
|message_no|message_to_member_no|message_from_member_no|message_honbun|member_no|member_id|member_name
|
|
22
22
|
|
|
23
|
-
|:--|:--:|--:|
|
|
23
|
+
|:--|:--:|--:|
|
|
24
|
+
|
|
25
|
+
4|4|1|honbun4|1|1|name1
|
|
24
26
|
|
|
25
27
|
2|1|3|honbun2|1|1|name1
|
|
26
28
|
|
|
@@ -42,7 +44,7 @@
|
|
|
42
44
|
|
|
43
45
|
create table `member` (`member_id` int,`member_no` text, `member_name` text);
|
|
44
46
|
|
|
45
|
-
insert into `message` values(1,1,'2','honbun1'),(2,1,'3','honbun2'),(3,2,'4','honbun3');
|
|
47
|
+
insert into `message` values(1,'1','2','honbun1'),(2,'1','3','honbun2'),(3,'2','4','honbun3'),(4,'4','1','honbun4');
|
|
46
48
|
|
|
47
49
|
select * from message;
|
|
48
50
|
|