Reputation
783
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 15
Newest
 Yearling
Impact
~12k people reached

2d
comment Need simple MySQL query for below description
You have a database named information_schema. You can query this to get this information.
Jun
19
comment How to select max value faster from large size table
Execute create index idx_modelparam_ems_parameterid on modelparam_ems(ParameterID); if you haven't an index on it already and it will run almost lightning-fast.
Jun
12
comment Table1 ID is auto increment and i also want to store the information from table 2 against that auto generated ID
The second statement is not valid syntax. Have a look here: dev.mysql.com/doc/refman/5.0/en/update.html That aside, I have no idea what the problem is. There's no question in your post.
Jun
2
reviewed No Action Needed postgresql Insert into table B based on foreign key in table A, if exists in A else
Jun
2
reviewed No Action Needed Database design: handling time
Jun
1
comment Reclaim disk space after dropping table(innodb_file_per_table = ON), strange scenario
Have you by any chance enabled innodb_file_per_table after you created the table in question?
May
12
answered SQL SSIS syntax question
Apr
3
awarded  Yearling
Feb
5
comment Query gives correct answer on second run
Well, like I said, I can only guess. Come up with the requirements, maybe sample data and desired result and we can help. But not with this little information.
Feb
4
reviewed No Action Needed Sleeping queries blocking rebuild index and update statistics job in Always on
Feb
4
reviewed No Action Needed Large query with subquery runs indefinitely after mysql update
Feb
4
comment Query gives correct answer on second run
@user57391 Edited my answer.
Feb
4
revised Query gives correct answer on second run
added 711 characters in body
Feb
3
answered Query gives correct answer on second run
Feb
2
comment Selecting, ranking and applying a point score based on rank
? It's right in the post. The history is under the link "edited Jan 27 at 11:30" What is not working?
Jan
27
comment MySQL : How to know if Trigger was fired
Write something in a temporary table if you wish.
Jan
27
comment MySQL : How to know if Trigger was fired
When the trigger was created successfully, you can safely assume that it's fired when the appropriate DML statement is executed.
Jan
27
comment Selecting, ranking and applying a point score based on rank
@Dannymh Updated my answer. Please have a try.
Jan
27
revised Selecting, ranking and applying a point score based on rank
added 985 characters in body
Jan
26
revised Selecting, ranking and applying a point score based on rank
added 1178 characters in body