質問編集履歴
1
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,8 +1,8 @@
|
|
|
1
1
|
```SQL
|
|
2
2
|
|
|
3
|
-
select `name_tb`.*, `Jyusyo`.`jyusyu1`, `Jyusyo`.`jyusyu2`, `birthday`.`birthday_hiduke`, CONCAT(name_tb.myoji , ' ', name_tb.namae) as namae, CONCAT(name_tb.myoji_kana , ' ', name_tb.namae_kana) as kana, CONCAT(Jyusyo.jyusyu1 , ' ', Jyusyo.jyusyu2) as jusho, date_format( name_tb.updated_at,'%Y-%m-%d') as hiduke from `NameTable` name_tb left join `Jyusyo` on `Jyusyo`.`name_id` = `
|
|
3
|
+
select `name_tb`.*, `Jyusyo`.`jyusyu1`, `Jyusyo`.`jyusyu2`, `birthday`.`birthday_hiduke`, CONCAT(name_tb.myoji , ' ', name_tb.namae) as namae, CONCAT(name_tb.myoji_kana , ' ', name_tb.namae_kana) as kana, CONCAT(Jyusyo.jyusyu1 , ' ', Jyusyo.jyusyu2) as jusho, date_format( name_tb.updated_at,'%Y-%m-%d') as hiduke from `NameTable` name_tb left join `Jyusyo` on `Jyusyo`.`name_id` = `name_tb`.`namae_id` left join `birthday` on `birthday`.`namae_id` = `name_tb`.`namae_id` where not exists (
|
|
4
4
|
|
|
5
|
-
select * from `NameTable` where `namae_id`=name_tb.namae_id and `created_at` >
|
|
5
|
+
select * from `NameTable` where `namae_id`=name_tb.namae_id and `created_at` > name_tb.`created_at`
|
|
6
6
|
|
|
7
7
|
) and `name_tb`.`id` = 1
|
|
8
8
|
|