beedie Posted August 27, 2008 Share Posted August 27, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/ Share on other sites More sharing options...
Cosizzle Posted August 27, 2008 Share Posted August 27, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/#findComment-626674 Share on other sites More sharing options...
bluejay002 Posted August 27, 2008 Share Posted August 27, 2008 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, Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/#findComment-626678 Share on other sites More sharing options...
fenway Posted August 27, 2008 Share Posted August 27, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/#findComment-626875 Share on other sites More sharing options...
bluejay002 Posted August 28, 2008 Share Posted August 28, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/#findComment-627491 Share on other sites More sharing options...
beedie Posted September 1, 2008 Author Share Posted September 1, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/121518-solved-can-a-table-column-be-the-result-of-two-columns-values/#findComment-631423 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.