Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **query** **query_insert**
- 1 query_id 1 id
- 2 query_cons 2 query_id
- 3 title 3 *insert_date*
- 4 name 4 insert_time
- 5.............
- ...........
- .....
- 9 *current_status*
- 10 return_date
- $result= mysql_query("SELECT query_insert.*, query.*
- FROM query_insert,query
- WHERE query_insert.insert_date=$today &&
- query.current_status='Fresh' ");
- $result= mysql_query("SELECT query_insert.*, query.*
- FROM query_insert
- LEFT JOIN query
- ON query.query_id = query_insert.query_id
- WHERE query_insert.insert_date=$today &&
- query.current_status='Fresh' ");
- SELECT * FROM query q
- INNER JOIN query_insert qi ON q.query_id = qi.query_id
- WHERE insert_date = CURRENT_DATE()
- AND current_status = 'Fresh'
- SELECT *
- FROM query q
- JOIN query_insert i
- ON q.id = i.query_id
- WHERE q.current_status = 'Fresh'
- AND i.insert_date = now()
- SELECT *
- FROM query q
- WHERE EXISTS(
- SELECT 'insert'
- FROM query_insert i
- WHERE q.id = i.query_id
- AND i.insert_date = now()
- )
- AND q.current_status = 'Fresh'
- $result= mysql_query("SELECT query_insert.*, query.* FROM query_insert,query WHERE query_insert.insert_date=$today AND query.current_status='Fresh' ");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement