Insert Into query broken in mysql

Question

I need to run this kind of query.

INSERT INTO `book_newBookOrder` (id, volume, 5, chapterNr, sectionNr, `text`) 
SELECT id, volume, bookNr, chapterNr, sectionNr, `text`
FROM book_oldBookOrder 
WHERE booknr = 1;

The fixed value 5 in the INSERT INTO part breaks it. I must be able to specify the two values as above.

So I want to select everything with bookNr = 1 in the oldbooknr table and store that as booknr 5 in the newbookorder table.

Please advise me. Thanks.

Do it the other way around place the 5 in the select and the bookNr in the insert part. — Raymond Nijland
– Raymond Nijland, Commented May 4, 2018 at 15:02
I need to pick the bookNr I want from the one (1) and specify it as (5) for the new table. — McGafter
– McGafter, Commented May 4, 2018 at 15:14

ADyson · Accepted Answer · 2018-05-04 15:11:57Z

1

You have a syntax error: The items in the first set of brackets in the INSERT should be the field names. "5" is not a field name, that's the value you want to be inserted (I assume you wish to set this value the same in every row which gets inserted?). That should be in the SELECT:

INSERT INTO `book_newBookOrder` (id, volume, bookNr, chapterNr, sectionNr, `text`) 
SELECT id, volume, 5, chapterNr, sectionNr, `text`
FROM book_oldBookOrder 
WHERE booknr = 1;

answered May 4, 2018 at 15:11

ADyson

62.9k16 gold badges86 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

McGafter Over a year ago

I don't want to select 5, I want to select 1 and change it to five in the new table.

McGafter Over a year ago

Sorry guys, I'm a bit slow today. You're right it works.

Collectives™ on Stack Overflow

Insert Into query broken in mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related