'Tips & Tricks' Category

• The OpenArk Kit

  March 25, 2010

  Shlomi Noach is DBA,  authorized MySQL instructor software developer and Winner of the MySQL Community Member of the Year, 2009. He has published his own collections of MySQL scripts and you might find them useful.  Shlomi calls them the “openark kit“. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. [...]

  posted in Tips & Tricks by mark

• Loading Bulk CSV Tables

  March 23, 2010

  In my job I use many data tables that are transient.  New weather data is received all the time and old data is purged.  Most of these table are received as CSV files.  The data is then loaded into MySQL tables and indexed to be used with geographic queries. Most of these tables never see [...]

  posted in Tips & Tricks by mark