• Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

Duplicate rows in phpmyadmin


I would to duplicate the rows that contain one id and change that id with a new.
Id=1 copy all columns and rows and paste them in the same table if id=2
So to make sure I understand what you're saying, you want to copy the contents of one row to new row in phpMyAdmin.

Assuming the ID is auto-incrementing, you can simply click on the checkbox to the very left of the row, click "Copy" at the bottom, then click "Go" at the bottom of the copy page. If the ID isnt auto-incrementing, you can change it in the Copy screen.

Hope that helps.
Top Bottom