Click here to Skip to main content
14,386,804 members

How to convert following queries into mysql

Akshay malvankar asked:

Open original thread
This is my SQL Queries

SELECT top 1000 tr.page,tr.referrer,tr.keywords,tr.ms_id,tr.ms_date,tr.ip  FROM tblTracking tr 
WHERE tr.heirarchy LIKE '%*' + cast(@Cid as varchar) + '*%' and tr.site=@site and 
tr.ms_date between CONVERT(VARCHAR(11),@FromDt,101) and DATEADD(DAY,1,CONVERT(VARCHAR(11),@Todt,101)) 
order by tr.ms_date desc


I converted it into Mysql

SELECT COUNT(tr.id) as cnt FROM tblTracking tr 
WHERE tr.heirarchy LIKE '%*'; + concat(cast(p_Cid as varchar(1)) , '*%') and tr.site=p_site and 
tr.ms_date between DATE_FORMAT(p_FromDt,'%m/%d/%Y') and TIMESTAMPADD(DAY,1,DATE_FORMAT(p_Todt,'%m/%d/%Y')) 


Its giving me error
'+ ' not valid at this position excepting :END

When i removed ";" it give me following Error
'+ ' not valid at this position excepting: ';'

What I have tried:

I tried everything but couldn't get any thing
Tags: SQL, MySQL

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100