I have a problem when I'm studying the full text search's expansion mode
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...|
| 2 | How To Use MySQL Well | After you went through a ...|
| 3 | Optimizing MySQL | In this tutorial we will show ... |
| 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... |
| 6 | MySQL Security| When configured properly, MySQL ... |
++---+-+
But the expansion mode is explained as follows.
mysql *SELECT * FROM articles*
- *WHERE MATCH (title,body)*
- *AGAINST ('database' IN NATURAL LANGUAGE MODE);*
++---+--+
| id | title | body |
++---+--+
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 1 | MySQL Tutorial| DBMS stands for DataBase ... |
++---+--+
2 rows in set (0.00 sec)
mysql *SELECT * FROM articles*
- *WHERE MATCH (title,body)*
- *AGAINST ('database' WITH QUERY EXPANSION);*
++---+--+
| id | title | body |
++---+--+
| 1 | MySQL Tutorial| DBMS stands for DataBase ... |
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 3 | Optimizing MySQL | In this tutorial we will show ...|
++---+--+
3 rows in set (0.00 sec)
Why not id equals 2 and 4 didn't display in the result.They all include the
word mysql.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Re: I have a problem with MySQL.
If you give more details maybe someone on the list will be able to help. Astghik Barseghian wrote: Hello Philippe, I am trying to use DBMail from MySQL to send and receive messages but I get an SQL sytax error. Could you please tell me is there any way to use the mentioned component, or how can I execute the dll function from MySQL. Thank you. -- http://www.freenet.am/ -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have some problem with Ver 4.0.13
Hi. I used MySQL for over 2 years since ver 3.22 and now use ver 3.23.49 Z9bundle with RedHat 7.3) it work fine and now I decide to upgrade to ver 4 (as production cersion) I download ver 4.0.12 but when I will start to upgrade the new one 4.0.13 launch so I decide to up to 4.0.13 instead of 4.0.12 and install on RedHat 9.0 My problem is when I run query with very simple query the MySQL server often lost connection. (Error 2013 lost connection ...) so I try to install new with 4.0.12 it never get error it work very fine and never get error what happen with 4.0.13. I used to know the same problem occur on RedHat 8 that how to solve is add the line set-variable=thread_stack=256k in my.cnf ( I use with RedHat 8 it work so I try this with RedHat 9 it not work) Now I normaly use RedHat 9 and MySQL 4.0.12. Thanks Kittiphum Worachat. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
have a problem
Hello mysql, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error execute failed: The table 'a' is full What is the meaning of this? My server version: 4.0.12 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: have a problem
Hello, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error execute failed: The table 'a' is full What is the meaning of this? This means that the table is full ;-) You can find possible reasons for that here: http://www.mysql.com/doc/en/Full_table.html If you can't find a reason yourself, you might send the output of the following statement to the list: mysql SHOW TABLE STATUS LIKE 'table1'; This might help us find the reason for your problem. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: have a problem
Hello Stefan, Wednesday, April 02, 2003, 2:27:40 PM, you wrote: Here is table status: +---+++-++-+-+--+---+-+-+-+-++-+ | Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++-++-+-+--+---+-+-+-+-++-+ | linii | MyISAM | Dynamic| 1194745 |130 | 155429332 | 4294967295 | 42998784 | 0 | 3472328119327703312 | 2003-04-02 10:48:27 | 2003-04-02 12:17:14 | 2003-04-02 10:50:26 || | +---+++-++-+-+--+---+-+-+-+-++-+ 1 row in set (0.00 sec) SH Hello, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error execute failed: The table 'a' is full What is the meaning of this? SH This means that the table is full ;-) SH You can find possible reasons for that here: SH http://www.mysql.com/doc/en/Full_table.html SH If you can't find a reason yourself, you might send the output of the SH following statement to the list: mysql SHOW TABLE STATUS LIKE 'table1'; SH This might help us find the reason for your problem. -- Best regards, PandaCoop-Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[3]: have a problem
Hello, Here is table status: +---+++-++-+-+--+---+-+-+-+-++-+ | Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++-++-+-+--+---+-+-+-+-++-+ | linii | MyISAM | Dynamic| 1194745 |130 | 155429332 | 4294967295 | 42998784 | 0 | 3472328119327703312 | 2003-04-02 10:48:27 | 2003-04-02 12:17:14 | 2003-04-02 10:50:26 || | +---+++-++-+-+--+---+-+-+-+-++-+ Hmm. I should have told you to issue SHOW TABLE STATUS LIKE 'linii'\G. \G would produce a more readable output. Anyway: Data_free = 0 says it all. There is no more space in that table, thus MySQL reports the table is full. Most possibly, you have hit a filesystem limit (2 or 4 GB) for the data or the index file of that table. To solve your problem, you could do one or more of the following: a) Use another storage engine for the table, e.g. InnoDB. b) Split up that table into many small once, and create MERGE tables from those smaller MyISAM tables if you need to SELECT from the big table. c) Use another filesystem that supports bigger files. Hope that helps. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have a problem when I try to connect MySQL( on Linux) thru win32
He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got an error message like Error 2013: Lost Connection to MySQL Server during query. I checked the mysqld log file on Server (/var/log/mysqld.log) and I was sure that, when I try to connect to the server, my attempt is received by mysql with an error like: Cannot initialize Innodb as 'innodb_data_file_path is not set. If you do not want to use transactional InnoDB tables, add a line skip_Innodb to the [mysqld] section of init parameters in your my.cnf ... I did it. But still I can't see the databases declared on the mysql (On Linux) from my win2000 PC. Still, on every attempt of connection, a new paragraph is being added to the mysqld.log, now without any error message (mysqld process hanging, pid - killed 020210 03:26:11 mysqld restarted /usr/libexec/mysqld: ready for connection. I am dying to see any databases existing on the Linux server. (In order to be sure that, there is no problem on my client configuration, I installed Mysql win32 version into my friends PC (Win2000).My PC can easily connect and operate the databases that are on my friends PC over network.) Would anyone help me! Cem Yagli // keywords: sql, query - 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: Have a problem when I try to connect MySQL( on Linux) thru win32
Cem, Tuesday, November 26, 2002, 1:13:45 PM, you wrote: CY I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is CY working successfully on the server, and can response all request CY comming on Server. But, when I try to connect to the database thru CY any client running on a Windows 2000 (like MySQLAdmin), I can't CY connect it. CY Firstly, I got an error message like Error 2013: Lost Connection CY to MySQL Server during query. I checked the mysqld log file CY on Server (/var/log/mysqld.log) and I was sure that, when I try to CY connect to the server, my attempt is received by mysql with an error CY like: CY Cannot initialize Innodb as 'innodb_data_file_path is not set. CY If you do not want to use transactional InnoDB tables, add a line CY skip_Innodb CY to the [mysqld] section of init parameters in your my.cnf ... CY I did it. But still I can't see the databases declared on the mysql (On CY Linux) from my win2000 PC. CY Still, on every attempt of connection, a new paragraph is being added to CY the mysqld.log, now without any error message CY (mysqld process hanging, pid - killed CY 020210 03:26:11 mysqld restarted CY /usr/libexec/mysqld: ready for connection. CY I am dying to see any databases existing on the Linux server. CY (In order to be sure that, there is no problem on my client configuration, CY I installed Mysql win32 version into my friends PC (Win2000).My PC can CY easily connect and operate the databases that are on my friends PC over CY network.) What is the version of glibc? There was a bug with 2.2.5-40 glibc, see: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Have a problem when I try to connect MySQL( on Linux) thru win32
He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got an error message like Error 2013: Lost Connection to MySQL Server during query. I checked the mysqld log file on Server (/var/log/mysqld.log) and I was sure that, when I try to connect to the server, my attempt is received by mysql with an error like: Cannot initialize Innodb as 'innodb_data_file_path is not set. If you do not want to use transactional InnoDB tables, add a line skip_Innodb to the [mysqld] section of init parameters in your my.cnf ... I did it. But still I can't see the databases declared on the mysql (On Linux) from my win2000 PC. Still, on every attempt of connection, a new paragraph is being added to the mysqld.log, now without any error message (mysqld process hanging, pid - killed 020210 03:26:11 mysqld restarted /usr/libexec/mysqld: ready for connection. I am dying to see any databases existing on the Linux server. (In order to be sure that, there is no problem on my client configuration, I installed Mysql win32 version into my friends PC (Win2000).My PC can easily connect and operate the databases that are on my friends PC over network.) Would anyone help me! Cem Yagli - 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: Have A problem
Hi Chuck, or take a look at the LEFT() function. =dn Try : SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design and Support. - 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
Have A problem
Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design and Support. - 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: Have A problem
Hi, Try : SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design and Support. - 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
I have a problem....
We are running mysql on a red hat box. We replicate a single database twice, once on another red hat box(thank whatever is holy), once on a winnt box. The winnt box cares not for case sensitivity, so it created all our table names in lower case ( our standard is to use CAPS for tablenames ) ( i knew this was an issue, but I forgot about it when i got a new toy to play with: the nt server ) Now, I did a dump to a development red hat box, and it created all the tables in lower case ( which is useless since our application is geared to the uppercase table names ) Does anyone have a solution or work around for this ? I briefly considered creating a script for the linux box to rename the files but thought I should ask if there was any other way to do this... Luc - 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
I have a problem!
I use phpBB. When I change default character set in mysql I have a problem in phpBB so: Warning: Supplied argument is not a valid MySQL result resource in /../functions.php on line 230 Unable to query db! But /../admin/index.php regularly runs. What my problem is? thanks Edakom Internet Sorumlusu Gokce Akkaya - 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
I have a problem with make.
Please help me. I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when i give the comand make...i have this problem. .. make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql' make[1]: Leaving directory `/usr/local/mysql-3.23.45/libmysql' Making install in client make[1]: Entering directory `/usr/local/mysql-3.23.45/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti - DHAVE_RWLOCK_T -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:680: warning: abstract declarator used as declaration make[1]: *** [mysql.o] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.45/client' make: *** [install-recursive] Error 1 Pleas...help me. Thanks Rodrigo Canales R. Administrador de Laboratorios Instituto Profesional CIISA Fono : 697-2121 - 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
Can you Help me? I have Appostroph problem
Hi, I'm new in mysql, I have a problem in the apostroph, I would write a query like : select ID from table where sentence = 'does't take' Can you help me? ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.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
Re: Can you Help me? I have Appostroph problem
escape the apostrof with a backslash: select ID from table where sentence = 'does\'t take' you should do this for some other characters as well, like the backslash itself. if you'd use php you could use the function 'addslashes()'; basically what you should do to make a string binary-safe is replace the following chars: ' - \' " - \" \ - \\ null - \0 where null is a binary null. gl - Original Message - From: "Sofiane Sakhri" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 16, 2001 11:37 AM Subject: Can you Help me? I have Appostroph problem Hi, I'm new in mysql, I have a problem in the apostroph, I would write a query like : select ID from table where sentence = 'does't take' Can you help me? ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.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
Re: Can you Help me? I have Appostroph problem
select ID from table where sentence = '".does't take."' I think that should do the trick. Or if not...hopefully you're using mysql in combination with some other programming languages like asp or php or...in php you just use addslashes() function bvefore sending a query to mysql. Cheers Siim - 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
