•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 330,119 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,076 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 131 | Replies: 7
 |
•
•
Join Date: Feb 2008
Location: Cochin
Posts: 66
Reputation: 
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
Hi all,
I want to insert multiple records into a table using one query.
And my query is
INSERT INTO table2(id,message)
SELECT id FROM table1 WHERE condn,'hello'
but it displays an error....
Can you help me?
Thanx in advance....
jino
I want to insert multiple records into a table using one query.
And my query is
INSERT INTO table2(id,message)
SELECT id FROM table1 WHERE condn,'hello'
but it displays an error....
Can you help me?
Thanx in advance....
jino
We only have to do a very few things right in our life, so long as we don't do too many things wrong.
•
•
Join Date: Apr 2008
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
hi
Jino
what exactly you want to insert
insert data through forms or from one table to another table.
regards
nickyspace
Jino
what exactly you want to insert
insert data through forms or from one table to another table.
regards
nickyspace
•
•
•
•
Originally Posted by jino 
Hi all,
I want to insert multiple records into a table using one query.
And my query is
INSERT INTO table2(id,message)
SELECT id FROM table1 WHERE condn,'hello'
but it displays an error....
Can you help me?
Thanx in advance....
jino
•
•
Join Date: May 2008
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
It might help to post the error here as well.
Notice that you are trying to INSERT two values, id and message, but you are only SELECTING one value, id. Your query should look something like the following:
INSERT INTO table2(id, message) SELECT id, message FROM table1 WHERE some_condition
Notice that you are trying to INSERT two values, id and message, but you are only SELECTING one value, id. Your query should look something like the following:
INSERT INTO table2(id, message) SELECT id, message FROM table1 WHERE some_condition
•
•
Join Date: Feb 2008
Location: Cochin
Posts: 66
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
dear mike,
actually id is from a table ie:from table1 and the message is a variable that is initialize dynamically.
actually id is from a table ie:from table1 and the message is a variable that is initialize dynamically.
We only have to do a very few things right in our life, so long as we don't do too many things wrong.
•
•
Join Date: May 2008
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Try this:
INSERT INTO table2(id, message) VALUES((SELECT id FROM table1 where some_condition), 'Hello')
INSERT INTO table2(id, message) VALUES((SELECT id FROM table1 where some_condition), 'Hello')
•
•
Join Date: Feb 2008
Location: Cochin
Posts: 66
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
Thank you mike.....i got it....
We only have to do a very few things right in our life, so long as we don't do too many things wrong.
•
•
Join Date: Feb 2008
Location: Cochin
Posts: 66
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
sorry mike.....
there is another problem ...if my subquery returns more than one records it displays an error
there is another problem ...if my subquery returns more than one records it displays an error
We only have to do a very few things right in our life, so long as we don't do too many things wrong.
•
•
Join Date: May 2008
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
You'll have to write this in two queries:
First do the SELECT id FROM table1 WHERE some_condition
Then do the INSERT INTO table2(id, message) VALUES (first_item_from_select, 'Hello 1'), (second_item_from_select, 'Hello 2'), and so on...
First do the SELECT id FROM table1 WHERE some_condition
Then do the INSERT INTO table2(id, message) VALUES (first_item_from_select, 'Hello 1'), (second_item_from_select, 'Hello 2'), and so on...
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
DaniWeb Marketplace (Sponsored Links)
Linear Mode
Similar Threads
- writitng data from php to mysql (PHP)
- MySQL INSERT not working. Why? (MySQL)
- Its really a problem on INSERT statement (MySQL)
- MySQL insert statement (MySQL)
Other Threads in the PHP Forum
- Previous Thread: create input boxes on the fly?
- Next Thread: Problem on PHP/Mysql Server
