MySQL: Count records from one table and then update another

by

Use a subquery:

UPDATE nations 
   SET count = (
       SELECT COUNT(id) 
         FROM poets 
        WHERE poets.nation = nations.id 
        GROUP BY id
       );

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. How to SELECT the newest four items per category?
  3. Simple way to calculate median with MySQL
  4. Unioning two tables with different number of columns
  5. NULL in MySQL (Performance & Storage)
  6. MySQL function to find the number of working days between two dates
  7. MySQL Trigger to prevent INSERT under certain conditions
  8. MySQL “NOT IN” query
  9. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  10. Importance of varchar length in MySQL table
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. MySQL “between” clause not inclusive?
  14. MySQL syntax for Join Update
  15. SQL – How to transpose?
  16. SQL SELECT to get the first N positive integers
  17. Sorting string column containing numbers in SQL?
  18. Multiple Ranks in one table
  19. The difference between ‘AND’ and ‘&&’ in SQL
  20. How can I make an average of dates in MySQL?
  21. What is the best way to generate ranks in MYSQL?
  22. How do I list all the columns in a table?
  23. Two single-column indexes vs one two-column index in MySQL?
  24. VARCHAR as foreign key/primary key in database good or bad?
  25. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  26. How do I create a table alias in MySQL
  27. sql pulling a row for next or previous row of a current row
  28. Row Rank in a MySQL View
  29. Select Rows with Maximum Column Value group by Another Column
  30. mysql GROUP_CONCAT duplicates

Leave a Comment