Update log

2005-01-06 Thread Chenri J
i'm still using 3.23 can anyone show me how to activate update log by modifying the my.cnf/ my.ini And a question about update log, does it only record update and delete (mysql documentation), how about insert? do the log recorded those too? thanks

Re: Update log

2005-01-06 Thread Chenri J
one more question, how about when i'm using 'BEGIN' and doesn't end it with 'COMMIT' neither 'ROLLBACK' what will happen. I've tried before and nothing happen but does anyone have an opinion? --- Chenri J [EMAIL PROTECTED] wrote: i'm still using 3.23 can anyone show me how to activate

how to get Previous date

2004-12-24 Thread Chenri J
I have a price table entered more than once every day, In the report for spesific day, I must show also the last entered price for the day before The problem is that the day before sometimes varies not fixed (if it is fixed I could just round down the required date substract the date with

verbose

2004-12-22 Thread Chenri J
can anyone tell me about what verbose mode mean? is it Uppercase or Lower case matter or something with backtick? By the way what do backslash for in mysql query? Thanx guys __ Do you Yahoo!? Yahoo! Mail - You care about security. So

binary column type

2004-11-26 Thread Chenri J
What is 'binary' in column type stand for? is it describe how the data is stored (in biner value)? what do we want use it for? - encryption ? - space efficiency ? - fast index ? - or ? I've searched the mysql manual but didn't find any clue about it thanks for your help before.