Question : My app has a list of an external db’s tables and it needs to be regularly updated. How […]
Bypass MyISAM table lock
Question : I have a big MyISAM table with a fulltext index for searching. Problem is that inserting data into […]
MySQL, wait_timeout, Mac OS X Mountain Lion – how do i set it?
Question : I need to change the wait_timeout for my MySQL database, but when I set this parameter in the […]
What’s better/faster? MySql or FileSystem?
Question : Let’s imagine a web site that is a directory of people. For each person there may be a […]
Is it possible to count non-null columns within each row?
Question : Suppose this data: id firstname surname val1 val2 val3 1 joe blogs 1 (null) (null) 2 jane doe […]
Why is `p1.name BETWEEN ‘a’ AND ‘az’` skipping over names that start with “Aztec”
Question : I’m quite confused with these two SQL queries I’m not getting the same results where, there are several […]
How to set up triggers in MySQL for copying a field
Question : I have an in-house application that I’ve put together, and I’m VERY new to SQL in general. I […]
selecting and Inserting data from two different servers
Question : I have two server mysql and psql. I am fetching data from mysql server database table and inserting […]
How to join different tables with same propriety tables?
Question : Which would be the best solution to join 4 different tables with X tables that has to be […]
Alter table with casting
Question : Is there a way of run an alter table command with cast on MySQL databases? I know that […]