netnow Posted March 17, 2020 Share Posted March 17, 2020 Is it permissible to use phpMyAdmin to edit some basic fields in tblClients? If so, are there fields (other than uid, and uuid) that must name be edited? -T 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted March 18, 2020 Share Posted March 18, 2020 Let me understand. Are we talking about renaming columns? If so, DON'T do that. It will break the entire system. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted March 18, 2020 Share Posted March 18, 2020 11 hours ago, netnow said: Is it permissible to use phpMyAdmin to edit some basic fields in tblClients? if you mean values within the records, then yes (if you know what you're doing!)... as Kian says, definitely not column names/titles. 12 hours ago, netnow said: If so, are there fields (other than uid, and uuid) that must name be edited? I assume you are asking if there are fields that must not be edited... what are you intending/wanting to change ? either way, backup the table before you make any changes. 0 Quote Link to comment Share on other sites More sharing options...
netnow Posted March 23, 2020 Author Share Posted March 23, 2020 Brian, Yes, sorry I meant ".. must not be edited..". We are in the position to start updating client info. The first thing will be to get unique email address in the main contact so peeps can log in to the correct accounts. Other than writing an SQL script, it appears to us the easiest way would be to open the tblClients in phpMyAdmin and put them in by hand. Later on, changing the address phone numbers etc. If all these values are simply that, values used in tblClients, and not somehow joined to other tables ... editing should be ok? (And yes, definately not editing columns or table structure in any way). -T 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted March 24, 2020 Share Posted March 24, 2020 15 hours ago, netnow said: If all these values are simply that, values used in tblClients, and not somehow joined to other tables ... editing should be ok? yes... the ID value is used as a reference by other tables, so changing names, addresses etc wouldn't have an impact on other tables. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.