-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathsql.txt
More file actions
16 lines (16 loc) · 913 Bytes
/
Copy pathsql.txt
File metadata and controls
16 lines (16 loc) · 913 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
select aaa,bbb,ccc from table
select aaa,bbb,ccc from table where key1=12
select aaa,bbb,ccc from table where col1=12
select aaa,bbb,ccc from table where col1=12 or col1="hello"
select aaa,bbb,ccc from table where col1=12 and col2=12
select aaa,bbb,ccc from table where col1=12 or col2="hello"
Select aaa,bbb,ccc from table where col1<=12
Select aaa,bbb,ccc from table where col1<=12 or col1>="hello"
Select aaa,bbb,ccc from table where col1<=12 and col1>="hello"
Select aaa,bbb,ccc from table where key1=12
Select aaa,bbb,ccc from table where key1=12 and key2="hello"
Select aaa,bbb,ccc from table where key1=12 or key1="hello"
Select aaa,bbb,ccc from table where key1=12 and key2="hello" and Col1=-45
Select aaa,bbb,ccc from table where key1=true and Col1=-45
Select aaa,bbb,ccc from table where key1=12 and (key2="hello" or Col1=-45)
Select aaa,bbb,ccc from table where (key1=12 and key2="hello") and Col1=-45