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!). * 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
