1064 error
hi
i'm am trying to use the following
INSERT INTO phplog_members (userid, groupid)
SELECT u.userid, g.groupid
FROM phplog_users u,phplog_groups g
WHERE u.username="interactive test" AND g.groupname="annual"
when i use mysqlcc to check the script it works fine, when i enter the script into the software i use (email2db) it comes back with
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 '' at line 1 NativeError: 1064
yet i am using the exact same database which is version 4.0.23a
is this because the version of mysql is wrong or the 3rd party software
kenny
|