Column data type maximums?

MySQL version - 4.0.13 MySQL Control Center - 0.9.2 beta I'm interested in storing a lot of plain text. I know varchar2 has a limit of 255 characters. I want to store characters in excess of 800 and even closer to 1000.' I've tried varchar2, text and longtext. My size that I'm trying is 713

Re: Column data type maximums?

Yes, probably due to limitations of the Control Center. I also tried BLOB and I get the same results. Thanks Brent Baisley

My query string might be too long

Is there a line limit to a query in MySQL? ( I couldn't find this in the MySQL manual) Here is my query: SELECT a.field_name, b.field_option, c.project_name FROM field_master a, field_options_master b, project_master c where a.field_option_id = b.id and a.project_id=b.project_id and

Re: Newbie - How can I insert new data with the current date/time?

Thanks Paul, that works great. Yes, I meant to say the table animals, not bug_master. Paul DuBois

RE: Newbie - How can I insert new data with the current date/time?

Great, this is more of what I was looking fora way to have the DB auto populate the date/time in a column, without having to use sql. Thanks again! Uttam

Newbie - How can I insert new data with the current date/time?

I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL,