Click here to Skip to main content
11,634,568 members (75,173 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 8,736
1 Sergey Alexandrovich Kryukov 8,359
2 Mika Wendelius 6,845
3 F-ES Sitecore 2,354
4 Suvendu Shekhar Giri 2,205


Advertise | Privacy | Mobile
Web01 | 2.8.150728.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