14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→ideas
m (→Query by month) |
m (→ideas) |
||
| Line 128: | Line 128: | ||
* approach 1: (1) '''select *''' under some condition, (2) collect the $identifiers which matched the condition. and then (3) select some records '''NOT IN ( $identifiers ) ''' | * approach 1: (1) '''select *''' under some condition, (2) collect the $identifiers which matched the condition. and then (3) select some records '''NOT IN ( $identifiers ) ''' | ||
* approach 2: (1) '''select *''' and then (2) '''unset''' some records which matched the condition. | * approach 2: (1) '''select *''' and then (2) '''unset''' some records which matched the condition. | ||
== debug == | |||
[[SQL syntax debug]] | |||
== references == | == references == | ||