質問編集履歴
1
追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -25,3 +25,31 @@
|
|
|
25
25
|
|
|
26
26
|
|
|
27
27
|
よろしくお願いいたします。
|
|
28
|
+
|
|
29
|
+
|
|
30
|
+
|
|
31
|
+
「追記」
|
|
32
|
+
|
|
33
|
+
```テーブル定義
|
|
34
|
+
|
|
35
|
+
| table | CREATE TABLE `table` (
|
|
36
|
+
|
|
37
|
+
`column_nameA` mediumint(9) NOT NULL AUTO_INCREMENT,
|
|
38
|
+
|
|
39
|
+
`column_nameB` int(11) DEFAULT NULL,
|
|
40
|
+
|
|
41
|
+
`column_nameC` text,
|
|
42
|
+
|
|
43
|
+
`column_nameD` tinyint(1) DEFAULT '0',
|
|
44
|
+
|
|
45
|
+
`column_nameE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
46
|
+
|
|
47
|
+
`column_nameF` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
48
|
+
|
|
49
|
+
`column_nameG` int(11) DEFAULT NULL,
|
|
50
|
+
|
|
51
|
+
PRIMARY KEY (`column_nameA`)
|
|
52
|
+
|
|
53
|
+
) ENGINE=InnoDB AUTO_INCREMENT=598 DEFAULT CHARSET=utf8mb4 |
|
|
54
|
+
|
|
55
|
+
```
|