Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. **query** **query_insert**
  2. 1 query_id 1 id
  3. 2 query_cons 2 query_id
  4. 3 title 3 *insert_date*
  5. 4 name 4 insert_time
  6. 5.............
  7. ...........
  8. .....
  9. 9 *current_status*
  10. 10 return_date
  11.  
  12. $result= mysql_query("SELECT query_insert.*, query.*
  13. FROM query_insert,query
  14. WHERE query_insert.insert_date=$today &&
  15. query.current_status='Fresh' ");
  16.  
  17. $result= mysql_query("SELECT query_insert.*, query.*
  18. FROM query_insert
  19. LEFT JOIN query
  20. ON query.query_id = query_insert.query_id
  21. WHERE query_insert.insert_date=$today &&
  22. query.current_status='Fresh' ");
  23.  
  24. SELECT * FROM query q
  25. INNER JOIN query_insert qi ON q.query_id = qi.query_id
  26. WHERE insert_date = CURRENT_DATE()
  27. AND current_status = 'Fresh'
  28.  
  29. SELECT *
  30. FROM query q
  31. JOIN query_insert i
  32. ON q.id = i.query_id
  33. WHERE q.current_status = 'Fresh'
  34. AND i.insert_date = now()
  35.  
  36. SELECT *
  37. FROM query q
  38. WHERE EXISTS(
  39. SELECT 'insert'
  40. FROM query_insert i
  41. WHERE q.id = i.query_id
  42. AND i.insert_date = now()
  43. )
  44. AND q.current_status = 'Fresh'
  45.  
  46. $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