Yes, probably due to limitations of the Control Center. I also tried BLOB and I
get the same results.
Thanks
Brent Baisley
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
charac
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
a.project_id='1
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
Thanks Paul, that works great.
Yes, I meant to say the table animals, not bug_master.
Paul DuBois
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,
PRIMARY
