topic Re: MYSQL error in QlikView

MYSQL error

Thu, 06 Dec 2012 18:05:08 GMT

I am getting this error:

SQL##f - SqlState: 37000, ErrorCode: 1064, ErrorMsg: [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-enterprise-commercial-advanced-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM abcdsd.poiuytr where id > 612233' at line 10
Fs_new:

SQL SELECT id,
    pid,
    `b_time`,
    `a_time`,
    `b_sub`,
    `a_sub`,
    `b_error`,
    `a_error`,
    `dmsg`,
FROM abcdsd.poiuytr
where id > 612233

Can anybody suggest a solution??

Re: MYSQL error

MayilVahanan — Thu, 06 Dec 2012 18:08:30 GMT

Try like this

SQL SELECT id,

pid,

b_time,

a_time,

b_sub,

a_sub,

b_error,

a_error,

dmsg,

FROM abcdsd.poiuytr

where id > 612233;

hope it helps

Re: MYSQL error

Thu, 06 Dec 2012 18:31:57 GMT

Not Working....

Also,

my script is:

SQL

SELECT id,
pid,
b_time,
a_time,
b_sub,
a_sub,
b_error,
a_error,
dmsg,
FROM abcdsd.poiuytr
where id > $(maxid);

Re: MYSQL error

MayilVahanan — Thu, 06 Dec 2012 18:43:22 GMT

Without where condition, it works or not? if works, check id is number or varchar. if varchar,

'$(maxid)' in where condition

Re: MYSQL error

Filippo_Nicolussi_P — Fri, 04 Jul 2014 06:37:31 GMT

Try this :

SQL SELECT `id`,

pid,

`b_time`,

`a_time`,

`b_sub`,

`a_sub`,

`b_error`,

`a_error`,

`dmsg`,

FROM abcdsd.poiuytr

where `id` >= '612234'

Do you also try the wizard , selecting preceding load ?

Re: MYSQL error

Anonymous — Fri, 04 Jul 2014 06:40:28 GMT

Hi,

Try below,

LOAD

WHERE id > 612233;

SQL SELECT id,

pid,

`b_time`,

`a_time`,

`b_sub`,

`a_sub`,

`b_error`,

`a_error`,

`dmsg`,

FROM abcdsd.poiuytr;