Thread: 1064 error
View Single Post
  #1 (permalink)  
Old July 16th, 2005, 03:19 PM
kennymain kennymain is offline
Registered User
Join Date: Jul 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 1064 error

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


Reply With Quote