kartisathis

Guys, I having problem converting the sql server function to mysql function. It work perfect at sql server now it now working at mysql. Please help.Thanks delimiter $$ CREATE FUNCTION SortingAlphanumeric(ColValue NVARCHAR(255)) RETURNS NVARCHAR(1000) BEGIN DECLARE p1 NVARCHAR(255); DECLARE p2 NVARCHAR(255); DECLARE p3 NVARCHAR(255); DECLARE p4 NVARCHAR(255); DECLARE Index1 TINYINT; …

I have this: [code] DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `linkacorte`(vid_pedido int(11), vid_producto int(11),vtiempo varchar(50),vid_pastelero int(11),vcorte varchar(200),vnum int(2)) begin declare campo varchar(20); DECLARE EXIT HANDLER FOR SQLSTATE '42000' SELECT 'Ha introducido un campo incorrecto. Solo se permite 1,2 o 3'; if vnum=1 then set campo='programa_corte_1'; elseif vnum=2 then set campo='programa_corte_2'; elseif …

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 guys. I have a table as follows: [ICODE] ID | Data ---------------------- 1 | A 1 | B 1 | C[/ICODE] It is possible to make like this one. [ICODE]ID | Data1 | Data2 | Data3 ------------------------------------------------------- 1 | A | B | C[/ICODE] Thanks.

Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | …

*********************************************** 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..