61,668 reputation
1060143
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 5 months
seen 5 mins ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Jul
25
reviewed Leave Open mysql server is not starting
Jul
25
reviewed Close MySQL Code Works in PHPMyAdmin but not in PHP Page
Jul
25
reviewed Close Mysql Group Concat Distinct On One Field While Returning Another
Jul
25
reviewed Close Designing a database for a site that stores content from multiple services?
Jul
25
answered How to stop ROLLBACK in progress?
Jul
25
comment What could cause waiting for table metadata lock?
Do you ever run TRUNCATE TABLE during this period ?
Jul
24
reviewed No Action Needed Database design for tracking referral dollars and referred dollars
Jul
24
reviewed Close Duplicate Entry Error with PHP When Trying UPDATE
Jul
24
comment amazon small instance mysql query too slow
Is this Amazon RDS or EC2 ???
Jul
24
comment How do I place leading zeros for numbers less than 10 without affecting those 10+?
Any particular reason you don't want 1 to be 001 ?
Jul
23
comment MySQL: update field with “x hours xx minutes”using int from another field
I got a confession to make. The nested query I gave you comes from a StackOverflow post I wrote almost three years ago (stackoverflow.com/a/7668791/491757). It has the Stored Procedure for this if you wish to use it elsewhere.
Jul
23
comment MySQL: update field with “x hours xx minutes”using int from another field
Each nested select generates a tiny temp table that gets used and dropped quickly (per row).
Jul
23
comment MySQL: update field with “x hours xx minutes”using int from another field
I updated the query to perform everything in minutes instead of seconds
Jul
23
revised MySQL: update field with “x hours xx minutes”using int from another field
added 4416 characters in body
Jul
23
comment MySQL: update field with “x hours xx minutes”using int from another field
Oh I'm sorry, you are expressing minutes not seconds. Let me fix that...
Jul
23
revised MySQL: update field with “x hours xx minutes”using int from another field
added 4416 characters in body
Jul
23
revised MySQL: update field with “x hours xx minutes”using int from another field
deleted 1034 characters in body
Jul
23
revised MySQL: update field with “x hours xx minutes”using int from another field
added 1036 characters in body
Jul
23
answered MySQL: update field with “x hours xx minutes”using int from another field
Jul
23
revised Find problematic MySQL users and databases
edited tags