List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 9 2002 2:05pm
Subject:Re: newbie questions...
View as plain text  

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
>
>


Thread
newbie questions...Mark Sibly9 Sep
  • Re: newbie questions...Gerald Clark9 Sep