kartisathis

Hi i think there is a mistake in assigning values, mysql> select @a=locate('a','karthik'); -> $$ +--------------------------+ | @a=locate('a','karthik') | +--------------------------+ | 0 | +--------------------------+ 1 row in set (0.00 sec) but the actual result is, mysql> select @a:=locate('a','karthik'); -> $$ +---------------------------+ | @a:=locate('a','karthik') | +---------------------------+ | 2 | +---------------------------+ 1 …

Hi i think you again did same mistake in concat statement , intsead of [CODE]SET @sqltext=CONCAT('UPDATE pedidos_productos SET ',campo,'=vcorte WHERE id_pedido=vid_pedido AND id_producto=vid_producto AND tiempo=vtiempo AND id_pastelero=vid_pastelero');[/CODE] try this [CODE] SET @sqltext=CONCAT("UPDATE pedidos_productos SET ",campo,"=vcorte WHERE id_pedido=",vid_pedido," AND id_producto=",vid_producto," AND tiempo=",vtiempo," AND id_pastelero=",vid_pastelero);[/CODE] and execute the procedure

Hi friends, I m new to Linux and i want to change the Bluetooth Dongle BT address , it has a default BT address as 11:11:11:11:11:11 and i need to change this address to someother.. Brand Company:Conwise Technology corp. help needed regards karthik

hi friends.. I need an alternate query without using UNION for below query.. [CODE]select DIST_NO from acquired_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'[/CODE]

Hi everyone, [CODE]select sql_calc_found_rows DIST_NO from acquired WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' LIMIT 0, 5; [/CODE] The above query takes more than 4.5secs if i run the query without sql_calc_found_rows the execution time is 0.7 secs [CODE]select DIST_NO …

hi Mr.smantscheff If am having data like this [CODE]id data 1 A 1 B 1 C 2 A 2 B[/CODE] and i need a solution like this , [CODE] ID | Data1 | Data2 | Data3 ------------------------------------------------------- 1 | A | B | C 2 | A | B | …

[CODE]select * from (SELECT * FROM `plants` WHERE 1 ORDER BY `DATE` DESC ) temp group by temp.`plant`[/CODE]

*********************************************** select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT(''',`RIGHT_CODE',''')as right_code FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC` HAVING count( `RIGHT_CODE` ) >=2 **************************************************** Actually the above query returns empty result. But the query Inside IN cluase which returns ('1','28').. If i directly pass the value inside IN clause means …

hi Friends, Hi, I know that it must be done via /usr/bin/sa-update, but what should I take care of when doing this? and where are located the rules in use.

hi frndz... i m new to linux i need to config sendmail MTA and i hav to use procmail as filter and cyrus as LDA... plz help me guys ... i need a sendmail config file for the above mentioned options ....

Dear all, When I try to configure mail filtering through spamassassin to sendmail mail server via spamass-milter, spamass-milter's README file says to put following lines to the sendmail.mc file and generate the sendmail.cf file using macro, [CODE]INPUT_MAIL_FILTER(`spamassassin', `S=local:/var/run/sendmail/spamass.sock, F=, T=C:15m;S:4m;R:4m;E:10m')dnl define(`confMILTER_MACROS_CONNECT',`t, b, j, _, {daemon_name}, {if_name}, {if_addr}')dnl define(`confMILTER_MACROS_HELO',`s, {tls_version}, {cipher}, …

how to find the last dml action held on which row in a table using mysql plz do me a favour , tanks in advance..