Page 1 of 1

issue with going live

Posted: Sun Jan 22, 2017 1:45 am
by Imajica
I need a little assistance
When I do my development I usually use a subdomain inside of the main domain
When it's time to go live I slide the files into the root and edit the databasel to reflect the new paths

I ran into an issue in mysql

Code: Select all

 This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
after some time I just went in and added an ID field to use as a unique identifier but it wasn't as easy as I had hoped and it puts me out of sync with the rest of the community

Is there a reason why most of the tables don't use an ID field?

Am I moving the wrong way? Is there an easier way?

John

Re: issue with going live

Posted: Wed Jan 25, 2017 11:37 am
by garvinhicking
Hi!

We have a table without a unique column, but that isn't really a problem. More a "notice message" of phpMyAdmin. Other database tools like Adminer can easily still edit such rows in SQL. Earlier phpMyAdmin versions could too. Sadly they removed the feature.

The reason is that the table is just filled with random data and doesn't require a spefic ID field. It only uses up space and makes the table larger.

Regards,
Garvin