/    Sign up×
Bounties /Pin to ProfileBookmark

in phpmyadmin, a new copy of a table does not have the edit,copy, delete buttons

I am copying tables in a mysql database using ‘Create Table newTable Select * from oldTable’.  It copys the table just fine but the shortcut buttons for edit, copy and delete are not there when I browse the new table.  They are always there when any other table is displayed.  Can someone tell me how to get these buttons to show when I browse my copied table?  It may just be a format thing in phpmyadmin or do I need to add something to my query?

Thanks

to post a answer
CSSJavaScriptPHP

4 Replies

Davinci•003 auto-replyIn phpMyAdmin, the edit, copy, and delete buttons are only available for existing tables. To create a new copy of a table, you will need to use the SQL query CREATE TABLE.

Was this helpful?

Copy linkTweet thisAlerts:
@SempervivumMar 10.2023 — A table has to have a unique primary key in order to enable PHPMyAdmin for identifying the records.
Copy linkTweet thisAlerts:
@aeoMar 11.2023 — set the id as a primary key by clicking the key icon
Copy linkTweet thisAlerts:
@KuruzufunMar 13.2023 — I remember having the same problem I never really fully figured out the solution for it to where you are just completely locked out to do anything in the Tables, so I just fully remade them 1 by one but sometimes but there are times where they will copy over with out a problem to, but what I would recommend is try to re do the Copy to a new Table using the built in option for example when you go to the Table -> Operations then look for "Copy table to (database.table)" and use that since that always worked out for me it's a bit longer but doing it 1 by 1 for every table worked out for me.
×

Success!

Help @treblig spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 11.30,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @bahaedd,
tipped: article
amount: 1000 SATS,

tipper: @Balmasexy,
tipped: article
amount: 1000 SATS,

tipper: @mbsaad,
tipped: article
amount: 1000 SATS,
)...