FULLTEXT search questions
Hi there, I am pretty new on MySQL. I am running a website, it needs a fulltext search on the message board. The message board table is setup without the fulltext column now. So when I ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be created? In my table, the 'body' column was define as BLOB, should I change it TEXT before add the new FULLTEXT column? And what is the best to ALTER the column from BLOB to TEXT without messing up the data. Thanks a lot, --Clemson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FULLTEXT search questions
What is the following error? how do I fix it? Thanks, --Clemson mysql alter table message1 add FULLTEXT (Title,Body); ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined as NOT NULL mysql desc message1; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | Title | varchar(64) | YES | | NULL|| | Email | varchar(64) | YES | | NULL|| | Created | datetime| YES | | NULL|| | Body| text| YES | | NULL|| +-+-+--+-+-++ -Original Message- From: Clemson Chan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:06 PM To: Mysql Subject: FULLTEXT search questions Hi there, I am pretty new on MySQL. I am running a website, it needs a fulltext search on the message board. The message board table is setup without the fulltext column now. So when I ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be created? In my table, the 'body' column was define as BLOB, should I change it TEXT before add the new FULLTEXT column? And what is the best to ALTER the column from BLOB to TEXT without messing up the data. Thanks a lot, --Clemson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FULLTEXT search questions
'Body' column was converted from BLOB to TEXT as it shown in the description. How come the FULLTEXT still thinks it is a BLOB? Please tell me if you know any work around. Thanks, --Clemson mysql desc message1; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | Title | varchar(64) | | | || | Email | varchar(64) | YES | | NULL|| | Created | datetime| YES | | NULL|| | Body| text| YES | | NULL|| +-+-+--+-+-++ mysql alter table message1 add FULLTEXT (Title,Body); ERROR 1073: BLOB column 'Body' can't be used in key specification with the used table type -Original Message- From: Clemson Chan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 2:13 PM To: Mysql Cc: Clemson Chan Subject: RE: FULLTEXT search questions What is the following error? how do I fix it? Thanks, --Clemson mysql alter table message1 add FULLTEXT (Title,Body); ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined as NOT NULL mysql desc message1; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | Title | varchar(64) | YES | | NULL|| | Email | varchar(64) | YES | | NULL|| | Created | datetime| YES | | NULL|| | Body| text| YES | | NULL|| +-+-+--+-+-++ -Original Message- From: Clemson Chan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:06 PM To: Mysql Subject: FULLTEXT search questions Hi there, I am pretty new on MySQL. I am running a website, it needs a fulltext search on the message board. The message board table is setup without the fulltext column now. So when I ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be created? In my table, the 'body' column was define as BLOB, should I change it TEXT before add the new FULLTEXT column? And what is the best to ALTER the column from BLOB to TEXT without messing up the data. Thanks a lot, --Clemson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: interesting find
Thanks. I will try to relax now. But I didn't do any work today. :) --Clemson Do you know the answer to my BLOB/TEXT question I posted earlier. I altered a BLOB column to TEXT, but FULLTEXT still thinks it's a BLOB. What do I do to use this column in FULL TEXT? Thanks. -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 3:27 PM To: Clemson Chan Cc: Mysql Subject: Re: interesting find Clemson Chan wrote: The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET] (appointed by MySQL.com). http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql- 3.23.52-win.zip I realized that these two html (manual.html and manual_toc.html) files in the docs folder has this information in the source. = !-- This HTML file has been created by texi2html 1.52 (hacked by [EMAIL PROTECTED]) from manual.texi on 12 August 2002 -- = Is MySQL creating these documentation using a hacked version of software? Uhh, no. It means it's been patched by [EMAIL PROTECTED] to do something different than the stock texi2html (which is open source, btw, see http://www.mathematik.uni-kl.de/~obachman/Texi2html/) Those of us that do work in the non-Microsoft world usually use mostly open-source software, because that's just the way it is. You won't usually find a lot of warez being used by Unix people, because there really isn't that much to crack (which is different than hack btw), because you can get pretty much everything you need/want (including MySQL in most cases) without cost, legally :) It's Friday. Maybe you should go relax a little :) -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php