SQL: Storing data in a column

5 pts.
Tags:
SQL
Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    You would need to write a script or macro. I assume you are looking for something in C to be based off of the data being loaded to A and B. Unless we have more specific these values could be anything. like A=5 , B=10, C is 50 if this is a A*B scenario.

    If A=Ford, B=Mustang  then C=Car..

    How does the data relate to each other?
    131,380 pointsBadges:
    report
  • carlosdl
    We would need to know how you are inserting the data, to be able to explain why that happens and tell you how to avoid it.

    Please post the code you are running, and, just in case, let us know the database product you are using.
    84,630 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: