Oka SQL update command helpses plz...   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkTechnology - Talk Only Tech � Oka SQL update command helpses plz Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Void
Pilla Bewarse
Username: Void

Post Number: 3
Registered: 04-2005
Posted From: 210.8.224.2

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

Posted on Wednesday, April 13, 2005 - 1:09 am:Edit PostDelete PostView Post/Check IP

it is working in Access SQL for your data types.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1903
Registered: 03-2004
Posted From: 68.249.100.25

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

Posted on Wednesday, April 13, 2005 - 12:44 am:Edit PostDelete PostView Post/Check IP

:-O nee number evarikaada vundhi mama?

onetouch sql command tho solve kadhu ani selavu icharu ikada, (mySql)

so nenu php scripts raskoni set chesestha
Top of pagePrevious messageNext messageBottom of pageLink to this message

Schummy
Kurra Bewarse
Username: Schummy

Post Number: 871
Registered: 09-2004
Posted From: 68.49.139.186

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

Posted on Wednesday, April 13, 2005 - 12:35 am:Edit PostDelete PostView Post/Check IP

problem solve ayyandhaa

leka pothe call me
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1902
Registered: 03-2004
Posted From: 68.79.170.137

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

Posted on Wednesday, April 13, 2005 - 12:22 am:Edit PostDelete PostView Post/Check IP

there is data mismatch, id (int) value(varchar)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Void
Pilla Bewarse
Username: Void

Post Number: 2
Registered: 04-2005
Posted From: 210.8.224.4

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

Posted on Tuesday, April 12, 2005 - 11:33 pm:Edit PostDelete PostView Post/Check IP

it worked for me. check your columns are of same type and any data mismatch.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1900
Registered: 03-2004
Posted From: 68.251.102.139

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

Posted on Tuesday, April 12, 2005 - 11:22 pm:Edit PostDelete PostView Post/Check IP

>>
SQL-query:

UPDATE mos_core_acl_aro INNER JOIN mos_users ON mos_core_acl_aro.name = mos_users.name SET mos_core_acl_aro.[value] = [mos_users].[id]
MySQL said:

#1064 - You have an error in your SQL syntax near 'INNER JOIN mos_users ON mos_core_acl_aro.name = mos_users.name SET mos_core_acl_' at line 1

>>

ilaa kaadhu gaani, php scripts raskoni tables update chestha :-( :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1899
Registered: 03-2004
Posted From: 68.251.96.148

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

Posted on Tuesday, April 12, 2005 - 11:07 pm:Edit PostDelete PostView Post/Check IP

will try now and post the results

work aithei itnichie shopping ki veltha
Top of pagePrevious messageNext messageBottom of pageLink to this message

Void
Pilla Bewarse
Username: Void

Post Number: 1
Registered: 04-2005
Posted From: 210.8.224.2

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

Posted on Tuesday, April 12, 2005 - 11:02 pm:Edit PostDelete PostView Post/Check IP

UPDATE acro INNER JOIN users ON acro.name = users.name SET acro.[value] = [users].[id];

This should work.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1892
Registered: 03-2004
Posted From: 68.251.104.203

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

Posted on Tuesday, April 12, 2005 - 9:23 pm:Edit PostDelete PostView Post/Check IP

>>
Dei mama,

mysql doesnot support sub-queries in update statements....

>>

Ipdetaa :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Jackson
Celebrity Bewarse
Username: Jackson

Post Number: 8185
Registered: 03-2004
Posted From: 24.223.255.246

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

Posted on Tuesday, April 12, 2005 - 7:43 pm:Edit PostDelete PostView Post/Check IP

Ee thread lo emanna post cheyyachu kada Hemu mama..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5979
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:40 pm:Edit PostDelete PostView Post/Check IP

ardamaindi Jack mama, aa vere id lo rakunda TK mama thappu sesadu. nee yabha motham sarigga type sethee nee veellu emanna arigipothayaa.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Jackson
Celebrity Bewarse
Username: Jackson

Post Number: 8184
Registered: 03-2004
Posted From: 24.223.255.246

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

Posted on Tuesday, April 12, 2005 - 7:39 pm:Edit PostDelete PostView Post/Check IP

mama nenu adigindi okati nuvvu ardam chesukundi okati

sarle light teesko..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5978
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:38 pm:Edit PostDelete PostView Post/Check IP

TK mama di thappemundi, idharu thittukunnaru, thappoppulu naaku theliyadu, kani ammana bothulu start chesindi Brad maaya, kani TK andi K brothers annadu, adi ee K nooo naaku thelva, brad mama ki thagalalsina sota thagili thittadu, kani TK andi konidela anna annadu, ayina manakavasaramaa aa gola ippudu, nenu deniki vere id vadathano daniki sample seppa, nuvvu kelakka malla.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Jackson
Celebrity Bewarse
Username: Jackson

Post Number: 8182
Registered: 03-2004
Posted From: 24.223.255.246

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

Posted on Tuesday, April 12, 2005 - 7:36 pm:Edit PostDelete PostView Post/Check IP

Ante TK mama de tappu antava mama
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5977
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:36 pm:Edit PostDelete PostView Post/Check IP

attagee jack mama.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5976
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:35 pm:Edit PostDelete PostView Post/Check IP

naaku Brad mama seppadu aa vishayam, aaayana manchodu id tho vachi thittadu TK ni, TK id poyindi, kani brad mama id pola, denikante thittindi manchodu id tho gaa. lpapam TK pichi maa raju TK id tho thittadu vachi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Jackson
Celebrity Bewarse
Username: Jackson

Post Number: 8181
Registered: 03-2004
Posted From: 24.223.255.246

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

Posted on Tuesday, April 12, 2005 - 7:35 pm:Edit PostDelete PostView Post/Check IP

titte tappudu vere ID vaadu..

Migita appudu induloki vochei
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5975
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:34 pm:Edit PostDelete PostView Post/Check IP

Jack mama, ee id tho thitti dobbananuko, naa id podhi ma ATHADU time ki, andukee dasukunna.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Jackson
Celebrity Bewarse
Username: Jackson

Post Number: 8178
Registered: 03-2004
Posted From: 24.223.255.246

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

Posted on Tuesday, April 12, 2005 - 7:32 pm:Edit PostDelete PostView Post/Check IP

Hemanth mama nee ID poledaa

Happy to cyu in this ID..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5974
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 7:31 pm:Edit PostDelete PostView Post/Check IP

Just4fun mama ennallakennallaku, babai achiku demons elaa unnaru.

Top of pagePrevious messageNext messageBottom of pageLink to this message

Bhrigu
Mudiripoyina Bewarse
Username: Bhrigu

Post Number: 5473
Registered: 11-2004
Posted From: 69.228.253.113

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

Posted on Tuesday, April 12, 2005 - 7:13 pm:Edit PostDelete PostView Post/Check IP

J4F mama, daari thappaava ? :-O
Top of pagePrevious messageNext messageBottom of pageLink to this message

Just4fun
Pilla Bewarse
Username: Just4fun

Post Number: 381
Registered: 03-2004
Posted From: 68.192.144.180

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

Posted on Tuesday, April 12, 2005 - 6:53 pm:Edit PostDelete PostView Post/Check IP

ema korikalu ema katha ??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7374
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 6:46 pm:Edit PostDelete PostView Post/Check IP

vadilipoyindi peeda antha kuda......ello fun babai nee kosam fans iraga askings

evo korikalu aduguthunnaru soosipettochu kada?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Just4fun
Pilla Bewarse
Username: Just4fun

Post Number: 380
Registered: 03-2004
Posted From: 68.192.144.180

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

Posted on Tuesday, April 12, 2005 - 6:45 pm:Edit PostDelete PostView Post/Check IP

Dei mama,

mysql doesnot support sub-queries in update statements....
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3392
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 6:44 pm:Edit PostDelete PostView Post/Check IP

>>ayina danilo antha secret endo?

edaina propreitary emo.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 867
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 6:30 pm:Edit PostDelete PostView Post/Check IP

oracle ani seppadu kada? ayina danilo antha secret endo?

teleeka potjey gammuna vundu kada

sollu mama... pakka taadu lo post ki reply ivvu mama.. nee M ki salaam.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7366
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 6:27 pm:Edit PostDelete PostView Post/Check IP

oracle ani seppadu kada? ayina danilo antha secret endo?

techei nee korika neraveradu anduke reply ivvaledu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 856
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 6:11 pm:Edit PostDelete PostView Post/Check IP

I work on ANSI SQL implementation mama.. internals lo working.

nenu kuda certified ee. database offline lo chepta ley.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3374
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 6:10 pm:Edit PostDelete PostView Post/Check IP

how about ya?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 854
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 6:09 pm:Edit PostDelete PostView Post/Check IP

Oh fine...

Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3371
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 6:06 pm:Edit PostDelete PostView Post/Check IP

>>smarty nuvvu ee database lo pani chesedi...

MS SQL server

(I am an IBM DB2 certified)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 853
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 6:02 pm:Edit PostDelete PostView Post/Check IP

nenu mysql lo eppudu work cheyyaledu

smarty nuvvu ee database lo pani chesedi...

Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 852
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 6:00 pm:Edit PostDelete PostView Post/Check IP

sollu... neeku calling thread okati esa choodu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 851
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:58 pm:Edit PostDelete PostView Post/Check IP

echie babai mysql ki antha scene illio nenu eppudo 2 years back work sesinappudu ippudemanna vachesayemo teleedu kani adi just data storing ki thappa enduku paniki radu

Oh.. naku teldu.. ninnu boothulu dobba kada sorryey
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3370
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:48 pm:Edit PostDelete PostView Post/Check IP

nenu mysql lo eppudu work cheyyaledu

Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3369
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:46 pm:Edit PostDelete PostView Post/Check IP

>>Integer and char data type implicit conversion chesukovali kada Database annaka?

well, yes.
ikkada assali Dei emi cheyyalani choostunnado ardham chesukodaniki prayatnistunna

varchar lo int pettalsina panemundi?
edo saradaga pedutunnada?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7360
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:45 pm:Edit PostDelete PostView Post/Check IP

oye dei babu neeku answer sakkaga seppadu nee cols same kadu

techie babai mysql ki antha scene illio nenu eppudo 2 years back work sesinappudu ippudemanna vachesayemo teleedu kani adi just data storing ki thappa enduku paniki radu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3368
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:44 pm:Edit PostDelete PostView Post/Check IP

Dei mama,
nikoka dandam pedata.

champutunnavu mama, no wonder tech support guys hate their job.

sare gaani, ikkada execution lo error ledu, anta kante munde syntax lo error undi.
1064 relates to syntax errors.

check your syntax first.
copy the exact command that you are trying to run
Top of pagePrevious messageNext messageBottom of pageLink to this message

Hemanth
Celebrity Bewarse
Username: Hemanth

Post Number: 5973
Registered: 03-2004
Posted From: 24.136.225.83

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

Posted on Tuesday, April 12, 2005 - 5:44 pm:Edit PostDelete PostView Post/Check IP

mama, ippudee soosa, = avathala select statment peduthunav, appudu aa select emi return cheyyakapothee appudu problem ganda, NVL (select ...) anu. query motham soodala inka, ippude nerchukuntunna, ayina ee NVL di run time lo vasthundemo lee error. kiki.

idi kooda try seyy andaridi try sesav gaa.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 850
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:44 pm:Edit PostDelete PostView Post/Check IP

Dei mama,
chala gandaragolam create chestunnavu kada.

Value emo varchar ani define chesavu
id emo int ayipoye.

error emo poortiga pettochhu kada.
SQL syntax error vastondi, syntax sarigga check cheyyi,
before executing, 'check syntax' if that option exists.


Sollu and Smart mamalu: Integer and char data type implicit conversion chesukovali kada Database annaka?

Is oracle, MS SQL server dont do that?and MySQL also..

idem database bhai?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7359
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:43 pm:Edit PostDelete PostView Post/Check IP

sps ayithe ok boss queries ki kuda attane sesthunda? andulonu mysql lantivi sesthaya optimization gatra? antha illio...sesina appatikappude sesthadi.....

so eppudu nuvvu rasetappude baga rasthe e db meda esina baguntadi easyga
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3367
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:42 pm:Edit PostDelete PostView Post/Check IP

Dei mama andarito oka aata aadukuntunnadu.

Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1891
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:42 pm:Edit PostDelete PostView Post/Check IP

akkada vochina errors kuda pettina gadha mama

inka goram endhi antie Techie cheppina command ki

error emito thelsa: mos_users table dont exist :-O
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 849
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:42 pm:Edit PostDelete PostView Post/Check IP

FROM Table1 t, Table2 s
WHERE t.name = s.name

ila pedithe kallu moosukoni cross join chesi aa tharuvathe check chesthundi

inner join ayithe adi equal ayithene join kabatti time save avuthundi performance akkade vachedi

i hate to use cross joins


nee bonda.. adey mari.. ee Chettha ppp Database aa pani cheyyadu.. internally queries ni optimize/rewrite chesukoni.. proper join strategy use chestundi.. oka saari nuvvu pani chesey RDBMS manuals choodu:-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7358
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:41 pm:Edit PostDelete PostView Post/Check IP

antha avasaram ledu techie babai Ui lo cheyyochu le column type sanging

smart babai mana hero garu differnt types ni assign sesthunnadu ani kanipettindi nuvve kada
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 848
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:39 pm:Edit PostDelete PostView Post/Check IP

aa command edho type sesthei, paste cheskunta

mySQL lo drop column option and add column option vunda?

I donno mySQL syntax btw. :-)

generally ALTER table t1 drop column
add column column_type ani edchi vuntundi choodu.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3366
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:39 pm:Edit PostDelete PostView Post/Check IP

>>thanks to smart mama once again proving west coast rocks over east coast

nenu emi prove chesa ikkada
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1890
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:39 pm:Edit PostDelete PostView Post/Check IP

:-O

solution edhi?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7357
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:39 pm:Edit PostDelete PostView Post/Check IP

FROM Table1 t, Table2 s
WHERE t.name = s.name

ila pedithe kallu moosukoni cross join chesi aa tharuvathe check chesthundi

inner join ayithe adi equal ayithene join kabatti time save avuthundi performance akkade vachedi

i hate to use cross joins
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3365
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:37 pm:Edit PostDelete PostView Post/Check IP

Dei mama,
the solutions provided by a few people here should answer here problem unless you are doing something wrong but are overlooking it.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7356
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:37 pm:Edit PostDelete PostView Post/Check IP

anyway west coast rocks.....we solved it

thanks to smart mama once again proving west coast rocks over east coast
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1889
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:37 pm:Edit PostDelete PostView Post/Check IP

aa command edho type sesthei, paste cheskunta
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 847
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:36 pm:Edit PostDelete PostView Post/Check IP

avunu mysql lo inner joins work avuthaya? inner joins perform better than cross joins

yup... for small values it does not make difference..

but in this case we have a condition... database internally does the inner join... we call a query performed a CROSS JOIN when u dont have conditions on it.

something like, sel t1.x1, t2.x2 from t1,t2
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kaadu_nenu
Pilla Bewarse
Username: Kaadu_nenu

Post Number: 2
Registered: 04-2005
Posted From: 24.15.7.154

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

Posted on Tuesday, April 12, 2005 - 5:36 pm:Edit PostDelete PostView Post/Check IP

intamandi DB techhulu vunnaaraa ikkada......!!!!????
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7355
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:35 pm:Edit PostDelete PostView Post/Check IP

sesina boku pani saalu le.....value ki type marchi work pinish seyyi andaru seppinavi work avuthayi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7354
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:33 pm:Edit PostDelete PostView Post/Check IP

avunu mysql lo inner joins work avuthaya? inner joins perform better than cross joins
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1888
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:33 pm:Edit PostDelete PostView Post/Check IP

Sesinanu gandha,

anindhi kaabati, inka dhennei pattukoni kurchnna :-O

sarei night ki eskunta inko sari
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 846
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:33 pm:Edit PostDelete PostView Post/Check IP

avunu ehe :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3363
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:33 pm:Edit PostDelete PostView Post/Check IP

Dei mama,
chala gandaragolam create chestunnavu kada.

Value emo varchar ani define chesavu
id emo int ayipoye.

error emo poortiga pettochhu kada.
SQL syntax error vastondi, syntax sarigga check cheyyi,
before executing, 'check syntax' if that option exists.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 434
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 5:32 pm:Edit PostDelete PostView Post/Check IP

Deithadi garu, did you try this?

UPDATE Table1
SET Table1.id = s.value
FROM Table1 t, Table2 s
WHERE t.name = s.name
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1887
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:32 pm:Edit PostDelete PostView Post/Check IP

HM mama,

>>
UPDATE mos_core_acl_aro
SET mos_core_acl_aro.value = s.id
FROM mos_core_acl_aro t, mos_users s
WHERE t.name = s.name

>>

Is this equals to your syntax??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7352
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:31 pm:Edit PostDelete PostView Post/Check IP

bodi lingam oracle e kada? maaku telusu le
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7351
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:31 pm:Edit PostDelete PostView Post/Check IP

dei babu nenu last seppindi try sesava leda?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 844
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:29 pm:Edit PostDelete PostView Post/Check IP


UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = mos_users.id WHERE mos_users.name = mos_core_acl_aro.name
MySQL said:

#1109 - Unknown table 'mos_users' in where clause
>>


Oh.. got it.. mySQL database need FROM clause.. use the FROM clause then.. it should work as HM too mentioned it.

The query i mentioned was traditional one and it works in my RDBMS which dont want to name it here
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 433
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 5:27 pm:Edit PostDelete PostView Post/Check IP

I tested it now by creating sample tables. It is working fine 100%
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1886
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:27 pm:Edit PostDelete PostView Post/Check IP

Techie :-O

kochem hitech ga vuntadi ani sesa, seikuntei emi aithado chudu neevu ichina query:


>>
Error
SQL-query:

UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = mos_users.id WHERE mos_users.name = mos_core_acl_aro.name
MySQL said:

#1109 - Unknown table 'mos_users' in where clause
>>

Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 843
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:26 pm:Edit PostDelete PostView Post/Check IP

Deithadi garu, this is working perfectly.

UPDATE Table1
SET Table1.id = s.value
FROM Table1 t, Table2 s
WHERE t.name = s.name


yup it should work.. even without FROM clause it should work... i dont have mySQL.. but any RDBMs it should be fine.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 432
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 5:26 pm:Edit PostDelete PostView Post/Check IP

Try it immediately :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 431
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 5:25 pm:Edit PostDelete PostView Post/Check IP

Deithadi garu, this is working perfectly.

UPDATE Table1
SET Table1.id = s.value
FROM Table1 t, Table2 s
WHERE t.name = s.name
Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 841
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:23 pm:Edit PostDelete PostView Post/Check IP

die.. deeniki aa correlated subqueries, exists clasue avasaram ledu ehe.. oka simple inner join condition tho join chesi result teppiyyochu..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1885
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:21 pm:Edit PostDelete PostView Post/Check IP

table structures

for acro

for users

naa problem:

if mos_users.name equals to acro.name then update acro.value with user.id

I am using phpmyadmin to run sql commands

no other means possible even putty.

Top of pagePrevious messageNext messageBottom of pageLink to this message

Techie
Kurra Bewarse
Username: Techie

Post Number: 838
Registered: 03-2005
Posted From: 192.127.94.7

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

Posted on Tuesday, April 12, 2005 - 5:19 pm:Edit PostDelete PostView Post/Check IP

babu dei: idi try cheyyi

update t2
set y2 = t1.y1
where t1.x1 = t2.y2;
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7350
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 5:05 pm:Edit PostDelete PostView Post/Check IP

UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = mos_users.id FROM mos_users inner join mos_core_acl_aro ON
mos_users.name = mos_core_acl_aro.name )
Top of pagePrevious messageNext messageBottom of pageLink to this message

Smart
Mudiripoyina Bewarse
Username: Smart

Post Number: 3362
Registered: 03-2004
Posted From: 207.199.2.34

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

Posted on Tuesday, April 12, 2005 - 5:04 pm:Edit PostDelete PostView Post/Check IP

Dei mama,
ni tables structure specify cheyyi.

Explain what is the operation you need to do in plain english.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ramu
Mudiripoyina Bewarse
Username: Ramu

Post Number: 3615
Registered: 03-2004
Posted From: 199.244.214.30

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

Posted on Tuesday, April 12, 2005 - 5:03 pm:Edit PostDelete PostView Post/Check IP

pl/sql vADoccugA?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1884
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 5:01 pm:Edit PostDelete PostView Post/Check IP

nammakasthulu evaranna help chesi 'tha antie, night ki database login id pwd istha :-O

ipdu potha, nightout cheyali gadha, oka ganta
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1883
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:57 pm:Edit PostDelete PostView Post/Check IP

>>
Error
SQL-query:

UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = ( SELECT DISTINCT mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.name )
MySQL said:

#1064 - You have an error in your SQL syntax near 'SELECT distinct mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_' at line 1


>>
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7349
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 4:56 pm:Edit PostDelete PostView Post/Check IP

error emi ichindi?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1881
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:54 pm:Edit PostDelete PostView Post/Check IP

chesa with top 1 and distinct both

anindhi

ekkado edho fitting vundhi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7348
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 4:54 pm:Edit PostDelete PostView Post/Check IP

kushi babai it should work babai

update statement works for every row in the table meantioned after update key word

select lodi to just get the value and i'm explicitly saying to get only one value even if u have multiple values.....idi nenu chesanu ani gurthu babai ilage
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kushi_ram
Celebrity Bewarse
Username: Kushi_ram

Post Number: 8238
Registered: 04-2004
Posted From: 192.63.149.81

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

Posted on Tuesday, April 12, 2005 - 4:51 pm:Edit PostDelete PostView Post/Check IP

sollu mama dei mamaki anni rows update cheyyali where ever the names are matching.. .ne query only one row update chesthadi..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 430
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 4:51 pm:Edit PostDelete PostView Post/Check IP

I made a slight mistake w.r.to column names. Here is the correct statement, I cehcked it on sample tables .

UPDATE acro
SET acro.value = ( SELECT users.id
FROM users
WHERE users.name = acro.name)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7347
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 4:49 pm:Edit PostDelete PostView Post/Check IP

dei babai

UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = ( SELECT top 1 mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.name )

idi try seyyi leda top 1 badulu distinct try seyyi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kushi_ram
Celebrity Bewarse
Username: Kushi_ram

Post Number: 8237
Registered: 04-2004
Posted From: 192.63.149.81

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

Posted on Tuesday, April 12, 2005 - 4:49 pm:Edit PostDelete PostView Post/Check IP

UPDATE acro
SET acro.supplier_name = ( SELECT users.name
FROM users
WHERE users.name = acro.name)


HONEY MIST mama the query will return you multiple values and not single value anduke error vasthundi..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kushi_ram
Celebrity Bewarse
Username: Kushi_ram

Post Number: 8236
Registered: 04-2004
Posted From: 192.63.149.81

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

Posted on Tuesday, April 12, 2005 - 4:48 pm:Edit PostDelete PostView Post/Check IP

okka cursor lo USERS Table distinct rows select cheyyi based on the name.

Then for each unique name update the ACROS id with the user id for the matching name in the current cursor location.

Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 429
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 4:48 pm:Edit PostDelete PostView Post/Check IP

>>'users' table to id,name ani columns
'acro' table lo value, name ani columns

users.name = acro.name same values vunnai

users table to vunna id ni theskochi acro.value anei column lo petteyali where condition name=name


I worked on the similar condition and that was what I executed. Just try it out.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1880
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:47 pm:Edit PostDelete PostView Post/Check IP

Spit mama, dhaniki vachina error nee post kinda esa :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Honeymist
Pilla Bewarse
Username: Honeymist

Post Number: 428
Registered: 04-2004
Posted From: 66.237.36.130

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

Posted on Tuesday, April 12, 2005 - 4:46 pm:Edit PostDelete PostView Post/Check IP

I think this statement will do -

UPDATE acro
SET acro.supplier_name = ( SELECT users.name
FROM users
WHERE users.name = acro.name)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1879
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:46 pm:Edit PostDelete PostView Post/Check IP

>>
Error
SQL-query:

UPDATE mos_core_acl_aro SET mos_core_acl_aro.value = ( SELECT mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.name )
MySQL said:

#1064 - You have an error in your SQL syntax near 'SELECT mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.na' at line
>>

oka 12hrs ninchi ikkadei stuck ai vunna mama :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kushi_ram
Celebrity Bewarse
Username: Kushi_ram

Post Number: 8235
Registered: 04-2004
Posted From: 192.63.149.81

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

Posted on Tuesday, April 12, 2005 - 4:46 pm:Edit PostDelete PostView Post/Check IP

Dei mama okka chinna script rayi.. you have to open a cursor and do it.. Single query aithe possible kadu.. Emo mari SQL Gurus cheppali..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1878
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:45 pm:Edit PostDelete PostView Post/Check IP

anni rows mama, actually aa users table lo vunna ids ni nenu manual ga edit chesa ( i mean individual ga).

kaani aa acro table lo kuda same info vutadhi with some more columns. So name same aithei valli ids ni update cheseiyali annamta,

manual cheyali antie pagilipothadi, chana pedha table acro
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7346
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 4:43 pm:Edit PostDelete PostView Post/Check IP

yep exists akkaraledu work avvali
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kushi_ram
Celebrity Bewarse
Username: Kushi_ram

Post Number: 8234
Registered: 04-2004
Posted From: 192.63.149.81

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

Posted on Tuesday, April 12, 2005 - 4:42 pm:Edit PostDelete PostView Post/Check IP

mama do you want to update all the rows in the table X if some condition is satisfied in table Y
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1877
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:40 pm:Edit PostDelete PostView Post/Check IP

aa double selects endhuko naku thelvadu, sql reference ichadu gadha ani nenu petta

pettina pani chesthaledhu, thesena pani chesthaledu

syntax aithei naku thelsi right in mySQL
Top of pagePrevious messageNext messageBottom of pageLink to this message

Vetadutha
Pilla Bewarse
Username: Vetadutha

Post Number: 33
Registered: 06-2004
Posted From: 12.26.62.200

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

Posted on Tuesday, April 12, 2005 - 4:40 pm:Edit PostDelete PostView Post/Check IP

SET supplier_name = ( SELECT users.name
FROM users
WHERE users.name = acro.name)
WHERE EXISTS
( SELECT users.name
FROM users
WHERE users.name = acro.name);
>>>

Mamaaaa you dont need exists ..

use both table names in FROM clause which are used in JOIN
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1876
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:38 pm:Edit PostDelete PostView Post/Check IP

:-O:-O

>>UPDATE mos_core_acl_aro
SET mos_core_acl_aro.value = ( SELECT mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.name)
WHERE EXISTS
( SELECT mos_users.id
FROM mos_users
WHERE mos_users.name = mos_core_acl_aro.name);

>>

idhi original

meeku original thelsipothadi ani edho replace chessidaniki try chesa :-O:-O
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sollu
Celebrity Bewarse
Username: Sollu

Post Number: 7345
Registered: 03-2004
Posted From: 144.160.130.16

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

Posted on Tuesday, April 12, 2005 - 4:37 pm:Edit PostDelete PostView Post/Check IP

UPDATE acro
SET supplier_name = ( SELECT users.name
FROM users WHERE users.name = acro.name)


idemi query babu if acro.name = users.name malli select user.sname enti sendalamga?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Fargo
Yavvanam Kaatesina Bewarse
Username: Fargo

Post Number: 1376
Registered: 01-2005
Posted From: 64.83.223.150

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

Posted on Tuesday, April 12, 2005 - 4:35 pm:Edit PostDelete PostView Post/Check IP

EXists kaakunda users.name IN ani pettalemo
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1875
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:33 pm:Edit PostDelete PostView Post/Check IP

lep

lep

lep

deithadi pochammagudi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Deithadi
Celebrity Bewarse
Username: Deithadi

Post Number: 1873
Registered: 03-2004
Posted From: 149.166.96.215

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

Posted on Tuesday, April 12, 2005 - 4:29 pm:Edit PostDelete PostView Post/Check IP

naakada oka database lo users, acro ani two tables vundai :-O

'users' table to id,name ani columns
'acro' table lo value, name ani columns

users.name = acro.name same values vunnai

users table to vunna id ni theskochi acro.value anei column lo petteyali where condition name=name

:-O :-O :-O

>>>

UPDATE acro
SET supplier_name = ( SELECT users.name
FROM users
WHERE users.name = acro.name)
WHERE EXISTS
( SELECT users.name
FROM users
WHERE users.name = acro.name);
>>>

MySQL said:

#1064 - You have an error in your SQL syntax near 'SELECT users.name
FROM users
WHERE users.name = acro.name)
WHERE EXISTS
' at line 2