update data into an empty table with the data from another table

I have two tables - XYZ (140 cols.) with no data and ABC (65 cols.) with data.

I need to wirte a sql query in such a way that the data certain cols. in table ABC gets updated into the table XYZ. I do have mapping for the columns. But, there is no Primary key in the first table (XYZ, which is created).

The table XYZ is just a skeleton with absolutely no data in it!

Appreciate the help!

Answers


Insert Into XYZ Select ABC.* From ABC;


Need Your Help

Android: why OnDateChange callback is called twice?

android callback datepicker

I'm working on an android app which at a point uses a DatePicker widget, butI've noticed that every time I try to change the date, the OnDateChange callback is called twice.

How to show gif into UIImageView in Swift?

animation swift gif ios8

I want use a gif in UIImageView, but I can't.

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.