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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php