update same uuid in a table where same category id

Question

Hi there, I have a work to update a pre generated table with uuid. Now the problem is i have to update same uuid for same company. for example consider a table having the following values . companyid , value, uuid 1 aa uuid 1 bb uuid 2 cc uuid 3 dd uuid . here now the uuid is null. i have to update it. the problem is for company 1 the uuid should be same. Please help me

Jitendra Kumar · Answer

DECLARE @myid uniqueidentifier = NEWID(); Update table_name SET uuid =@myid WHERE Companyid = @CompanyID

Akhil Garg · Answer

Hi You need to update it with company id by simple query Update TABLE_NAME SET uuid = 'Your Val' WHERE Companyid = @In_CompanyID

Ramchand Repalle · Answer

Hi shan, The below update statement works correctly... UPDATE [TABLE_NAME] SET uuid = 'SOME_VALUE' WHERE Companyid = 1 Please try this and let me know the result... Thanks, Ramchand

Jitendra Kumar · Answer

Create stored proc or write two query on page(first generate uuid and second update). it is your choice.

shan nathan · Answer

you mean to create SP and call that using companyid. Am i right?

shan nathan · Answer

Update table_name SET uuid = 'Your Val' WHERE Companyid = @CompanyID here 'your val'= (SELECT uuid()). SELECT uuid() generates different id for each row.

Jitendra Kumar · Answer

Update table_name SET uuid = 'Your Val' WHERE Companyid = @CompanyID

shan nathan · Answer

your query only update uuid value for first row only. if the company has 100 products then i have to run 100 time this query by modifying the value.

Jitendra Kumar · Answer

Update table_name SET uuid = 'Your Val' WHERE Companyid = @CompanyID and value= @value ex :- Update tab_name SET uuid = 'Your Val' WHERE Companyid = 1 and value= 'aa'

shan nathan · Answer

CREATE TABLE `db_name`.`tab_name` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `companyid` int(10) unsigned NOT NULL, `val` varchar(45) NOT NULL, `uuid` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ). the data will be id companyid value uuid 1 1 aa null 2 1 bb null 3 2 cc null 4 3 dd null.

Jitendra Kumar · Answer

than provide real table structure and explain more about what you want.

shan nathan · Answer

company id is not foreign key.

Jitendra Kumar · Answer

means company id is foreign key in the table. Please provide complete table structure.

shan nathan · Answer

Hi jitendra kumar, I dont mean same uuid for all company. i mean same uuid for one company products. another uuid for another one company products..

Jitendra Kumar · Answer

Hello Shan, if you want same uuid for different company name so why use auto generated uuid.

shan nathan · Answer

hi Ramchand & Akhil, Thanks for your reply. i can update by using your query. here my problem is uuid is an auto generated one (I hope you know about uuid). when run the update query each uuid is different. but i need same uuid for company 1. and same uuid for company 2.

update same uuid in a table where same category id

Salman

Nitin Sontakke