質問編集履歴

create文の追記

2018/05/18 11:19

投稿

wakahiro

スコア20

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -343,3 +343,97 @@
 お手数ですが、よろしくお願いします。
+追記create形式
+```SQL
+MariaDB [test]> create table user(
+    ->     id int unsigned not null auto_increment,
+    ->     name varchar(50),
+    ->     old int unsigned,
+    ->     primary key (id)
+    -> ) engine=InnoDB;
+Query OK, 0 rows affected (0.11 sec)
+MariaDB [test]> create table plan(
+    ->     id int unsigned not null auto_increment,
+    ->     name varchar(50),
+    ->     main_time int unsigned,
+    ->     primary key (id)
+    -> ) engine=InnoDB;
+Query OK, 0 rows affected (0.01 sec)
+MariaDB [test]> create table play_task(
+    ->     id int unsigned not null auto_increment,
+    ->     play_day date,
+    ->     user_id int unsigned ,
+    ->     plan_id int unsigned ,
+    ->     primary key (id),
+    ->     foreign key(user_id) references user(id)
+    ->     on update cascade on delete cascade ,
+    ->     foreign key(plan_id) references plan(id)
+    ->     on update cascade on delete cascade
+    -> ) engine=InnoDB;
+Query OK, 0 rows affected (0.01 sec)
+MariaDB [test]> create table amount_day(
+    ->     id int unsigned not null auto_increment,
+    ->     amount_day date,
+    ->     APLAN int unsigned ,
+    ->     APLANcount int unsigned ,
+    ->     BPLAN int unsigned ,
+    ->     BPLANcount int unsigned ,
+    ->     CPLAN int unsigned ,
+    ->     CPLANcmount int unsigned ,
+    ->     primary key (id)
+    ->
+    -> ) engine=InnoDB;
+Query OK, 0 rows affected (0.01 sec)
+```