MySQL query not working in phpmyadmin

I do not understand why my query is not working:

INSERT INTO `jos_acymailing_subscriber`(`sleep_breathe`)
  VALUE (`1`)

SELECT `subid` 
  FROM `jos_acymailing_listsub` 
  WHERE `listid` = `8`
   LEFT JOIN `jos_acymailing_subscriber`
  ON `jos_acymailing_listsub`.`subid` = `jos_acymailing_subscriber`.`sleep_breathe`

thx

I have a table of users that are subscribed to a mailing lists (the id of the list I am interested in is 8) . The subscription table is a simple intermediary table in a "many to many" relation

In the user table I want to add in a field an integer with 1 for the users that are subscribed to the list 8

So I need to first select the users that are in the intermediary table where the listid is 8 then add 1 in the field sleep_breathe that is in the user table.

The user table structure: name: jos_acymailing_subscriber

Field Type Null Default Comments subid int(10) No

email varchar(200) No

userid int(10) Yes NULL

name varchar(250) No

created int(10) Yes NULL

confirmed tinyint(4) No 0

enabled tinyint(4) No 1

accept tinyint(4) No 1

ip varchar(100) Yes NULL

html tinyint(4) No 1

key varchar(250) Yes NULL

ersmembershipnumber varchar(250) Yes NULL

first varchar(250) Yes NULL

title varchar(250) Yes NULL

erj varchar(250) Yes NULL

err varchar(250) Yes NULL

monograph varchar(250) Yes NULL

breathe varch开发者_Go百科ar(250) Yes NULL

membershipcategory varchar(250) Yes NULL

mship_status varchar(250) Yes NULL

copd varchar(250) Yes NULL

sleep_breathe varchar(250) Yes NULL

pro varchar(250) Yes NULL

The intermediary table structure is: name: jos_acymailing_listsub

Field Type Null Default Comments listid smallint(11) No

subid int(11) No

subdate int(11) Yes NULL

unsubdate int(11) Yes NULL

status tinyint(4) No

I think the problem is you have put VALUE instead of VALUES.

It remains VALUES even if there is only one value to insert.

As others have said, that is two queries. Also, VALUES not VALUE. Thirdly, I'm not sure MySQL allows a WHERE before the JOIN. Your queries may have to be

INSERT INTO `jos_acymailing_subscriber`(`sleep_breathe`) VALUES (`1`);

SELECT `subid` 
FROM `jos_acymailing_listsub` 
LEFT JOIN `jos_acymailing_subscriber`
ON `jos_acymailing_listsub`.`subid` = `jos_acymailing_subscriber`.`sleep_breathe`
WHERE `listid` = `8;

(1) It should be VALUES not VALUE in the insert. (2) The left join is part of the from clause. Move the where clause to the end.

There are several errors in that statement.

• If you want to insert values retrieved from a SELECT statement, the VALUES clause is not needed (in fact it's an error).
• Numbers may not be put into quotes or even backticks.
• The order of the FROM and LEFT JOIN keywords mixed up.

The query to insert values retrieved from a SELECT would be:

INSERT INTO jos_acymailing_subscriber (sleep_breathe)
SELECT 1
FROM jos_acymailing_listsub
  LEFT JOIN jos_acymailing_subscriber
     ON jos_acymailing_listsub.subid = jos_acymailing_subscriber.sleep_breathe
WHERE listid = 8

One tip: forget the dreaded backticks alltogether so you won't get confused where and for what you need them.