Re: Update log
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 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 > > > > __ > Do you Yahoo!? > The all-new My Yahoo! - What will yours do? > http://my.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Update log
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 __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to get Previous date
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 86400 to get previous day) How can I get the previous date ID DATE ProductName PRICE Last 01 1/1/04 ProductABCD 1500 NO 02 1/1/04 ProductABCD 1600 YES 03 1/2/04 ProductABCD 1000 NO 04 1/2/04 ProductABCD 1100 YES 05 1/4/04 ProductABCD 1900 NO 06 1/4/04 ProductABCD 1800 NO Report required for 1/4/04 Previous Price : 1100 (ID: 04) 05 1/4/04 ProductABCD 1900 NO 06 1/4/04 ProductABCD 1800 NO How do I Get 1100? __ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
verbose
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 do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
binary column type
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. __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]