Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL PHP
I have a table with 3 coulmns say id, column1, column2, column3.
i want to add column1 and column2 values by importing.
i need colum3 as formule ( just like in excel)
Column3=column1+column2.
i want to column3 automatically get added and displayed while importing column1 and column2.
here id will be auto incremental( hope no issue for this extra column).
Please suggest me how to do in phpmyadmin
Posted 27-Feb-13 0:03am
angel94242
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

hi
 

try this query,
 
Select Id, Column1,Column2, Column1+Column2 as Column3 from tablename
 

 
regards,
Prakash.T
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

can i use any stored procedure here?
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 290
1 Jochen Arndt 150
2 Kornfeld Eliyahu Peter 149
3 PIEBALDconsult 110
4 Richard MacCutchan 105
0 OriginalGriff 6,080
1 DamithSL 4,648
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,624
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 25 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100