Menu
I wonder if the above can operate the column like the excel.
eg. same row. column 1 : A, column 2 : b, column 3 : A + b.
808
MySQL generated column's syntax First, specify the column name and its data type. Next, add the GENERATED ALWAYS clause to indicate that the column is a generated column. Then, indicate whether the type of the generated column by using the corresponding option: VIRTUAL or STORED .
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates.
Entering a formula in a database field. Choose Define Fields from the Layout menu. Select a field in the list or define a new field, choose Calculation or Summary from the pop-up menu, and click Create. If you're modifying a formula for an existing field, click Modify.
Store the equations in TEX or MATHML format in database[which will be basically strings]. Retrieve and render it on webpage using MathJax . Using MathJax equations can be rendered in many way, mainly - HTML-CSS,MathML and SVG.
You can't have columns that automatically contain some neighbouring cell's value or do some calculations with it.
However, in a mySQL query, you can do all the things Excel can, and much much more.
For example, to get the sum of two int fields:
SELECT column_a, column_b, (column_a + column_b) as total FROM tablename
However, looking at your other questions, I'm not sure whether mySQL is really what you are looking for. It sounds to me like you need an application just like Excel.
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
