•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 422,977 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 3,934 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 MySQL advertiser: Programming Forums
Views: 6172 | Replies: 2
 |
•
•
Join Date: Jan 2006
Posts: 221
Reputation: 
Rep Power: 3
Solved Threads: 20
Posting Whiz in Training
MySQL insert statement I'm having problem in inserting into table. I'm inserting data from one table into another
insert into table1 select * from table2 where condition = expression
I have 962 records in table2 for specified condition, but only 105 rows are getting inserted.
Both tables are in same database.
What could be problem? Please help me to get out of this problem.
insert into table1 select * from table2 where condition = expression
I have 962 records in table2 for specified condition, but only 105 rows are getting inserted.
Both tables are in same database.
What could be problem? Please help me to get out of this problem.
Last edited by katharnakh : Jul 11th, 2006 at 6:01 pm.
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 482
Reputation:
Rep Power: 3
Solved Threads: 33
Posting Pro in Training
•
•
•
•
Originally Posted by katharnakh
I'm having problem in inserting into table. I'm inserting data from one table into another
insert into table1 select * from table2 where condition = expression
I have 962 records in table2 for specified condition, but only 105 rows are getting inserted.
Both tables are in same database.
What could be problem? Please help me to get out of this problem.
your expression is probably wrong, however, it is difficult to diagnose unless you post it and some of your schema
•
•
Join Date: Jul 2006
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
The insertion sql statement should be something like:
INSERT INTO TABLE (column1, column2)
SELECT column1, column2 FROM TABLE2 WHERE column3 = 4
make sure that the number of columns are the same and in the same order
Hope it helps.
INSERT INTO TABLE (column1, column2)
SELECT column1, column2 FROM TABLE2 WHERE column3 = 4
make sure that the number of columns are the same and in the same order
Hope it helps.
Last edited by Vote4WillFree : Jul 12th, 2006 at 9:03 am.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- insert statement error (MySQL)
- MySQL INSERT not working. Why? (MySQL)
- Inserting uft8 strings into MySQL from jsp page (JSP)
- Date type problem JSP, mySQL (Java)
- Its really a problem on INSERT statement (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: is order by and group by the same?
- Next Thread: powerbuilder+mysql
