Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 26th, 2012  |  syntax: None  |  size: 0.53 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How do I multiple select in mysql using one query?
  2. Select Id,Name From table where id = var
  3. Select Id,Name From table where id = var
  4. Select Id,Name From table where id = var
  5.        
  6. SELECT  (
  7.     SELECT COUNT(*)
  8.     FROM   user_table
  9.     ) AS tot_user,
  10.     (
  11.     SELECT COUNT(*)
  12.     FROM   cat_table
  13.     ) AS tot_cat,
  14.     (
  15.     SELECT COUNT(*)
  16.     FROM   course_table
  17.     ) AS tot_course
  18.        
  19. SELECT user_table.name, user_table.email, cat_table.title
  20. FROM user_table
  21. FULL JOIN cat_table
  22. ON user_table.cat_id=cat_table.id
  23. ORDER BY user_table.id