(David Ducos) We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect?
Tag: Open Source
Making The Numbers Table Useful
(Cole Kelley) It’s not easy to find a solution to a very simple problem in MySQL: converting a comma separated list of values into rows. Oracle database users find gobs of tutorials on using REGEXP and CONNECT BY LEVEL to make this happen. MySQL doesn’t have that. So, use the numbers table from the
Making The Numbers Table Useful
(Cole Kelley) It’s not easy to find a solution to a very simple problem in MySQL: converting a comma separated list of values into rows. Oracle database users find gobs of tutorials on using REGEXP and CONNECT BY LEVEL to make this happen. MySQL doesn’t have that. So, use the numbers table from the
Hash-based Workarounds for MySQL Unique Constraint Limitations
(Ike Walker) In the past I have written about MySQL’s limitations that prevent you from creating an index over a certain length, or with more than a certain number of columns. I’ve offered some solutions for those problems, but many of my solutions hit another limit further down the line.
Hash-based Workarounds for MySQL Unique Constraint Limitations
(Ike Walker) In the past I have written about MySQL’s limitations that prevent you from creating an index over a certain length, or with more than a certain number of columns. I’ve offered some solutions for those problems, but many of my solutions hit another limit further down the line.
Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly
(Sean Hull) Heterogenous replication involves moving data from one database platform to another. This is a complicated endevour because datatypes, date & time formats, and a whole lot more tend to differ across platforms.
Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly
(Sean Hull) Heterogenous replication involves moving data from one database platform to another. This is a complicated endevour because datatypes, date & time formats, and a whole lot more tend to differ across platforms.
Not Another dbms_redefinition Post
(mdinh) If you follow me on twitter at all, then you will realize I often rant about how demos are too simplistic and do not represent real world issues.
Indexing MySQL JSON Data
(Dave Stokes) “MySQL’s JSON data type is great! But how do you index the JSON data?” I was recently presenting at the CakePHP Cakefest Conference and was asked that very question.
Not Another dbms_redefinition Post
(mdinh) If you follow me on twitter at all, then you will realize I often rant about how demos are too simplistic and do not represent real world issues.
