update same uuid in a table where same category id

shan nathan

11y1.7kSQL

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Kumar11y ago
Accepted answer
DECLARE @myid uniqueidentifier = NEWID();
Update table_name SET uuid =@myid WHERE Companyid = @CompanyID
0
Jitendra Kumar11y ago
Create stored proc or write two query on page(first generate uuid and second update).
it is your choice.
0
shan nathan11y ago
you mean to create SP and call that using companyid. Am i right?
0
shan nathan11y ago
Update table_name SET uuid = 'Your Val' WHERE Companyid = @CompanyID

here 'your val'= (SELECT uuid()).

SELECT uuid() generates different id for each row.
0
Jitendra Kumar11y ago
Update table_name SET uuid = 'Your Val' WHERE Companyid = @CompanyID
0
shan nathan11y ago
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.
0
Jitendra Kumar11y ago
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'
0
shan nathan11y ago
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.
0
Jitendra Kumar11y ago
than provide real table structure and explain more about what you want.
0
shan nathan11y ago
company id is not foreign key.
0
Jitendra Kumar11y ago
means company id is foreign key in the table.
Please provide complete table structure.
0
shan nathan11y ago
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..
0
Jitendra Kumar11y ago
Hello Shan,

if you want same uuid for different company name so why use auto generated uuid.
0
shan nathan11y ago
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.
0
Akhil Garg11y ago
Hi
You need to update it with company id by simple query
Update TABLE_NAME SET uuid = 'Your Val' WHERE Companyid = @In_CompanyID
+1
Ramchand Repalle11y ago
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
+1