Select from same table as an Insert or Update

by

try:

insert into aTable select max(a)^2, 'name' from aTable;

or

insert into aTable select max(a)^2, 'name' from aTable group by B;

If you need a join, you can do this:

insert into aTable select max(a)^2, 'name' from aTable, bTable;

My “Server version” is “5.0.51b-community-nt MySQL Community Edition (GPL)”

More Related Contents:

  1. SQL DELETE with JOIN another table for WHERE condition
  2. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  3. SQL UPDATE with sub-query that references the same table in MySQL
  4. Deleting a row based on the max value
  5. Insert and set value with max()+1 problems
  6. Which DB technology is sued to solve the following search issue? [closed]
  7. Delete the entire content of all table in a Database [closed]
  8. MySQL pivot row into dynamic number of columns
  9. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  10. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  11. MySQL – Operand should contain 1 column(s)
  12. How to get the difference in years from two different dates?
  13. Restore table structure from frm and ibd files
  14. mysql pivot/crosstab query
  15. MySQL: Split comma separated list into multiple rows
  16. UNION query with codeigniter’s active record pattern
  17. Mysql Convert Column to row (Pivot table )
  18. Merge two tables in one SQL query and make the date values unique
  19. Remove Primary Key in MySQL
  20. Get most recent row for given ID
  21. Is merge statement available in MySQL
  22. Mysql covering vs composite vs column index
  23. Mysql insert random datetime in a given datetime range
  24. Greatest value of multiple columns with column name?
  25. MySQL UPDATE syntax with multiple tables using WHERE clause
  26. INSERT INTO or UPDATE with two conditions
  27. Calculating time difference between 2 dates in minutes
  28. mysql – Dynamic column alias
  29. “Unknown column in ‘field list'”, but column does exist
  30. Optimistic locking in MySQL

Leave a Comment