Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2009 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 09, 2009 * Sql query heop < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6036
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:30 pm:    Edit Post Delete Post View Post/Check IP
byaakup ante table ni printout theesi ettukunnaaremo pda baa//

goochi baa
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 59039
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:26 pm:    Edit Post Delete Post View Post/Check IP
byaakup ante table ni printout theesi ettukunnaaremo pda baa...nuvvu mee officelo lekka as usual tapes maarchatam anukuni manodi setha column lepicchaav
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6032
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:05 pm:    Edit Post Delete Post View Post/Check IP
backup ante evadanna aa table ni copy sesi inko name tho save chettaru..tamaru em chesaru.. ippudu aa table lo data ni subquery raasi kotta table lo column ni update cheyyochu aa subquery nunchi//

almost iyyindhi lee baaa...inko 10 field vunnay anthee
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25666
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:05 pm:    Edit Post Delete Post View Post/Check IP
//mysql

manaki telavadi
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25665
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:04 pm:    Edit Post Delete Post View Post/Check IP
backup ante evadanna aa table ni copy sesi inko name tho save chettaru..tamaru em chesaru.. ippudu aa table lo data ni subquery raasi kotta table lo column ni update cheyyochu aa subquery nunchi
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6029
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:03 pm:    Edit Post Delete Post View Post/Check IP
mysql.....phpmyadmin vaaduthunna
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25664
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:02 pm:    Edit Post Delete Post View Post/Check IP
intaki em database? naaku first di kooda ayyindi sample table meeda test sette
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6026
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:00 pm:    Edit Post Delete Post View Post/Check IP
backup vundhi ante choosi ekkinchataaki.......import cheyyataaki kaadhu
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6025
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 3:00 pm:    Edit Post Delete Post View Post/Check IP
nee devasam back up vundi annav gaa dannunchi subquery raasi update chesi savochu gaa.. naa punyam antava//

eendhi upload cheesedhi....akkada column loo okka field motham leechindhi.....aa okka field ni etta import setham
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25662
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 2:58 pm:    Edit Post Delete Post View Post/Check IP
//baa nee punyama ani aa column loo vunna 70 rows leechaayi

nee devasam back up vundi annav gaa dannunchi subquery raasi update chesi savochu gaa.. naa punyam antava
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6024
Registered: 03-2008
Posted From: 129.22.149.97

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 2:57 pm:    Edit Post Delete Post View Post/Check IP
bussu ga intaki sql di emayyindo seppi savaledu//

baa nee punyama ani aa column loo vunna 70 rows leechaayi.....kurchooni manual gaa enter sethunnaa...


manchipani chesav lee....oka 1hr extra raasukovacchu ee week
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 59038
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 2:43 pm:    Edit Post Delete Post View Post/Check IP
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25643
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 11:58 am:    Edit Post Delete Post View Post/Check IP
ala jaruguddi emo ani doubt gane esa.. aithe rendodi try cheyyi..100% work avuddi
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6016
Registered: 03-2008
Posted From: 129.22.73.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 11:56 am:    Edit Post Delete Post View Post/Check IP
first dhi try chesthe column motham leechindhi...

malla fields populate chesthunna......backup vundhi lee
Best Upcoming Bewarse Award Winner for 2008
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25641
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 11:49 am:    Edit Post Delete Post View Post/Check IP
adi avvakapothe idi try cheyyi

ALTER TABLE tableA
ADD C1 datatype

UPDATE tableA
set C1 = county_name || ' county';

ALTER TABLE tableA
DROP COLUMN county_name

ALTER TABLE tableA
RENAME COLUMN C1 to county_name;
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Pda
Bewarse Legend
Username: Pda

Post Number: 25640
Registered: 06-2006
Posted From: 129.138.250.120

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 11:43 am:    Edit Post Delete Post View Post/Check IP
UPDATE tableA
set tableA.county_name = tableA.county_name || ' county';

column length soosuko mundu .. 6 chars xtra add chestunnav kada
I AM LEGEND
Top of pagePrevious messageNext messageBottom of page Link to this message

Rangupadudhi
Celebrity Bewarse
Username: Rangupadudhi

Post Number: 6015
Registered: 03-2008
Posted From: 129.22.73.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 05, 2009 - 11:33 am:    Edit Post Delete Post View Post/Check IP
ippudu naa dhaggara ohio counties table vundhi

three fields vuntaayi...id,name, stateid

right now the "name" column has the names of the counties..example cuyahoga, franklin etc.

I have to update all the fields in the "name" column to cuyahoga county, franklin county

ante literal gaa prathi name field last loo "space county" ani include cheyyali....
Best Upcoming Bewarse Award Winner for 2008

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration