MYSQL error

[#1]

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

[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

[#3]

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

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

[Anonymous]

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;