Hi Doug,
What's the MySQL version you're running?
Your SQL query worked fine on my PC. MySQL 3.23.47 Win98SE
Last time I had some problem (that was 3.23.32 I think) when mixing VARCHAR
and TEXT types in the FULLTEXT index.
After upgrading to MySQL 3.23.47, I did not encounter anymore problem lik
Doug,
Can quite see why you have id as a key twice, but...
This worked first time for me (3.23.40-nt).
Regards,
=dn
> Error
>
> SQL-query:
>
> CREATE TABLE quotes (
> id int(9) NOT NULL auto_increment,
> author varchar(255),
> content text,
>