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

[beedie]

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.

[Cosizzle]

It sounds like you want to look into something called 'Database Normalization' It uses ID's to associate one value in one table within another ID in another table

[bluejay002]

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,

[fenway]

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.

[bluejay002]

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.

[beedie]

This was so I could read directly from the database. Not a real world need unless my world is real?!? Oops off topic.

I realize the sum can be echoed out using php.