2014/11/04 11:04 -0800, Jan Steinman
I was not suggesting it for dates. The OP appeared to have a well-defined set
of strings in a VARCHAR field  THAT is what I suggested ENUMs for!
What is the update frequency of those VARCHARs? If you're adding them often Â
or if you need to
2012/07/24 08:46 -0700, Hassan Schroeder
On Mon, Jul 23, 2012 at 5:58 AM, wrote:
> I thought I would try YEAR to record it--but, in spite of
> http://dev.mysql.com/doc/refman/5.5/en/year.html , simply assigning NOW() to
> such a type does not work.
Not sure I understand the issue:
O, and the algorithm that I described only then works when the graph is
cycle-free. Otherwise it forever runs.
**
Scanned by MailScan AntiVirus and Content Security Software.
Visit http://www.escanav.com for more info on eScan and X-Spa
2012/05/25 10:07 -0500, Andrés Tello
You have a typical hierarchical data issue, can be solved with a graph.
Theory review: http://www.algorithmist.com/index.php/Graph_data_structures
Mysql and PHP implementation:
http://www.phpro.org/tutorials/Managing-Hierarchical-Data-with-PHP-and-My