p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   MySQL (http://p2p.wrox.com/forumdisplay.php?f=99)
-   -   1064 error (http://p2p.wrox.com/showthread.php?t=31549)

kennymain July 16th, 2005 03:19 PM

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



All times are GMT -4. The time now is 10:39 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.