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 Peter Leow 160
1 Mika Wendelius 156
2 Abhinav S 155
3 TheRealSteveJudge 139
4 Sergey Alexandrovich Kryukov 115
0 Sergey Alexandrovich Kryukov 8,513
1 OriginalGriff 6,526
2 Peter Leow 3,727
3 Zoltán Zörgő 3,426
4 Richard MacCutchan 2,417


Advertise | Privacy | Mobile
Web03 | 2.8.150123.1 | Last Updated 25 Apr 2013
Copyright © CodeProject, 1999-2015
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