Mark Sibly wrote:
>Hi,
>
>I'm new to this list, and have a few basic MySql questions:
>
>* Is it safe to convert a timestamp field to a datetime one? ie: will this
>'touch' each row and stuff up the ordering (hopefully not!).
>
What happend when you tried it on a test table?
>
>
>* I'm building a BBS application that needs to keep track of 'child counts'.
>Currently, I'm using integer 'count' fields for this and manually updating
>'parent' counts where necessary. Would it be better to just use 'count(*)'
>instead where possible? Would this be slower? If I index the fields to be
>counted, would this end up wasting/saving disk-space?
>
>Finally...MySql is GREAT! I have a complete BBS application up and running,
>coded 'from scratch' with no prior SQL knowledge based just on the MySql
>package and docs. Of course, its now in dire need of cleaning up!
>
>Sincerely,
>Mark Sibly,
>Blitz Research Ltd
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread119075@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
