Skip to main content
RMathis's user avatar
RMathis's user avatar
RMathis's user avatar
RMathis
  • Member for 7 years, 3 months
  • Last seen more than 6 years ago
  • USA
3 votes

How to JOIN two tables with substring?

3 votes

can we create a view using SUM or AVG depends on a condition?

3 votes
Accepted

Can I alter ENUM value from lowercase to studlyCase without reindex?

3 votes

How to retrieve the query I used to create a view?

2 votes

How can I group the null results in this FULL OUTER JOIN with non-null responses?

1 vote
Accepted

Monitor and alerting tool for specific queries

1 vote

Calculate total hours per day based on "TIME_IN" data in one row and "TIME_OUT" data on the next row

1 vote

MySQL and MSSQL Joined Query Performance Issue

1 vote

Using IN with LIMIT in MySql

1 vote

How to use SUBSTRING using REGEXP in MySQL

1 vote

Delete millions of rows disabling Indexes

1 vote

Return a ranking from multiple table with mySQL

1 vote

Is it normal for disk activity to disturb MySQL performance?

1 vote

How can I *actually* defragment my InnoDB tables?

1 vote

is this dead simple query too slow?

1 vote

Need Speed improvement on MySQL table

1 vote
Accepted

Design Pattern to Reduce Number Of Columns

1 vote

Storing IPv4 and IPv6 hosts and networks

0 votes

Deadlock in INSERT ... ON DUPLICATE KEY UPDATE

0 votes

How to avoid row locks on both tables joined in an update?

0 votes

Mysql Server Crashing Regularly

0 votes

Help troubleshooting mysql deadlock

0 votes

MySQL: How to get the maximum disposition and the maximum date from my database

0 votes

How to optimize MySQL query with more than 2 inner joins

-1 votes

Take individual MySQL database offline

-1 votes

Convert table from MyISAM to InnoDB and keep MyISAM rows order