Solved

MySQL Select Insert with a constant field

Posted on 2008-06-22
2
1,881 Views
Last Modified: 2008-08-17
I have an SQL querty which works great:-

insert into myTable select * from otherTable;

but what Id like to do is insert another column which is constant, so something like

insert into myTable `firstColumnValue' select * from other table.

Does this make sence?
0
Comment
Question by:tonelm54
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:tonelm54
ID: 21840601
So in the first query the result would inserts:-
Col1      Col2      Col3      Col4      Col5
--------------------------------------------------------------------------------------------------------------------------
value11      value12      value13      value14      value15
value21      value22      value23      value24      value25
value31      value32      value33      value34      value35
value41      value42      value43      value44      value45
value51      value52      value53      value54      value55
value61      value62      value63      value64      value65
value71      value72      value73      value74      value75

The second Id like to insert:-
Col1      Col2      Col3      Col4      Col5      Col6
--------------------------------------------------------------------------------------------------------------------------myConstValue      value11      value12      value13      value14      value15
myConstValue      value21      value22      value23      value24      value25
myConstValue      value31      value32      value33      value34      value35
myConstValue      value41      value42      value43      value44      value45
myConstValue      value51      value52      value53      value54      value55
myConstValue      value61      value62      value63      value64      value65
myConstValue      value71      value72      value73      value74      value75
0
 
LVL 3

Accepted Solution

by:
jagmohan_gunwant earned 500 total points
ID: 21840709
Hello Friend
For this Purpose of inserting a constant value in a column in another table you have to specify all the columns in the destination table and the constant column with the columns and source columns keeping in mind the field mapping which you have to connsider, threfore your insert query should be as follows:

Insert Into <DestinationTable> (Col1, Col2, COl3, Col4, Col5)
Select 'myConstValue' as Col1, Col2, Col3, Col4, Col5 
From <SourceTableName>

Open in new window

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
I have many tables and one main one, how can I take there column names from the main one? 3 54
mysql disables rename 4 103
Very Large data in MYSQL 7 94
mysql qry 1 25
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question