Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MYSQL error

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??

5 Replies
MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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);

MayilVahanan

HI

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

'$(maxid)' in where condition

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Filippo_Nicolussi_P

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 ?

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Anonymous
Not applicable
Author

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;