DELETE * FROM amember_members , amember_payments WHERE amember_members.member_id = amember_payments.member_id AND amember_members.status = ‘0’
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_i’ at line 1
DELETE
FROM amember_members , amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.status = '0
And now I get the following error.
Error
SQL query:
DELETE FROM amember_members , amember_payments WHERE amember_members.member_id = amember_payments.member_id AND amember_members.status = ‘0’
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 ‘WHERE amember_members.member_id = amember_payments.member_id
AND amember_member’ at line 3
So based on what you have outlined above how can I delete only the records that I can select using the below syntax? Sorry but I am an absolute beginner and don’t want to lose wanted data.
SELECT *
FROM amember_members , amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.status = '0
I just checked the members table and it does include the status field so I guess all I really want to do is delete all the members that have a status of 0.