Changing datatypes on the fly?

2002-03-09 Thread Jarkko Toivonen
I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and inserting data from the old one to it? -Jarkko

How to add date/time to reports?

2002-03-08 Thread Jarkko Toivonen
I was just wondering that how to add date/time to every report run in MySql. I've got a database that contains everything about my home-made beers. I run a select-query sometimes and I want to include the time when it was run in it. So, any ideas? Thanks!