回答編集履歴
1
調整
test
CHANGED
|
@@ -5,6 +5,18 @@
|
|
|
5
5
|
|
|
6
6
|
|
|
7
7
|
```SQL
|
|
8
|
+
|
|
9
|
+
create table tbl(id int primary key ,name varchar(20),pref varchar(20));
|
|
10
|
+
|
|
11
|
+
insert into tbl values
|
|
12
|
+
|
|
13
|
+
(1,'みゆき','東京'),
|
|
14
|
+
|
|
15
|
+
(2,'あいこ','埼玉'),
|
|
16
|
+
|
|
17
|
+
(3,'さとし','神奈川');
|
|
18
|
+
|
|
19
|
+
|
|
8
20
|
|
|
9
21
|
update tbl set
|
|
10
22
|
|