When I use the following sql code it returns 438 records.
SELECT *
FROM amember_members
, amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.country = ‘ZA’
AND amember_payments.expire_date = ‘2011-05-11’
I want to delete these 438 records and tried to use this code.
DELETE *
FROM amember_members
, amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.country = ‘ZA’
AND amember_payments.expire_date = ‘2011-05-11’
However when I use the sql code above I receive the following error message.
Error
SQL query:
DELETE * FROM amember_members
,
amember_payments
WHERE amember_members.member_id = amember_payments.member_id AND amember_members.country = ‘ZA’ AND amember_payments.expire_date = ‘2011-05-11’
MySQL said:
#1064 - 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 amember_members
, amember_payments
WHERE amember_members.member_’ at line 1
What code do I need to use to delete these 438 records?
Thanks in advance.