Member Avatar for BabaRoro

Is it possible to select values from 2 columns in order to calculate another column in the database table?

  • 2 Contributors
  • 1 Reply
  • 206 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Yes, you can, just select and use the + operator:

select `column_a`, `column_b`, `column_a` + `column_b` as `column_c` from `table_name`;

Live example: http://sqlfiddle.com/#!9/935da4/1

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.