Jump to content

[SOLVED] Can a table column be the result of two columns values?


Recommended Posts

If it is something about sum of other fields and displaying it... in Excel, you place this on a cell. In MySQL, I don't recommend it. Instead, you can use MySQL functions to do that... you can use SUM() or just simply use + for adding fields if not that complicated. :)

 

Jay,

Simple I think.

Like in an Excel database where a field can be the sum of other fields ho is this done in Mysql?

I don't see it.

The question is why.

 

It is rather how than why - "ho" missing "w" to make the statement correct.

 

And again, you do not need to add a field (as cell for excel) for MySQL to store sum, you just need to use + operator or SUM() function in the query, which ever you need, so you won't see it in MySQL naturally.

 

Excel is not a database in nature, but can be a database in context. MySQL is a database in nature and in context.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.