Is it possible to select and insert its result in MySQL?

I have a table that needs to be updated with another table. Can I make a Select command to insert the data found on another table? If so, how?

I use MySQL

Answers


insert into table1
(Column1, Column2)
select Column1, Column2
from table2

Need Your Help

Add messages with Spring

java spring spring-mvc

I have seen that I can add errors and render them via <form:errors /> tag and addError() method of BindingResult class, but I wonder if there is something similar to send information messages...

Can a Generic Method handle both Reference and Nullable Value types?

c# .net generics

I have a series of Extension methods to help with null-checking on IDataRecord objects, which I'm currently implementing like this:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.