回答編集履歴

1

chousei

2019/10/02 08:09

投稿

yambejp
yambejp

スコア116694

test CHANGED
@@ -4,7 +4,13 @@
4
4
 
5
5
  ```SQL
6
6
 
7
+ create table users(
8
+
9
+ id int primary key auto_increment,
10
+
7
- create table users(id int primary key auto_increment,name varchar(10) collate utf8mb4_unicode_ci );
11
+ name varchar(10) collate utf8mb4_unicode_ci
12
+
13
+ );
8
14
 
9
15
  insert into users(name) values
10
16
 
@@ -32,7 +38,11 @@
32
38
 
33
39
  ```SQL
34
40
 
41
+ select * from users
42
+
35
- select * from users order by case when name regexp '^[a-z]' then 1 else 2 end desc,name asc;
43
+ order by case when name regexp '^[a-z]' then 1 else 2 end desc,
44
+
45
+ name asc;
36
46
 
37
47
 
38
48