Posts Tagged ‘MySQL’
What is debian-sys-maint?
Posted by: Vijay Dev on: October 11, 2009
Recently, when we were moving our staging applications and databases to a different server (from Win 2003 to Ubuntu 9.04), we had two problems with the MySQL server.
One, easy to fix, was the case-sensitive nature of table names. Using lower_case_table_names=1 in /etc/mysql/my.cnf fixed the problem.
The other problem riddled the server startup and shutdown (even server [...]
SQL Collations & Case Sensitive Searches
Posted by: Vijay Dev on: April 14, 2009
I got a question recently from a friend about doing case sensitive searches in SQL and I did not know the answer !! I knew that ORM’s like Django have operators such as ILIKE to do this, but I do not know how to do this in raw SQL. So I started looking for ways [...]
Updates in MySQL and PostgreSQL
Posted by: Vijay Dev on: October 25, 2008
I use MySQL and MS SQL at work and have never used PostgreSQL. So it was a nice learning about the evaluation of the update queries in MySQL and PostgreSQL today..
Seems that UPDATE table SET X=Y, Y=X is enough in PostgreSQL to swap two columns !! It just picks up the old values of [...]
- A Chrome OS Review: [...] Chrome OS Review A Chrome OS review at Exploring Thoughtz The OS is targeted at those who use computers almost solely for accessing the Interne
- Masoom: That was some refreshing screenshots, Is Google chrome available for download for beta testers? Or do you have to built with the API Available? Being
- Vijay Dev: There is no visible booting at all :) Its a snap, exactly like how Chrome browser opens! The most delay I have experienced would be about 10s.
I like
- Top 20+ MySQL Best Practices
- Remembering 26/11 – the Mumbai Terror Attacks
- .nodeName Case Sensitivity
- Mastering Grub 2 The Easy Way
- Free Virtualization Software for your Windows PC
- Summary of all the MIT Introduction to Algorithms lectures
- Google Dashboard
- Movie Narrative Charts
- Unlock Hidden Mac OS X Settings With Secrets
- Easy Version Control with Git
