Feuere Deinen Boss!!!
Feuere Deinen Boss ! Warum immer wieder fr andere arbeiten, wenn Sie DM 2.000,- pro Woche fr sich selbst haben knnen ! Weitere Informationen nur unter: [EMAIL PROTECTED] - 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
test
test - 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: Replication troubles
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote: I have two machines which I am trying to set up replication on. I followed the howto as describe in the manual, and everything seemed to be okay (i.e. no errors), but it simply doesn't work. Heres what I did on the master: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else 3. Granted file to user repl as in howto 4. Shut down master 5. Tarred data dir, copied it to slave 6. Restarted master Heres what I did on the slave: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. Added following info: master-host = 172.34.123.34 # IP of master master-user = repl master-password = repl master-port = 3306 server-id = 2 3. Untarred data directories to /var/lib/mysql 4. Verified permissions on directories/files untarred 5. Restarted slave The my.cnf file appears to be read okay, because on both machines began generating the binary log files immediately. Both machines report everything normal and happy, with no entries in the .err log files. Users can connect to each machine independently and its business as usual. There is no file 'master.info' generated on the slave (I even checked on the master too)... That's sort of strange... Does "SHOW SLAVE STATUS" on the slave say anything interesting? What if you do a "SLAVE START" on the slave? You're sure that there is literally nothing related in the *.err file on the slave? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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[32]: Warning: Got signal 14 from thread X
Monty and Alex, maybe Monty discovered the source of the problem: Innobase indeed modifies the sigmask of the thread which does the database intialization. Maybe other threads then inherit the modified sigmask. I had disabled the use of native Unix aio from Innobase, but forgot the following segment of code into /innobase/os/os0file.c, about line 920 in function os_aio_init: . } #ifdef POSIX_ASYNC_IO /* Block aio signals from the current thread and its children: for this to work, the current thread must be the first created in the database, so that all its children will inherit its signal mask */ sigemptyset(sigset); sigaddset(sigset, SIGRTMIN + 1 + 0); sigaddset(sigset, SIGRTMIN + 1 + 1); sigaddset(sigset, SIGRTMIN + 1 + 2); sigaddset(sigset, SIGRTMIN + 1 + 3); pthread_sigmask(SIG_BLOCK, sigset, NULL); #endif } . Alex, try commenting out those lines, and check if the signal 14 error still occurs. Regards, Heikki - 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: Memory leakage? With MySQL GUI v1.7.4-1
Aidan McGuinness writes: Hello, I've encountered a problem with MySQL GUI 1.7.4.-1. I'm not quite sure what triggers the error - whenever its open Ive had a MySQL server (3.22) running, as well as Java Forte Editor (v2.0) and Internet Explorer (v5.5). The problem is fairly nasty and I only detected it with TaskInfo 2000 - MySQL GUI suddenly starts eating up all available memory (I've 256mb - more than enough to be running all the applications). The "eating up" of memory is extremely rapid - and often causes the OS (Win 98) to crash which could cause loss of data (and is an inconvience either way). As it doesnt happen with other applications I presume this is a bug in MySQL GUI - is there any word on this? Or a fix in a newer release? Thanks, Aidan Hi! I thoroughly check memory leakage on every version of mysqlgui. MySQL client library is checked with Purify, while MySQL++ and mysqlgui are thoroughly checked with LeakTracer, as there is no malloc and free in mysqlgui, only new and delete. It is possible that some of the apps you mentioned have changed some system libraries so that some problems occur. I would also like to point out that it is first time that I have received such report on mysqlgui. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: compile error (MacOS-X retail version)
Thanks, this worked like a charm. Also on the 3.23.25 (declared stable) release. now i have another problem: when is start the safe-mysqld i cannot shut it down anymore. # mysqladmin -u root -p shutdown or # safe-mysqld --log just do nothing and the terminal doesn't do anything anymore. a 'kill' does nothing also. processviewer won't let me kill the process either unless i am logged in as root. further i was wondering if there is a techtips website were we can post tips and tricks on OS-X or maybe you have a webspace where we can start such an effort. Gerhard Paul DuBois wrote: ... There was a problem compiling sql/mysqld.cc at line 1232: sa.sa_handler=( void (*)() ) handle_segfault; This has to be changed to: sa.sa_handler=( void (*)(int) ) handle_segfault; ^^^ Then the compile finished with no problems. ... Paul DuBois, [EMAIL PROTECTED] - 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
F1 on win-32 MySQL GUI client
I cannot get F1 to show any help on the main display. I cannot even determine why it does not. I have the help_file set in every variation of .cnf .ini and .opt file I can find. No luck. What is correct way to get help to be useable? TIA, W. Terry Lincoln Senior Engineer/Consultant 100 Courtshire Lane Penfield, NY 14526-2678 [EMAIL PROTECTED] htmlbodya href="http://counter.li.org/"img src="http://sequitur.dyndns.org/icons/lru-99583.gif" alt=Linux Registered User #99583"/a/body/html - 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: F1 on win-32 MySQL GUI client
w. Terry Lincoln writes: I cannot get F1 to show any help on the main display. I cannot even determine why it does not. I have the help_file set in every variation of .cnf .ini and .opt file I can find. No luck. What is correct way to get help to be useable? TIA, W. Terry Lincoln Senior Engineer/Consultant 100 Courtshire Lane Penfield, NY 14526-2678 [EMAIL PROTECTED] Hi! In your C:\my.cnf, you should have entries, like the following ones: [client_fltk] help_file=d:/guiclient/doc/MySQL.help client_file=d:/root/MySQL.options # The following items are optional. They can be saved from MySQLGUI too ! history_length=20 database = telcent queries_root=d:/root/queries last_database_file=d:/root/ladb Please do note the usage of / instead of \. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
GUI
Why is the table of columns off by 1 ? The registration seems to bypass the privileges column. Thanks ~~~jci~~~ - 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
New complete Innobase manual now at www.innobase.fi
Hi! I have completed the writing of the new Innobase manual. It will also appear as a section in the MySQL manual. Best regards, Heikki Tuuri Innobase Oy - 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
Installation on Solaris.
Hi... I am new to MySql and I have a couple of questions. First, I am assuming that one needs root priviledge to install the DB Server on Solaris for example. Second, I looked at the manual and searched for any recommendations about the machine requirements for running the DBServer but couldn't find anything useful in this regard. What is the needed free diskspace and the memory also. Thanks alot. Any help is greatly appreciated. Abdel-Hameed. ECE dept. University of Maryland. - 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: Does repliation impact on performace?
On Sun, Mar 25, 2001 at 10:21:04AM -0700, Brendin wrote: Lets say you have to mysql servers one is going to be a master and one a replication slave. The master is a very fast dual CPU machine with a SCSI raid array. The Slave is a fast single cpu machine with a 7200RPM UDMA 100 hard drive. The slaves purpose is to act as a backup for the master. Will the slave slow down the master server? Is the performace of a master server in any way dependant upon the performace of its slaves? In my experience, the slave places a negligible load on the server. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
inserting into mysql database in linux using C
I am a senior in Polytechnic University working on my senior project. I have chosen MySQL to be database in Red Hat linux 7.0. I writing a program to insert a value into the database in c language. The data changes so i have to insert the data as a variable, but the database reports a error saying that the data is a column, the code is something like this.. int main(int argc, char **argv) { .. char* test; test="abcd"; int res; MySQL *connection; res=mysql_query(connection, "INSERT INTO tablename (userid) VALUES(test)); } I get an error saying "Insert error 1054, unknown column 'test' in 'field-list' __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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: inserting into mysql database in linux using C
On Sun, 25 Mar 2001 12:56:15 -0800 (PST), john lin [EMAIL PROTECTED] wrote: John, I'm not a 'C' programmer, but I think you need to enclose your VALUE with single quotes for a literal value: VALUES('test') Atleast in Perl, it' done that way. I am a senior in Polytechnic University working on my senior project. I have chosen MySQL to be database in Red Hat linux 7.0. I writing a program to insert a value into the database in c language. The data changes so i have to insert the data as a variable, but the database reports a error saying that the data is a column, the code is something like this.. int main(int argc, char **argv) { .. char* test; test="abcd"; int res; MySQL *connection; res=mysql_query(connection, "INSERT INTO tablename (userid) VALUES(test)); } I get an error saying "Insert error 1054, unknown column 'test' in 'field-list' Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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: inserting into mysql database in linux using C
On Sun, Mar 25, 2001 at 12:56:15PM -0800, john lin wrote: I am a senior in Polytechnic University working on my senior project. I have chosen MySQL to be database in Red Hat linux 7.0. I writing a program to insert a value into the database in c language. The data changes so i have to insert the data as a variable, but the database reports a error saying that the data is a column, the code is something like this.. int main(int argc, char **argv) { .. char* test; test="abcd"; int res; MySQL *connection; res=mysql_query(connection, "INSERT INTO tablename (userid) VALUES(test)); } I get an error saying "Insert error 1054, unknown column 'test' in 'field-list' I never used the C API for MySQL, but since I do know C and MySQL a bit, I'll have a shot at this. It says that test is NOT a column, but you use it as if it were a column. If you meant to use the variable test (i.e. "abcd") then MySQL doesn't know about it because it is a C variable. You would need to expand it into the query with snprintf for example: char q[500]; snprintf(q, sizeof(q), "INSERT INTO tablename(userid) VALUES('%s')", test); res = mysql_query(connection, q); Note the quotes around the %s. Also note that this is a simplified example. If test contains special characters, like non-printable characters or quotes, you'll need to escape them. Maybe the C API has a function to do that for you, but you'll need to look it up. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
Site of Mysql DBI module for Windows 95 required.
I am a college student trying to implement MySql with perl 5.6 on Windows 95. My problem is I have not been able to find a suitable site to download the DBI module from. I am very wary of downloading any module which requires me to use a make command (in what ever manifestation) and would prefer to use the ppm module in the perl distribution. Can anybody point me in the right direction? I have tried www.tcx.se for the past week but the server always seems to busy. Thanks in advance Mark Polden (a new subscriber) - 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[32]: Warning: Got signal 14 from thread X
Hi! "Heikki" == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Monty and Alex, Heikki maybe Monty discovered the source of the problem: Innobase indeed Heikki modifies the sigmask of the thread which does the database intialization. Heikki Maybe other threads then inherit the modified sigmask. Heikki I had disabled the use of native Unix aio from Innobase, but forgot Heikki the following segment of code into /innobase/os/os0file.c, Heikki about line 920 in function os_aio_init: Heikki . Heikki } Heikki #ifdef POSIX_ASYNC_IO Heikki /* Block aio signals from the current thread and its children: Heikki for this to work, the current thread must be the first created Heikki in the database, so that all its children will inherit its Heikki signal mask */ Heikki sigemptyset(sigset); Heikki sigaddset(sigset, SIGRTMIN + 1 + 0); Heikki sigaddset(sigset, SIGRTMIN + 1 + 1); Heikki sigaddset(sigset, SIGRTMIN + 1 + 2); Heikki sigaddset(sigset, SIGRTMIN + 1 + 3); Heikki pthread_sigmask(SIG_BLOCK, sigset, NULL); Heikki #endif Heikki } Heikki . Heikki Alex, try commenting out those lines, and check if the signal 14 error Heikki still occurs. I have now removed the above lines for MySQL 3.23.36! Regards, Monty - 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
Default Date value
Title: Blank I am trying to set the default value in a date field to be the time that it was created However I do not want the field to be a timestamp because I want to update it to a different value later. I have looked through the mysql documentation and I can not seem to find anywhere that explains how to set the default value of a column = to a function. Anyone have any help? Thanks in advance Michael BloodMatraex Technologies[EMAIL PROTECTED]
Re[2]: MySQL vs Microsoft SQL
Gotta say that this is a bad reason to choose one product vs. another... because it lacks a GUI to build queries? Undertanding SQL is all well and good, but I can tell you that I would give anything to have a query builder that works like the one for MS SQL server. You may enjoy writing incredibly long join queries because it demonstrates your understanding of SQL syntax. Personally, I'd rather spend my time watching grass grow. What is the value of doing something in code which is inherently visual, and is a lot easier to do visually? A query builder will not make a database developer out of a novice, but it can make a professional developer's job a lot easier. I can spend my time writing complex code that can't be done with a tool, and not waste it doing repetitive, boring joins that take a few seconds with a visual tool. I am not arguing for MS SQL Server vs. SQL server, I just think having tools is better than not having them. You would always be free to write your MS SQL Server code by hand... Here's looking forward to the future Mascon release that includes a query builder... Jamie At Friday, March 23, 2001 on 6:58:26 PM, you wrote: Not only that, but mySQL "forces" you to learn SQL. Not by wizards that build the SQL statement for you. Like J. Zawodny says, if it meets your needs, then do it. - 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: Default Date value
BlankI don't think you can do that with a default value. You will need to include the current date in your insert statement. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 5:30 PM To: MYSQL Subject: Default Date value I am trying to set the default value in a date field to be the time that it was created However I do not want the field to be a timestamp because I want to update it to a different value later. I have looked through the mysql documentation and I can not seem to find anywhere that explains how to set the default value of a column = to a function. Anyone have any help? Thanks in advance Michael Blood Matraex Technologies [EMAIL PROTECTED]
New MySQL install Help Please
New MySQL install Help Please Is there a MySQL UseNet news group or User to User Forum anywhere? Just installed latest MySQL and tried to then install the latest MySQL ODBC Following the main install I was surprised I didn't find any icons on my desktop or in my Windows Start Programs listing, but I will worry about that tomorrow. I'm running Windows 98 SE Multiple times I tried to install the ODBC by running setup.exe from the download. I even redownloaded the ODBC from MySQL Site. I get the error message An error occurred when copying C:\WINDOWS\SYSTEM\MFC30.DLL I thought maybe the system was preventing the install from installing a version older than what I have on my machine, but I checked, and they are the same version. The file is not write protected. I tried rebooting and it did no good. I'm assuming I should not ignore the error message and that other files either failed to copy, or were not even given a chance. Appreciate any help you can give. John Jackson [EMAIL PROTECTED] - 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: New MySQL install Help Please
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 8:29 Subject: New MySQL install Help Please New MySQL install Help Please Is there a MySQL UseNet news group or User to User Forum anywhere? This mailing list is it. Just installed latest MySQL and tried to then install the latest MySQL ODBC Following the main install I was surprised I didn't find any icons on my desktop or in my Windows Start Programs listing, but I will worry about that tomorrow. I'm not. Not everything is windoze based. You need to start it from DOS. I'm running Windows 98 SE Multiple times I tried to install the ODBC by running setup.exe from the download. I even redownloaded the ODBC from MySQL Site. I get the error message An error occurred when copying C:\WINDOWS\SYSTEM\MFC30.DLL I had no problems installing it. Try shutting down as many applications as you can, including the mysql server then try reinstalling. I thought maybe the system was preventing the install from installing a version older than what I have on my machine, but I checked, and they are the same version. The file is not write protected. I tried rebooting and it did no good. I'm assuming I should not ignore the error message and that other files either failed to copy, or were not even given a chance. Appreciate any help you can give. John Jackson [EMAIL PROTECTED] - 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
Ïðàâèëüíàÿ ðåãèñòðàöèÿ
Ðåãèñòðàöèÿ â 30 Ðîññèéñêèõ ïîèñêîâûõ ñèñòåìàõ è êàòàëîãàõ - 30$. Ðåãèñòðàöèÿ â 20 ìåæäóíàðîäíûõ ïîèñêîâûõ ñèñòåìàõ è êàòàëîãàõ - 20$. Ðåãèñòðàöèÿ ñàéòà â ïîèñêîâûõ ñèñòåìàõ Rambler.ru, Yandex.ru ñ ïîÿâëåíèåì Âàøåãî ñàéòà íà ïåðâîé ñòðàíèöå çàïðîñà ïî Âàøèì êëþ÷åâûì ñëîâàì - äîãîâîðíàÿ. - 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 for 2 words close to each other
Hi! On Mar 25, Ovanes Manucharyan wrote: Hello, I am trying to search for 2 words which are close to each other.. In fact, its a name so it should either occur as John, Doe or John Doe in my fulltext index.. (this particular table is full of emails) select id,message_subject from email WHERE MATCH(message_body,message_subject) against ("John Doe") limit 10; The search returns very unrelated messages... sometimes messages containing only John, sometimes messages containing only Doe.. Only one of the messages returned contained "John Doe" together. Is there a way of telling mysql that these 2 words should occur in close proximity to each other.. If not what workarounds could I employ to get my search completed? Sincerely, Ovanes Here's a workaround: select id,message_subject from email WHERE MATCH(message_body,message_subject) against ("John Doe") and concat(message_body,message_subject) like "%John Doe%"; limit 10; Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Coredump on quickly disconnecting clients
On Sunday 25 March 2001 16:27, you wrote: Found the problem with your signal 11 with strange traces from inside LinuxThreads. This was a hard concurrency bug - the problem was that a memory reference passed to pthread_create was getting invalidated by the thread that pthread_create was launching before pthread_create would right to that value. Took me a while to figure this out - I have scrutinized the entire thread creation mechanism in LinuxThreads suspecting a bad mmap or munmap somewhere before I realized the problem had nothing to do with LinuxThreads internal code. I believe the problem has existed for as long as MySQL has been around - back then the machines were just not fast enough to make this condition happen frequently enough for someone to be able to create a repeatable case. I have fixed it by extending the critical region. Here is the patch: Fantastic! I take it you won't be wanting the better back trace then? I'll get back to you once I've confirmed that it's fixed it in our case. Thanks a lot for the help. You guys rock. -- Voytek Lapinski [EMAIL PROTECTED] Software Engineer Hotkey Internet ph: 03 9923 3656 mob: 0427 469 891 fax: 03 9923 3388 www.hotkey.net.au - 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
SELECT... ORDER BY RAND() LIMIT x FAILS
Description: The documentation says that I can do: select * from table order by rand() limit 10 as an example, however it fails and there is no error message. I *can* do: select * from table order by rand() which works fine. It just seems that adding the limit clause causes something to break. How-To-Repeat: Easy way: mysql mysql select * from users order by rand() limit 10 On my database machine using the latest stable binray release it fails. Fix: None known Submitter-Id: submitter ID Originator:Shawn Wallace Organization: Justweb Inc. MySQL support: [none | licence | email support | extended email support ] Synopsis: Problem combining order by rand() with limit Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.35 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.35 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 hours 56 min 1 sec Threads: 3 Questions: 160022 Slow queries: 0 Opens: 106 Flush tables: 1 Open tables: 100 Queries per second avg: 7.491 Environment: System: Linux darthvader 2.2.18pre21-RAID #2 Wed Feb 14 17:21:03 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 12 13:22 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 887712 Jan 15 15:06 /lib/libc-2.1.3.so -rw-r--r--1 root root 2089496 Jan 15 15:07 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:07 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - 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
Usage of list address
I suggest everybody to put the '[EMAIL PROTECTED]' list's address to the "TO" email field instead of the "CC" field, when posting messages to this list. This would allow several email clients (like Microsoft Outlook) to filter better the incoming messages and categorize them to specific folders as appropriate, according to predefined rules. As this list seems to be very busy and interesting, I think that this would help us to manage better our email and avoid us of getting lost into a huge unsorted list of many many msgs of different subjects and areas. Thank you all, Yiannis - 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: Usage of list address
Just use this type of filter for outlook express Apply this rule after the message arrives Where the To or CC line contains '[EMAIL PROTECTED]' Move it to the General folder - Original Message - From: Yiannis Manatos To: [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 10:32 PM Subject: Usage of list address I suggest everybody to put the '[EMAIL PROTECTED]' list's address to the "TO" email field instead of the "CC" field, when posting messages to this list. This would allow several email clients (like Microsoft Outlook) to filter better the incoming messages and categorize them to specific folders as appropriate, according to predefined rules. As this list seems to be very busy and interesting, I think that this would help us to manage better our email and avoid us of getting lost into a huge unsorted list of many many msgs of different subjects and areas. Thank you all, Yiannis - 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
table output display
Hi guru type folks, My system crashed over the weekend and I had to reinstall linux. I'm currently running Mandrake 7.2. Now that I'm up and running again I find that the output from a mysql query is not formatted properly. The tables look as though they are wrapping round so that data does not sit under column headers and that the lines are all over the place. I even installed the latest mysql stable version last night, but still have this strange looking output on screen. This happens even when there are only two columns on the select command. Is there some way to fix this problem? Any help greatly appreciated as I can't make sense of the on-screen display. Cheers Stan Bordeaux Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [EMAIL PROTECTED] - 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: Usage of list address
We have had this discussion once before. There is no way to police it. It is a matter of learning how use your e-mails filtering system properly. - Original Message - From: "Yiannis Manatos" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 11:32 Subject: Usage of list address I suggest everybody to put the '[EMAIL PROTECTED]' list's address to the "TO" email field instead of the "CC" field, when posting messages to this list. This would allow several email clients (like Microsoft Outlook) to filter better the incoming messages and categorize them to specific folders as appropriate, according to predefined rules. As this list seems to be very busy and interesting, I think that this would help us to manage better our email and avoid us of getting lost into a huge unsorted list of many many msgs of different subjects and areas. Thank you all, Yiannis - 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: Usage of list address
If you go through the rules wizard in outlook 2000, you should be able to see the to or cc option, I was. If you need a screen shot, email me personally and I can send you the images. - Original Message - From: Yiannis Manatos To: 'David Brieck' ; 'Rolf Hopkins' ; [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 11:11 PM Subject: RE: Usage of list address I posted that msg because I still cannot find any "Where the To or CC line contains .." rule expr, at Outlook 2000. I had only a "Where the To line contains .." available. Anyway, I will try to find an alternative. Thank you both -Original Message- From: David Brieck [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:42 AM To: Yiannis Manatos; [EMAIL PROTECTED] Subject: Re: Usage of list address Just use this type of filter for outlook express Apply this rule after the message arrives Where the To or CC line contains '[EMAIL PROTECTED]' Move it to the General folder - Original Message - From: Yiannis Manatos To: [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 10:32 PM Subject: Usage of list address I suggest everybody to put the '[EMAIL PROTECTED]' list's address to the "TO" email field instead of the "CC" field, when posting messages to this list. This would allow several email clients (like Microsoft Outlook) to filter better the incoming messages and categorize them to specific folders as appropriate, according to predefined rules. As this list seems to be very busy and interesting, I think that this would help us to manage better our email and avoid us of getting lost into a huge unsorted list of many many msgs of different subjects and areas. Thank you all, Yiannis - 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: Default Date value
Is it possible to set a function as a default value for a column at all. I apologize if I come off a bit dumb about this but I come from an MSSQL background where you can set a default to a function. Thanks Again -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 4:06 PM To: Michael Blood; MYSQL Subject: RE: Default Date value BlankI don't think you can do that with a default value. You will need to include the current date in your insert statement. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 5:30 PM To: MYSQL Subject: Default Date value I am trying to set the default value in a date field to be the time that it was created However I do not want the field to be a timestamp because I want to update it to a different value later. I have looked through the mysql documentation and I can not seem to find anywhere that explains how to set the default value of a column = to a function. Anyone have any help? Thanks in advance Michael Blood Matraex Technologies [EMAIL PROTECTED] - 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