Select data from another table during insert

<>

This question already has an answer here:

Answers


Use insert . . . select instead of insert . . . values:

insert into table2 
    select null, 12, max(odate), 0
    from table1;

As a note: you should get in the habit of including the column names in the insert() statement.


Need Your Help

Can I set the GLSL version?

java opengl shader lwjgl

I'm trying to figure out if I can set the GLSL version used in OpenGL 2.1. So far it works with some generic immediate mode shaders, but I'd like to use modern OpenGL shaders. Any ideas on how I can?

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.