Reputation
602
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 17
Newest
 Yearling
Impact
~34k people reached

  • 0 posts edited
  • 3 helpful flags
  • 61 votes cast
1h
comment Compare values between columns in different tables
@AndriyM no at all, I'm refer to some action that relies on code side, for example: execute a piece of code. I want this act as a COUNT(*) something like IF (RESULT OF SELECT COUNT(*) FROM X > 1 ) THEN { EXECUTE CODE } ELSE { DO NOTHING } (this is just a piece of pseudo-code to show you what I am talking about)
11h
asked Compare values between columns in different tables
Jul
29
awarded  Yearling
Jul
27
awarded  Caucus
Jul
23
reviewed Approve Get rows changed between two dates (latest and previous)
Jul
23
accepted Get rows changed between two dates (latest and previous)
Jul
23
asked Get rows changed between two dates (latest and previous)
Jul
21
comment Which is the right way to fix “Error: 1205 Lock wait timeout exceeded; try restarting transaction”
@jkavalik no, I am not use any of the replication form mentioned above, all happen on the same server but different DB. I am selecting from one and inserting in another one, this is what triggers does
Jul
21
revised Which is the right way to fix “Error: 1205 Lock wait timeout exceeded; try restarting transaction”
added 2 characters in body
Jul
21
revised Which is the right way to fix “Error: 1205 Lock wait timeout exceeded; try restarting transaction”
added 61 characters in body
Jul
20
comment The user specified as a definer ('root'@'%') does not exist
@rolandomysqldba says is better to delete that tables from MySQL and remove those privileges rather than run what you say, which one to follow?
Jul
20
asked Which is the right way to fix “Error: 1205 Lock wait timeout exceeded; try restarting transaction”
Jul
20
reviewed Approve The user specified as a definer ('root'@'%') does not exist
Jul
20
comment The user specified as a definer ('root'@'%') does not exist
@oNare I don't even know why trigger is called using 'root'@'%' and not fom 'root'@'localhost' as they should be called
Jul
20
asked The user specified as a definer ('root'@'%') does not exist
Jul
18
accepted Which are the differences and advantages on single INDEX or compound INDEX?
Jul
18
accepted Is possible to optimize this query or it's already optimized?
Jul
18
accepted Rename PK column names when they are FK in another tables
Jul
15
comment Which are the differences and advantages on single INDEX or compound INDEX?
@miracle173 Which code you need? Just open the image in a new tab 1, 2 and 3 and you will have a better image quality
Jul
15
asked Which are the differences and advantages on single INDEX or compound INDEX?