ar. talking about query of SQL, i am new to SQL query.
i have a question which need hrlp
everytime i have clientID changes. for example, a client who already has product and domain and invoice and paid. I want to change their clientID maybe from 1 to 9999.
I have to go in every single SQL database and brosw them, ctrl + F for 1, then change it to 9999 for every table like tblcliebts, tblorders tblinvoice tblinvoiceitems tbl hostings tbldomains tblaccounts.
The table is tbkclients and the field is ID, is there a query i can run that search for ClientID and field ID for 1 in all the tables above and chnage to 9999?
please help or i am going to have lots of trouble always...
reason why we change the clientID is because we have organise them. Sponsored clientID start with 500, paid ClientID start with 800, oversea ClientID start with 200. Thats why i need do the manual changes. Please help if you can.
i have a question which need hrlp
everytime i have clientID changes. for example, a client who already has product and domain and invoice and paid. I want to change their clientID maybe from 1 to 9999.
I have to go in every single SQL database and brosw them, ctrl + F for 1, then change it to 9999 for every table like tblcliebts, tblorders tblinvoice tblinvoiceitems tbl hostings tbldomains tblaccounts.
The table is tbkclients and the field is ID, is there a query i can run that search for ClientID and field ID for 1 in all the tables above and chnage to 9999?
please help or i am going to have lots of trouble always...
reason why we change the clientID is because we have organise them. Sponsored clientID start with 500, paid ClientID start with 800, oversea ClientID start with 200. Thats why i need do the manual changes. Please help if you can.