Click here to Skip to main content
11,706,639 members (32,445 online)
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 26-Feb-13 23:03pm
angel94243
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 146
1 Sergey Alexandrovich Kryukov 115
2 chainerlt 110
3 Mika Wendelius 80
4 ppolymorphe 71
0 OriginalGriff 9,190
1 Sergey Alexandrovich Kryukov 8,407
2 CPallini 5,189
3 Maciej Los 4,756
4 Mika Wendelius 3,686


Advertise | Privacy | Mobile
Web04 | 2.8.150819.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