question

tanyasingh88 avatar image
tanyasingh88 asked

How to copy row data data in a table my sql

Hi, I am new to MySQL. I have a query. Could you please help me out with it? My table structure is as follows: ID NAME College Marks 1 Rakesh IIT 85 12th 78 10th 80 2 Manu MNIT 85 12th 90 10th 95 3 Nidhi Aiims 67 12th 78 10th 65 I need to copy down the ID and names to each row for that particular person. How can I do that? Please help me out with it. My file is more than 20000 values. Need your help. Its urgent Thanks Tanya
sqlmysqlquery-hint
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Squirrel avatar image Squirrel commented ·
what do you mean by "copy down the ID and names to each row" ? what is the expected output ?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.