copying field records from one table to another

Question

0.00/5 (No votes)

See more:

i ahve table with fields for

table Cart_details
with fields as cart_id,cat_id,quantity

and i have table Order_details
with fields as order_id,cat_id,quantity

both cart_id and order_id are different and i want to copy records(cat_id,quantity ) from one table to another .

can anyone give me some idea to implement this in mysql

Posted 17-Jun-11 6:24am

gaurish thakkar

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

wizardzz · Answer 1 · 2011-06-17T06:31:00

Solution 1

Insert into order_details select cat_id, quantity from cart_details

Posted 17-Jun-11 6:31am

wizardzz

Comments

gaurish thakkar 17-Jun-11 12:39pm

i m getting error that Column count doesn't match value count at row 1,

how do insert value for order_id?

wizardzz 17-Jun-11 12:51pm

is order_id auto incrementing?

wizardzz 17-Jun-11 12:56pm

Insert into order_details select cart_id, cat_id, quantity from cart_details
or
Insert into order_details select value, cat_id, quantity from cart_details
where value is the value you are assigning to the id.

gaurish thakkar 17-Jun-11 12:54pm

no it is foreign key of another table.i just tried using while loop and dbreader ,now i can fetch individual values and insert into the rows.though it is cumbersome step it can be used as soln