Blog /
MySQL
7 posts
2011
- Mysql: determine cheaters emails At the office we often develop apps for campaign contests. Obviously we often have to deal with cheaters: users who register using either disposable email addresses or catch-all domains. This sql…
2010
- More MySQL queries Calculate table size select table_name, data_length, data_length/1024/1024 as sizeinmb from information_schema. tables where table_schema='yourschemaname' order by sizeinmb desc; Calculate ranking…
2009
- Configure MySQL source: http://www.devside.net/guides/windows/mysql Startup MySQL can be installed as a Service (automatic or manual start-up) or started as a standalone console application. The MySQL server can be…
- WinMySQLadmin - Access Violation I installed xampp on my windows machine last week. When I booted the next time, I got an error popup every few seconds. The error was caused by WinMySQLadmin and was access violation at address…
2008
- MySQL - Select things that happened yesterday SELECT * FROM events WHERE updatedate = DATE_ADD(CURDATE(), INTERVAL -1 DAY) ;
- MySQL- Prevent duplicate key constraint violations Today, I found 3 different ways in MySQL to do an insert in a table without having to check if the key exists. This is mainly used for relationships where the application doesn't care if they…
- Finding the average date in MySQL Today I had to find the average of some dates in MySQL. Took me some googling, but finally found a "bug" report here . Conclusion: use something like SELECT…