Last post Feb 14, 2017 07:00 AM by wmec
Jan 31, 2017 05:25 AM|shivani.gupta|LINK
I have created one procedure which takes approx 1 min to complete.
My problem is that when one user request to that procedure its working fine. If more than one user request to that procedure, It will starts overwriting user request.
Please help me.
Jan 31, 2017 08:47 AM|ignatandrei|LINK
If more than one user request to that procedure, It will starts overwriting user request.
Do you use global temporary tables?
Please show some code.
Feb 03, 2017 06:13 AM|shivani.gupta|LINK
I am new in mysql.
I used both syntax
DROP TEMPORARY TABLE IF EXISTS TempCoverers;
CREATE TEMPORARY TABLE TempCoverersAS
DROP TEMPORARY TABLE IF EXISTS TempCoverUnderwriterPremium;
CREATE TEMPORARY TABLE TempCoverUnderwriterPremium
serial_number bigint(20),premium_per decimal(15,4),premium_per_basis varchar(50),is_actual tinyint(1),premium_amt decimal(15,4)
,client_cover_amt decimal (15,4),funeral_cover_member_risk_premium_id bigint(20),share_percentage bigint(20),
funeral_plan_benefit_type_id bigint(20),scheme_underwriter_id bigint(20)
Feb 14, 2017 07:00 AM|wmec|LINK
Try rowlock in this case, like
UPDATE <tablename> (ROWLOCK) SET <somecolumn> = <somecolumn> WHERE id=1