66,683 reputation
1070156
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 8 hours ago

One of JEHOVAH's Witnesses (TV)

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

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


22h
comment Query where there are only two rows with specific data
This is not just a query, but a work of art. +1 for a single pass aggregation. Very slick !!!
1d
answered mariadb - EXPLAIN works but ANALYZE throws ERROR 1064 (42000) error in SQL syntax
1d
revised mariadb - EXPLAIN works but ANALYZE throws ERROR 1064 (42000) error in SQL syntax
edited tags
1d
answered How to get all the months from the last paid date in MySql?
1d
revised How to get all the months from the last paid date in MySql?
No triggers or store procedures involved, so I removed those tags
1d
reviewed No Action Needed mysql - sum interval dates
1d
reviewed No Action Needed How to model efficient permission checks for a social network?
1d
reviewed Close Find the salary history of employee ‘Margareta Markovitch’
1d
reviewed Close How do I select all child table records based on condition
1d
revised When is mariadb creating tmp tables?
added 236 characters in body
1d
answered Can't start MySQL server because of wrong file permissions?
1d
awarded  Enlightened
1d
awarded  Nice Answer
1d
revised Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
edited title
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
Thank you for accepting. This is has been a headache for years (forums.mysql.com/read.php?98,395223,395223)
1d
revised Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
deleted 128 characters in body
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
I got it, please look again !!!
1d
revised Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
added 1734 characters in body
1d
revised Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
added 20 characters in body
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
I had just removed an extra semicolon. Please try again.