| Author |
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: |    |
it is working in Access SQL for your data types. |
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: | |
 nee number evarikaada vundhi mama?
onetouch sql command tho solve kadhu ani selavu icharu ikada, (mySql)
so nenu php scripts raskoni set chesestha |
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: | |
problem solve ayyandhaa
leka pothe call me
|
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: | |
there is data mismatch, id (int) value(varchar) |
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: | |
it worked for me. check your columns are of same type and any data mismatch. |
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: | |
>>
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  |
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: | |
will try now and post the results
work aithei itnichie shopping ki veltha |
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: | |
UPDATE acro INNER JOIN users ON acro.name = users.name SET acro.[value] = [users].[id];
This should work. |
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: | |
>>
Dei mama,
mysql doesnot support sub-queries in update statements....
>>
Ipdetaa |
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: | |
Ee thread lo emanna post cheyyachu kada Hemu mama.. |
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: | |
ardamaindi Jack mama, aa vere id lo rakunda TK mama thappu sesadu.  nee yabha motham sarigga type sethee nee veellu emanna arigipothayaa. |
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: | |
mama nenu adigindi okati nuvvu ardam chesukundi okati
sarle light teesko.. |
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: | |
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. |
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: | |
Ante TK mama de tappu antava mama |
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: | |
attagee jack mama. |
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: | |
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. |
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: | |
titte tappudu vere ID vaadu..
Migita appudu induloki vochei |
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: | |
Jack mama, ee id tho thitti dobbananuko, naa id podhi ma ATHADU time ki, andukee dasukunna. |
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: | |
Hemanth mama nee ID poledaa
Happy to cyu in this ID.. |
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: | |
Just4fun mama  ennallakennallaku, babai achiku demons elaa unnaru.
|
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: | |
J4F mama, daari thappaava ? |
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: | |
ema korikalu ema katha ?? |
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: | |
vadilipoyindi peeda antha kuda......ello fun babai nee kosam fans iraga askings
evo korikalu aduguthunnaru soosipettochu kada? |
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: | |
Dei mama,
mysql doesnot support sub-queries in update statements.... |
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: | |
>>ayina danilo antha secret endo?
edaina propreitary emo. |
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: | |
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. |
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: | |
oracle ani seppadu kada? ayina danilo antha secret endo?
techei nee korika neraveradu anduke reply ivvaledu |
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: | |
I work on ANSI SQL implementation mama.. internals lo working.
nenu kuda certified ee. database offline lo chepta ley. |
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: | |
how about ya? |
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: | |
Oh fine...
|
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: | |
>>smarty nuvvu ee database lo pani chesedi...
MS SQL server
(I am an IBM DB2 certified) |
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: | |
nenu mysql lo eppudu work cheyyaledu
smarty nuvvu ee database lo pani chesedi...
|
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: | |
sollu... neeku calling thread okati esa choodu  |
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: | |
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 |
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: | |
nenu mysql lo eppudu work cheyyaledu
|
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: | |
>>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? |
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: | |
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 |
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: | |
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 |
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: | |
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. |
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: | |
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?  |
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: | |
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 |
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: | |
Dei mama andarito oka aata aadukuntunnadu.
|
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: | |
akkada vochina errors kuda pettina gadha mama
inka goram endhi antie Techie cheppina command ki
error emito thelsa: mos_users table dont exist |
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: | |
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
|
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: | |
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 |
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: | |
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.
|
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: | |
>>thanks to smart mama once again proving west coast rocks over east coast
nenu emi prove chesa ikkada 
|
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: | |
solution edhi? |
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: | |
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
|
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: | |
Dei mama,
the solutions provided by a few people here should answer here problem unless you are doing something wrong but are overlooking it. |
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: | |
anyway west coast rocks.....we solved it
thanks to smart mama once again proving west coast rocks over east coast |
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: | |
aa command edho type sesthei, paste cheskunta  |
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: | |
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 |
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: | |
intamandi DB techhulu vunnaaraa ikkada......!!!!???? |
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: | |
sesina boku pani saalu le.....value ki type marchi work pinish seyyi andaru seppinavi work avuthayi |
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: | |
avunu mysql lo inner joins work avuthaya? inner joins perform better than cross joins
|
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: | |
Sesinanu gandha,
••••• anindhi kaabati, inka dhennei pattukoni kurchnna
sarei night ki eskunta inko sari |
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: | |
avunu ehe |
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: | |
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.
|
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: | |
Deithadi garu, did you try this?
UPDATE Table1
SET Table1.id = s.value
FROM Table1 t, Table2 s
WHERE t.name = s.name |
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: | |
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?? |
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: | |
bodi lingam oracle e kada? maaku telusu le |
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: | |
dei babu nenu last seppindi try sesava leda? |
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: | |
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 |
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: | |
I tested it now by creating sample tables. It is working fine 100% |
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: | |
Techie ••••
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
>>
|
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: | |
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. |
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: | |
Try it immediately |
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: | |
Deithadi garu, this is working perfectly.
UPDATE Table1
SET Table1.id = s.value
FROM Table1 t, Table2 s
WHERE t.name = s.name
|
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: | |
die.. deeniki aa correlated subqueries, exists clasue avasaram ledu ehe.. oka simple inner join condition tho join chesi result teppiyyochu.. |
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: | |
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.
|
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: | |
babu dei: idi try cheyyi
update t2
set y2 = t1.y1
where t1.x1 = t2.y2;
|
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: | |
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 ) |
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: | |
Dei mama,
ni tables structure specify cheyyi.
Explain what is the operation you need to do in plain english. |
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: | |
pl/sql vADoccugA? |
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: | |
nammakasthulu evaranna help chesi •••••'tha antie, night ki database login id pwd istha
ipdu potha, nightout cheyali gadha, oka ganta ••••• |
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: | |
>>
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
>> |
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: | |
error emi ichindi? |
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: | |
chesa with top 1 and distinct both
••••• anindhi
ekkado edho fitting vundhi. |
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: | |
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 |
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: | |
sollu mama dei mamaki anni rows update cheyyali where ever the names are matching.. .ne query only one row update chesthadi.. |
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: | |
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)
|
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: | |
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 |
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: | |
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.. |
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: | |
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.
|
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: | |
>>'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. |
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: | |
Spit mama, dhaniki vachina error nee post kinda esa |
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: | |
I think this statement will do -
UPDATE acro
SET acro.supplier_name = ( SELECT users.name
FROM users
WHERE users.name = acro.name)
|
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: | |
>>
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 |
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: | |
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.. |
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: | |
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 |
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: | |
yep exists akkaraledu work avvali |
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: | |
mama do you want to update all the rows in the table X if some condition is satisfied in table Y |
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: | |
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 |
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: | |
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
|
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: | |
>>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 |
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: | |
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? |
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: | |
EXists kaakunda users.name IN ani pettalemo |
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: | |
lep
lep
lep
deithadi pochammagudi |
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: | |
naakada oka database lo users, acro ani two tables vundai
'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
>>>
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
|
