Jump to content

tblClients Manual editing


netnow

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated