Re: default password?
Are you running at as root? David Loszewski wrote: it tells me that I'm missing a command if I take away the -p Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Guray Sunamak Sent: Saturday, April 14, 2001 3:27 AM To: David Loszewski Cc: [EMAIL PROTECTED] Subject: Re: default password? Do not include "-p". Then it won't ask you a password David Loszewski wrote: After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the american How do I fix it? thx, DAVE - 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 -- Guray Sunamak \\\|/// [EMAIL PROTECTED] \\ - - // computer turtle @Samtek-Itc Ankara/Turkey ( 0 0 ) ICQ# 73827870 -oOOo-(_)-oOOo- -- Guray Sunamak \\\|/// [EMAIL PROTECTED] \\ - - // computer turtle @Samtek-Itc Ankara/Turkey ( 0 0 ) ICQ# 73827870 -oOOo-(_)-oOOo-
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
Re: mysqlgui: help.
[EMAIL PROTECTED] writes: I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what password it want? Tank you in advance, Mario. Hi! All you have to do is follow README that came with that distro. Here is an excerpt: When you start it for the first time, click on ``Options'' button, fill up all entries correctly and click on ``Save'' button. From then on, you will logon automatically to the running server on every mysqlgui startup. Take care to put the right value in ``Ask for password'' button. Also, if you have problems with location of socket files on *nix, enter a full path of the socket file in the ``SQL command on the start-up''. This input field is used on Windoze if you wish to specify that named pipe option. 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: Can't build mysqlgui-1.7.5
David Relson writes: At 11:42 AM 4/15/01, Sinisa Milivojevic wrote: Sinisa, I have fl_editor-0.4.1, which I downloaded, configured, and built today. There is no edfile.o. I have run command 'find . -name "edfile.*"' to locate it and found nothing. David David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 Hi! It should be there. What does `find . -name '*.o' -print' return ?? Also, if you are on Linux, you do not have to build it yourself, just use a binary. 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: compiler problem with C++ API
[EMAIL PROTECTED] writes: Hello, When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling the following example: #include iostream #include winsock.h #include windows.h #include iomanip #include mysql++ int main() { Connection con("stw"); return 0; } I always get the following errors related to the mysql_com.h header file: Configuration: connect - Win32 Debug Compiling... connect.cpp c:\mysql\include\mysql_com.h(117) : error C2208: 'unsigned int' : no members defined using this type c:\mysql\include\mysql_com.h(117) : error C2501: 'fd' : missing storage-class or type specifiers c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(159) : warning C4800: 'unsigned int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(172) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) Error executing cl.exe. connect.obj - 2 error(s), 5 warning(s) Any ideas for a solution? Thanks, John Hi! If you are using VC++ 6.0, please download a distribution for VC++. 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: Problem with mysql++, Aborted (core dumped)
"Aborted" in a C++ program usually means an exception was thrown that you didnt catch. In this case, the connection constructor could have thrown something. try { Connection MySQL(db, host, user, pass); } catch(...) { cout "Connection failed." endl; } Check the excellent online class/function reference for more details about what exceptions can be thrown. I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include iostream.h #include iomanip.h #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host="Localhost"; cchar *db="test"; main () { cout "Conectando...\n"; Connection MySQL(db, host, user, pass); cout "Ok."; return 0; } also i have proven with "Connection MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [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
Re: Problem - Possible Bug?
Andrei Cojocaru writes: Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had the same problem. I have recompiled mysql in full debug and done a stack trace and it keeps on crashing in mysql_select(), here they are: trace #1: www# cd /usr/local/mysql/libexec www# gdb mysqld (gdb) run --user=mysql Starting program: /usr/local/mysql/libexec/mysqld --user=mysql 010415 19:08:47 Warning: setrlimit returned ok, but didn't change limits. Max open files is 1064 010415 19:08:47 Warning: Changed limits: max_connections: 300 table_cache: 377 /usr/local/mysql/libexec/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 799 DBUG_RETURN(error); cut .. Hi! Thank you for your effort, but the above info is not enough. What we need to know is whether that query ALWAYS crashes MySQL server or not. If it crashes it always, we would need copies of the table(s) involved, plus query itself. You can upload table(s) to ftp://support.mysql.com:/pub/mysql/Incoming. Also, please let us know whether you are on 4.2 STABLE or on some developement version. A full mysqlbug report is alsw required. Many thanks in advance. 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: Query failing
List Box writes: MySQL is not giving expected results in queries: The table has a decimal field, 'tolong', with a 13 char size and 8 decimal places. I know from browsing that the table contains many records with 'tolong' values less than -120, as low as -124. The query select * from Tiger_main where tolong -120; results in no records being retrieved. The same query, with reference value -119.8 yeilds no records returned. The same query, with reference value -119.7 returns a large number of records, including several which should have been returned by the prior queries, with tolong values less than -120. The table is fairly large, with over 5 million records and 500 MBytes, and the tolong field is individually indexed. The server is MySQL 3.23.22-beta-log. Can anybody provide any insight into what the problem might be? David Keeney Can anybody shed any light on why MySQL Hi! Please try your query on 3.23.37, built by us, if possible. If a problem repeats, please send us a repeatable test case. 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: Problem with mysql++, Aborted (core dumped)
Hi! MySQL++ can not be used with g++ 2.96 as it is very unstable when it comes to high C++. 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: Problem with mysql++, Aborted (core dumped)
Luis E. Cruz Campos writes: I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include iostream.h #include iomanip.h #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host="Localhost"; cchar *db="test"; main () { cout "Conectando...\n"; Connection MySQL(db, host, user, pass); cout "Ok."; return 0; } also i have proven with "Connection MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [EMAIL PROTECTED] Hi! You will have to use g++ 2.95.2 as 2.96 has a very unstable C++ compiler. And even less stable STL library. 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
starting MySql on redhat 7
Hi - here's my prob and background info. Tried the fix - it didn't work. MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Any thoughts...? I'm not sure if it's the same problem but here goes: I just did a fresh install of RH 7.0 with apache, php, and mysql. I had the same problem. All I had to do was change the permissions on my MySQL directory (in your case "/var/lib/mysql") so that my apache user (the user/group that apache runs as) has access. check to make sure it also changes permissions on the mysql.sock file. That's the important one. I believe apache only needs read (maybe execute) access. chmod 755 /var/lib/mysql (that's from memory, but you know the gist of the problem) Groan..I knew linux was tough but I didn't think I needed a black belt. I've got exactly the same prob after a straight redhat7 install. I tried to take milner's advice and: changed the /var/lib/mysql/mysql.sock to 755 for root who I'm logged in as. Then tried to do the same thing for the Mysql directory. It won't change. Tried a re-boot. Then figured there was something screwy with the directory. Moved mysql.sock to /test rmdir mysql mkdir mysql copied the file back in. The file now had rw permissions only. But in the test dir root had all the permissions to it. Is it being blocked higher up in the tree. My linux book isn't very good on dir permissions. Will chmod change these even if the directory is not empty. And how do u list permissions to a directory? ls -l only seems to work for files. In the error log in the same directory I also get: mysql.host doesn't exist - but this may be a susequent error. I'm a complete newbie so any help would be greatly appreciated. TIA
How to apply a patch?
Hello sorry for my ignorance but how do I apply a patch [diff file] to the mysql source? Thanks for your help. -Andrei Cojocaru _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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't build mysqlgui-1.7.5
Good morning, At 07:07 AM 4/16/01, Sinisa Milivojevic wrote: David Relson writes: At 11:42 AM 4/15/01, Sinisa Milivojevic wrote: Sinisa, I have fl_editor-0.4.1, which I downloaded, configured, and built today. There is no edfile.o. I have run command 'find . -name "edfile.*"' to locate it and found nothing. David Hi! It should be there. It isn't. What does `find . -name '*.o' -print' return ?? It prints nothing. Also, if you are on Linux, you do not have to build it yourself, just use a binary. I consider pre-built binaries to be security risks, especially ones that ask for passwords! Here's a list of the tarballs I downloaded yesterday, plus the output of running "tar ztvf | grep edfile" on each one to look for the missing edfile. As you can see, it isn't there. [relson@osage tgz]$ ls -l total 2472 -rw-r--r--1 relson wheel 149180 Apr 15 09:10 fl_editor-0.4.1.tgz -rw-r--r--1 relson wheel 1147147 Apr 15 09:09 fltk-1.0.10-source.tar.gz -rw-r--r--1 relson wheel 191410 Apr 15 09:10 flvw-2224.tgz -rw-r--r--1 relson wheel 695457 Apr 15 09:10 mysql++-1.7.8.tar.gz -rw-r--r--1 relson wheel 316460 Apr 15 08:40 mysqlgui-1.7.5.tar.gz [relson@osage tgz]$ tar ztvf fltk-1.0.10-source.tar.gz | grep edfile [relson@osage tgz]$ tar ztvf flvw-2224.tgz | grep edfile [relson@osage tgz]$ tar ztvf mysql++-1.7.8.tar.gz | grep edfile [relson@osage tgz]$ tar ztvf mysqlgui-1.7.5.tar.gz | grep edfile 0Looking in fl_editor-0.4.1/visualc/librcl/librcl.dsp, I see a line that says "SOURCE=..\..\librcl\src\editor\edfile.cpp". However visualc is windows, not linux, and the edfile.cpp mentionned is not in the tarball. David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 - 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't build mysqlgui-1.7.5
David Relson writes: Good morning, What does `find . -name '*.o' -print' return ?? It prints nothing. It means that you have not built fl_editor. Build it ! I consider pre-built binaries to be security risks, especially ones that ask for passwords! Why ?? mysqlgui intentionally does not store password anywhere. There is no risk what so ever with our binary. I truly do not know what are you referring to. Do you think that I send an e-mail to myself with your password ?? David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 You have not built fl_editor, therefore you do not have edifle.o. 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: How to apply a patch?
Andrei Cojocaru writes: Hello sorry for my ignorance but how do I apply a patch [diff file] to the mysql source? Thanks for your help. -Andrei Cojocaru Hi! Enter mysql source and run patch filename. If that does not work, try patch -p 0 filename. 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
Concat Question
Hi! This query works: select date_format(date, "%W, %e %M %Y") as date from table This query doesn't: select concat(date_format(date, "%W, %e %M %Y")," ",another) as time_of_day I'm wondering if it is possible to use concat in this way and how if it is possible. Thanks! Jeff - 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: How to apply a patch?
From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: How to apply a patch? Date: Mon, 16 Apr 2001 15:48:48 +0300 (EEST) MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id MHotMailBCA4360F00AB40043751C03AC5A204030; Mon Apr 16 05:52:33 2001 Received: (qmail 16237 invoked by uid 7797); 16 Apr 2001 12:46:44 - Received: (qmail 16180 invoked from network); 16 Apr 2001 12:46:43 - From mysql-return-71601-acojocaru Mon Apr 16 05:53:48 2001 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] References: [EMAIL PROTECTED] X-Mailer: VM 6.72 under 21.1 (patch 12) "GTK" XEmacs Lucid Andrei Cojocaru writes: Hello sorry for my ignorance but how do I apply a patch [diff file] to the mysql source? Thanks for your help. -Andrei Cojocaru Hi! Enter mysql source and run patch filename. If that does not work, try patch -p 0 filename. 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 Thanks had just read the manual section on that as I got your email. -Andrei Cojocaru _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Concat Question
Jeff Holzfaster writes: Hi! This query works: select date_format(date, "%W, %e %M %Y") as date from table This query doesn't: select concat(date_format(date, "%W, %e %M %Y")," ",another) as time_of_day I'm wondering if it is possible to use concat in this way and how if it is possible. Thanks! Jeff Hi! I just tested above on 3.23.36 on a table with DATETIME and VARCHAR column nad it worked just fine. 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: Concat Question
On Mon, Apr 16, 2001 at 07:54:56AM -0500, Jeff Holzfaster wrote: Hi! This query works: select date_format(date, "%W, %e %M %Y") as date from table This query doesn't: select concat(date_format(date, "%W, %e %M %Y")," ",another) as time_of_day I'm wondering if it is possible to use concat in this way and how if it is possible. Is there a newline between the quotes in the second example, or are those just spaces, broken to another line by your mailer? What exactly is 'another' in your second query? This works for me, even with a newline: mysql select concat(date_format(a_mtime, "%W, %e %M %Y"), " " ", a_muser) as time_of_day from articles where a_muser='roam'; +--+ | time_of_day | +--+ | Wednesday, 4 April 2001 roam | | Saturday, 24 March 2001 roam | | Monday, 26 March 2001 roam | +--+ 3 rows in set (0.05 sec) G'luck, Peter -- I've heard that this sentence is a rumor. - 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't build mysqlgui-1.7.5
Sinisa, I appreciate your taking the time to help. I do seem to have run into unexpected problems. Thanks. David At 08:47 AM 4/16/01, you wrote: David Relson writes: Good morning, What does `find . -name '*.o' -print' return ?? It prints nothing. It means that you have not built fl_editor. Build it ! I have build fl_editor. Using "cd fl_editor-0.4.1; ./configure; make". Here's a list of the .a and .o files created: -rw-r--r--1 relson wheel 934554 Apr 16 09:05 libfleditor.a -rw-r--r--1 relson wheel 218848 Apr 16 09:05 src/Fl_Editor.o -rw-r--r--1 relson wheel 148900 Apr 16 09:05 src/Fl_FancyEditor.o -rw-r--r--1 relson wheel 153372 Apr 16 09:05 src/Fl_FancyMultiEditor.o -rw-r--r--1 relson wheel 129756 Apr 16 09:05 src/Fl_MultiEditor.o -rw-r--r--1 relson wheel 40052 Apr 16 09:05 src/Fl_ProgressBox.o -rw-r--r--1 relson wheel 50676 Apr 16 09:05 src/Fl_StatusPanel.o -rw-r--r--1 relson wheel 119812 Apr 16 09:05 src/editengine.o -rw-r--r--1 relson wheel 27896 Apr 16 09:05 src/lists.o -rw-r--r--1 relson wheel 36324 Apr 16 09:05 src/wstring.o -rw-r--r--1 relson wheel 126244 Apr 16 09:05 test/multfunc.o -rw-r--r--1 relson wheel 127832 Apr 16 09:05 test/multiple.o -rw-r--r--1 relson wheel 21680 Apr 16 09:05 test/progress.o -rw-r--r--1 relson wheel 111612 Apr 16 09:05 test/simple.o -rw-r--r--1 relson wheel 116388 Apr 16 09:05 test/single.o -rw-r--r--1 relson wheel 23328 Apr 16 09:05 test/status.o Unfortunately, there is no "edfile.o". Could the name have been changed to FL_Editor.o ? I consider pre-built binaries to be security risks, especially ones that ask for passwords! Why ?? mysqlgui intentionally does not store password anywhere. There is no risk what so ever with our binary. I truly do not know what are you referring to. Do you think that I send an e-mail to myself with your password ?? No, I do not think you would do that. However, if I cannot read the source and build the binary myself, I choose not to run the program. There is a second problem during the build. The compiler is complaining about incompatible function prototypes (as shown below). Have you ideas as to why? g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7/sqlplusint -I/usr/local/include/mysql -c about.cc In file included from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/iostream.h:31, from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/iterator:36, from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/std/bastring.h:44, from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/string:6, from about.cc:13: /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/streambuf.h: In method `struct streampos streambuf::pubseekoff(long long int, ios::seek_dir, int = 3)': /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/streambuf.h:362: conversion from `__off64_t' to non-scalar type `streampos' requested /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/streambuf.h: In method `struct streampos streambuf::pubseekpos(_G_fpos64_t, int = 3)': /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/../../../../include/g++-3/streambuf.h:364: `struct streampos' used where a `long long int' was expected make: *** [about.o] Error 1 David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 - 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 MySQL support sub queries ?
Try looking at the bottom of any message. By the way, the output of your query is an empty set. Yen wrote: Thank you Jeremy, these really help!! I can't find the manual :D -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 4:00 PM To: Yen Cc: [EMAIL PROTECTED] Subject: Re: Does MySQL support sub queries ? On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: Does anyone know whether this MySQL support sub queries? Anyone who has checked the MySQL Manual does. (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) Jeremy - 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: Newbie Question!?!
"Thomas O'Neill" [EMAIL PROTECTED] wrote: 1. How would I select the row that has the highest value in one of the fields? Use the ORDER BY clause. ORDER BY field_name DESC 2. How to I update a record? Use an UPDATE query. Query structure and MySQL commands are covered in the online manual. If you're new to databases I suggest learning basic SQL and spending some time reading the MySQL manual. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
Please assist me?
Sir, Sorry to bother you. I have downloaded MySQL version 3.23.22-beta. I am looking for a pretty basic tutorial to get started. Are there any suitable training materials on your website? In particular, how can I best use the GUIs in WinMySQLAdmin? Your kind response would be appreciated. Sincerely, Thomas Morton
Re: Load Data Errcode 13
The server needs read and execute permissions all the way to the data file, and read permissions on the file. I you are on the server, try LOAD DATA LOCAL instead. Kalvin Kag Khetsavanh wrote: I keep getting the following error everytime i tried to use Load Data mysql load data infile '/home/laovision/lvdb/region.dat' - into table tlu_region fields terminated by '\t'; ERROR 13: Can't get stat of '/home/laovision/lvdb/region.dat' (Errcode: 13) I get same error using mysqlimport Any help would great. Thanks, Kalvin - 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: Please assist me?
I suggest you get 3.23.36 it's the latest. From: "Thomas Morton" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Please assist me? Date: Mon, 16 Apr 2001 14:35:50 +0100 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id MHotMailBCA4429B00C94004370AC03AC5A205400; Mon Apr 16 06:46:04 2001 Received: (qmail 23304 invoked by uid 7797); 16 Apr 2001 13:35:49 - Received: (qmail 23289 invoked from network); 16 Apr 2001 13:35:48 - From mysql-return-71609-acojocaru Mon Apr 16 06:47:10 2001 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Message-ID: 001101c0c67a$8f337d80$5f669ac2@k3v6j5 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sir, Sorry to bother you. I have downloaded MySQL version 3.23.22-beta. I am looking for a pretty basic tutorial to get started. Are there any suitable training materials on your website? In particular, how can I best use the GUIs in WinMySQLAdmin? Your kind response would be appreciated. Sincerely, Thomas Morton _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Mysql and Perl DBI
Use only GCC-2.95.2 Gordon Stewart wrote: I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-14.tar.gz. User name for connecting to database test? [undef] Password for connecting to database test? [undef] Creating files for MySQL Checking if your kit is complete... Looks good Using DBI 1.14 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [gordon@fido Msql-Mysql-modules-1.2213]$ make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/Msql-Mysql-modules mkdir blib/lib/auto mkdir blib/lib/auto/Msql-Mysql-modules mkdir blib/man1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \ -I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \ -e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm" /usr/bin/pod2text mysql/lib/DBD/mysql.pm README make[1]: Entering directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir ../blib/lib/DBD mkdir ../blib/arch/auto/DBD mkdir ../blib/arch/auto/DBD/mysql mkdir ../blib/lib/auto/DBD mkdir ../blib/lib/auto/DBD/mysql mkdir ../blib/man3 cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm cp lib/Mysql.pm ../blib/lib/Mysql.pm gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL dbdimp.c /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI/Driver.xst mysql.xsi /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 /usr/lib/perl5/5.6.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.0/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.96" gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -L/usr/lib/gc c-lib/i386-redhat-linux/2.96 -lgcc chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Manifying ../blib/man3/DBD::mysql.3pm Manifying ../blib/man3/Bundle::DBD::mysql.3pm Manifying ../blib/man3/Mysql.3pm make[1]: Leaving directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir blib/script cp dbimon blib/script/dbimon /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -MExt Utils::MakeMaker -e "MY-fixin(shift)" blib/script/dbimon Manifying blib/man1/dbimon.1 *** ERROR: unterminated C... at line 1426 in file dbimon *** ERROR: unterminated C... at line 1450 in file dbimon Can any one help Gordon - 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: problems with configure
You need to load the "ncurses" headers and libraries. I am not familiar with Debian, but they are on your CD. Andr Estel wrote: Hello, i mail you from germany, so please excuse my "special" english! I just want to compile mysql 3.23.36 under Debian Potato for use with PHP(classic LAMP). But get the following error: configure:8016: checking for tgetent in -lncurses configure:8035: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -lncurses -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -lncurses collect2: ld returned 1 exit status configure: failed program was: #line 8024 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8054: checking for tgetent in -lcurses configure:8073: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -lcurses -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -lcurses collect2: ld returned 1 exit status configure: failed program was: #line 8062 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8092: checking for tgetent in -ltermcap configure:8111: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -ltermcap -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -ltermcap collect2: ld returned 1 exit status configure: failed program was: #line 8100 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8139: checking for termcap functions library But ncurses is installed, but i dont know where to get termcap! Please help and thanks a lot Andr Estel -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - 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: Auto_Increment
1. No, unless you use ISAM tabbes ( See the Manual ) 2. Index Sequential Access Method. Jamie S Buchanan wrote: Hello, I wonder if you can help me. For a university project I've got a database with several tables using columns set up with 'auto_increment'. I've discovered that the value that the system creates for a new record is one greater than the largest one which has existed even if the records with the largest values have been deleted. I've read the docs and read the part which says that this is the way myISAM tables handles auto_increment and that ISAM tables create a value which is one greater than the largest value currently existing. From this I've presumed that I'm using myISAM tables but is there any way I can make the auto_increment feature work the way it does with the ISAM tables? And what exactly are myISAM and ISAM tables? (a quick web search gave me: -the Information centre for South African Music -the Institute for the Study of American Music -International Swimwear and Active Market) Thanks for any help you can give me, Jamie. - 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: Problem - Possible Bug?
On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote: Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had the same problem. I have recompiled mysql in full debug and done a stack trace and it keeps on crashing in mysql_select(), here they are: trace #1: www# cd /usr/local/mysql/libexec www# gdb mysqld (gdb) run --user=mysql Starting program: /usr/local/mysql/libexec/mysqld --user=mysql 010415 19:08:47 Warning: setrlimit returned ok, but didn't change limits. Max open files is 1064 010415 19:08:47 Warning: Changed limits: max_connections: 300 table_cache: 377 /usr/local/mysql/libexec/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 799 DBUG_RETURN(error); ... (gdb) back #0 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 #2 0x809219f in mysql_parse (thd=0x824a818, inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and pfs.planetid=3647", length=137) at sql_parse.cc:2298 #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 #4 0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551 #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 #6 0xbfadcffc in ?? () #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 #11 0x804b29d in _start () ... (gdb) info locals tmp_table = (TABLE *) 0x92cc018 error = 0 tmp = 0 need_tmp = true hidden_group_fields = false simple_order = false simple_group = false no_order = false cond_value = COND_OK select = (SQL_SELECT *) 0x92dab20 keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, size_of_element = 20} join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, table = 0x0, all_tables = 0x92da7e0, sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, sort_and_group = false, first_record = false, full_join = true, group = false, no_field_update = 76, const_table_map = 0, outer_join = 0, send_records = 1, found_records = 2, positions = {{records_read = 14, table = 0x92da648, key = 0x0}, {records_read = 14, table = 0x92da648, key = 0x0}, { records_read = 3.497926695968519e-115, table = 0x92e0180, key = 0x92d9274}, {records_read = 8.8208146916688224e-314, table = 0xbfaba66c, key = 0x92d9274}, {records_read = 6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, { records_read = 1.9019183611868367e-269, table = 0x92d9000, key = 0xbfaba6ac}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x92d9274}, {records_read = 1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, { records_read = 1.9019183611868367e-269, table = 0x1, key = 0xbfaba7e0}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x0}, {records_read = 1.8993304345295969e-269, table = 0xbfaba6dc, key = 0xbfaba71c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 3.4979266959743929e-115, table = 0xbfaba6fc, key = 0x92d9274}, {records_read = 1.8993304345295969e-269, table = 0x822c4d8, key = 0xbfaba74c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 1.8992611150717832e-269, table = 0xbfaba72c, key = 0xbfaba74c}, {records_read = 1.8993304345295969e-269, table = 0x92e0198, key = 0x92d9274}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x0}, {records_read = 3.4978027730273331e-115, table = 0xbfaba75c, key = 0x0}, {records_read = 3.497926695968519e-115, table = 0xbfaab000, key = 0x3c}, { records_read = 1.8611437758736926e-264, table = 0xbfaba77c, key = 0x43f}, {records_read = 1.8520806496858815e-264, table = 0x12e0198, key = 0xbfaba7cc}, {records_read = 1.8520805311109313e-264, table = 0xbfaba7f8, key = 0x1}, { records_read = 3.4979266959805738e-115, table = 0x820d6ac, key = 0xbfaba7dc}, {records_read = 1.901849041729023e-269, table = 0x282b11c0, key = 0xbfaba7dc},
Re: Problem - Possible Bug?
as I said before I can give you root access on the machine which I believe would be easier for you to disagnose the problem. From: Sasha Pachev [EMAIL PROTECTED] To: "Andrei Cojocaru" [EMAIL PROTECTED] Subject: Re: Problem - Possible Bug? Date: Mon, 16 Apr 2001 08:31:54 -0600 MIME-Version: 1.0 Received: from [209.181.82.108] by hotmail.com (3.2) with ESMTP id MHotMailBCA44D7700C640043714D1B5526C11E30; Mon Apr 16 07:32:24 2001 Received: from mysql ([127.0.0.1])by mysql.sashanet.com (8.10.2/8.10.2/SuSE Linux 8.10.0-0.3) with SMTP id f3GEVtE17248for [EMAIL PROTECTED]; Mon, 16 Apr 2001 08:31:55 -0600 From [EMAIL PROTECTED] Mon Apr 16 07:33:58 2001 X-Authentication-Warning: mysql.sashanet.com: Host [127.0.0.1] claimed to be mysql Organization: MySQL X-Mailer: KMail [version 1.2] References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Message-Id: 01041608315404.17185@mysql I think I forgot to give you the address where to drop off your tables. ftp://support.mysql.com/pub/mysql/secret/ -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Problem - Possible Bug?
Also, it's not a specific query that crashes it, only select queries apparently. I can do better than that I can give you root access to my machine. You can corrupt the data as much as you want I have backups on my other machine. Contact me at my email for the login details. From: Sasha Pachev [EMAIL PROTECTED] To: "Andrei Cojocaru" [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Problem - Possible Bug? Date: Mon, 16 Apr 2001 08:25:26 -0600 MIME-Version: 1.0 Received: from [209.181.82.108] by hotmail.com (3.2) with ESMTP id MHotMailBCA44C0900BA4004314BD1B5526C11DD0; Mon Apr 16 07:26:18 2001 Received: from mysql ([127.0.0.1])by mysql.sashanet.com (8.10.2/8.10.2/SuSE Linux 8.10.0-0.3) with SMTP id f3GEPTE17218;Mon, 16 Apr 2001 08:25:29 -0600 From [EMAIL PROTECTED] Mon Apr 16 07:27:11 2001 X-Authentication-Warning: mysql.sashanet.com: Host [127.0.0.1] claimed to be mysql Organization: MySQL X-Mailer: KMail [version 1.2] References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Message-Id: 01041608252602.17185@mysql X-MIME-Autoconverted: from 8bit to quoted-printable by mysql.sashanet.com id f3GEPTE17218 On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote: Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had the same problem. I have recompiled mysql in full debug and done a stack trace and it keeps on crashing in mysql_select(), here they are: trace #1: www# cd /usr/local/mysql/libexec www# gdb mysqld (gdb) run --user=mysql Starting program: /usr/local/mysql/libexec/mysqld --user=mysql 010415 19:08:47 Warning: setrlimit returned ok, but didn't change limits. Max open files is 1064 010415 19:08:47 Warning: Changed limits: max_connections: 300 table_cache: 377 /usr/local/mysql/libexec/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 799 DBUG_RETURN(error); ... (gdb) back #0 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 #2 0x809219f in mysql_parse (thd=0x824a818, inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and pfs.planetid=3647", length=137) at sql_parse.cc:2298 #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 #4 0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551 #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 #6 0xbfadcffc in ?? () #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 #11 0x804b29d in _start () ... (gdb) info locals tmp_table = (TABLE *) 0x92cc018 error = 0 tmp = 0 need_tmp = true hidden_group_fields = false simple_order = false simple_group = false no_order = false cond_value = COND_OK select = (SQL_SELECT *) 0x92dab20 keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, size_of_element = 20} join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, table = 0x0, all_tables = 0x92da7e0, sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, sort_and_group = false, first_record = false, full_join = true, group = false, no_field_update = 76, const_table_map = 0, outer_join = 0, send_records = 1, found_records = 2, positions = {{records_read = 14, table = 0x92da648, key = 0x0}, {records_read = 14, table = 0x92da648, key = 0x0}, { records_read = 3.497926695968519e-115, table = 0x92e0180, key = 0x92d9274}, {records_read = 8.8208146916688224e-314, table = 0xbfaba66c, key = 0x92d9274}, {records_read = 6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, { records_read = 1.9019183611868367e-269, table = 0x92d9000, key = 0xbfaba6ac}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x92d9274}, {records_read = 1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, { records_read = 1.9019183611868367e-269, table = 0x1, key = 0xbfaba7e0}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x0}, {records_read = 1.8993304345295969e-269, table =
Indexes on Nulls
Is it true no indexing on Nulls In the Innobase database tables and MyIASM tables? - 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: Indexes on Nulls
"DG" == Dennis Gearon [EMAIL PROTECTED] writes: DG Is it true no indexing on Nulls In the Innobase database tables and DG MyIASM DG tables? Dunnow about Innobase tables, but MyISAM tables let you have indexes on nullable columns. ISAM did not. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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
install
Hi everybody!! I'm using mysql on linux Redhat7... When i exec safe_mysqld the server begin and... shut down, so i can't use it... i used an RPM version. If somebody could help me it could be great: one more try and i kill myself!! (excuse me for english: i'm french...) Anyway, thank you for your help!! phelles - 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: MYSQL Problem
If you are truly getting 10k queries per second, that would imply to me a roughly comparable number of webserver connections (maybe within a factor of 2). If this is the case, I'd be amazed that it would work at all when hosted on a single box with "only" 256M of ram. I believe your problem is with the overall architecture of your system, not mysql specifically. I think that the first thing I would do is either add ram or move mysql to a dedicated server to try and distribute the load. Then I would consult some apache (I'm assuming thats what your running) performance and tuning guides. Also, I would examine the ratio of insert/updates to selects along with your use of indexing. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 12:08 PM To: [EMAIL PROTECTED] Subject: MYSQL Problem Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. Under this circumstances MYSQL failed to respond or get hanged. We have to restart MYSQL then. We are on a dedicated server with 256 MB of RAM and 10 GB disk space. We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address [EMAIL PROTECTED] Best Wishes, The Development Team http://www.gcards.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: MYSQL Problem
Okay just checking a few basic things, have you indexed your table properly? There is a manual section about performance, also make sure to play around with the mysql configuration file (global one in /etc/my.cnf) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL Problem Date: Mon, 16 Apr 2001 21:37:47 +0530 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id MHotMailBCA465A9002A40043165C03AC5A20D8C0; Mon Apr 16 09:15:38 2001 Received: (qmail 1297 invoked by uid 7797); 16 Apr 2001 16:05:38 - Received: (qmail 1280 invoked from network); 16 Apr 2001 16:05:31 - From mysql-return-71620-acojocaru Mon Apr 16 09:17:04 2001 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] Priority: normal X-mailer: Pegasus Mail for Win32 (v3.11) Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. Under this circumstances MYSQL failed to respond or get hanged. We have to restart MYSQL then. We are on a dedicated server with 256 MB of RAM and 10 GB disk space. We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address [EMAIL PROTECTED] Best Wishes, The Development Team http://www.gcards.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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: install
[EMAIL PROTECTED] I am very new to mysql, so perhaps this is incorrect, but, I think there is something in the manual that I saw on this that suggests that you should check for file permissions. Look in hostname.err and hostname.log (?) files created in some directory near your install location (/usr/local/var or /user/local/mysql or some such). luck, tyler On Monday, April 16, 2001, at 09:23 AM, phelles wrote: Hi everybody!! I'm using mysql on linux Redhat7... When i exec safe_mysqld the server begin and... shut down, so i can't use it... i used an RPM version. If somebody could help me it could be great: one more try and i kill myself!! please don't do that. It's just technology! Take a walk in a park instead. :-) (excuse me for english: i'm french...) no problem. your english is not very bad at all. Anyway, thank you for your help!! phelles - 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 mysql-unsubscribe- [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 convert a MS Sql database to MySQL?
See also: http://www.kofler.cc/mysql/mssql2mysql.html mssql2mysql converts Microsoft SQL Server databases to MySQL (schema + data, but no SPs, no triggers, no views etc.) mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) Best wishes, Michael Kofler http://www.kofler.cc - 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: Re: Can't build mysqlgui-1.7.5
I have just compiled fl_editor-0.4.1. Here is the list of .o files that get created: ./src/Fl_Editor.o ./src/Fl_FancyEditor.o ./src/Fl_FancyMultiEditor.o ./src/Fl_MultiEditor.o ./src/Fl_ProgressBox.o ./src/Fl_StatusPanel.o ./src/editengine.o ./src/lists.o ./src/wstring.o ./test/progress.o ./test/simple.o ./test/single.o ./test/status.o ./test/multiple.o ./test/multfunc.o There is still no "edfile.o". Obligatory words to bypas filter: database sql query Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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
pthread_rwlock_init symbol error encountered runningmysql_install_db
While trying to install the binary distribution of mysql-3.23.36 on a Sun Sparc30 running Solaris 2.6 I get a fatal pthread_rwlock_init symbol error. Am I perhaps missing some critical library in /usr/lib that mysql needs to perform its installation? Details follow; thanks in advance for any help, Christian Dupont University of Notre Dame Submitter-Id:submitter ID Originator:Super-User Organization: University Libraries, University of Notre Dame MySQL support: none Synopsis:pthread_rwlock_init symbol error encountered running mysql_install_db Severity:critical Priority:medium Category:mysql Class:support Release:mysql-3.23.36 (Official MySQL binary) Environment: System: SunOS devers 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-30 Architecture: sun4 Some paths: /usr/local/bin/perl Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Feb 2 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Oct 24 21:16 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Feb 2 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Oct 24 21:16 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared Perl: This is perl, version 4.0 = THIS IS THE OUTPUT I GET WHEN I RUN mysql_install_db: # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: relocation error: file ./bin/mysqld: symbol pthread_rwlock_init: referenced symbol not found Installation of grant tables failed! ...[additional lines omitted]... - THERE ARE NO FURTHER ERROR REPORTS IN ./data IF I SIMPLY RE-RUN THE SCRIPT, THE ERROR IS NOT REPEATED, BUT NEITHER AM I ABLE TO SUCCESSFULLY START THE MySQL DAEMON (SEE OUTPUT BELOW): - # scripts/mysql_install_db Installing all prepared tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h devers -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com # - HERE'S WHAT HAPPENS WHEN I TRY TO START THE DAEMON (NOTE THE PROCESS HANGS, AND I HAVE TO INTERRUPT IT) - # cd . ; ./bin/safe_mysqld 9453 # Starting mysqld daemon with databases from /usr/mysql-3.23.36-sun-solaris2.7-s parc/data 010416 12:04:19 mysqld ended [Interrupt Process] # - AND HERE'S WHAT I GET WHEN I RUN run-all-tests: - # /usr/local/bin/perl5 run-all-tests install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC at (eval 40) lin e 2. DBI::install_driver called at /usr/local/lib/perl5/site_perl/DBI.pm line 325 DBI::connect called at /usr/mysql-3.23.36-sun-solaris2.7-sparc/sql-bench /server-cfg line 241 db_MySQL::connect called at /usr/mysql-3.23.36-sun-solaris2.7-sparc/sql- bench/server-cfg line 220 db_MySQL::version called at run-all-tests line 84 # - IN CASE I AM MISSING SOME LIBRARIES, FOLLOWING IS A COMPLETE LISTING OF THE CONTENTS OF MY /usr/lib DIRECTORY: total 16542 -rwxr-xr-x 1 bin bin 4392 Oct 4 2000 [EMAIL PROTECTED] lrwxrwxrwx 1 root root 14 Feb 2 2000 accept - ../sbin/accept drwxr-xr-x 2 root sys 5632 Feb 8 10:22 adb -r-xr-xr-x 1 bin bin 2345 Jul 15 1997 agefile drwxr-xr-x 2 root sys 512 Feb 8 10:22 autofs lrwxrwxrwx 1 root other 22 Feb 9 09:31 btcats - /opt/coldfusion/btcats -r-xr-xr-x 1 bin bin 6644 Jul 15 1997 calprog drwxrwxr-x 5 root bin 512 Feb 2 2000 class lrwxrwxrwx 1 root other 19 Feb 9 09:28 coldfusion - /opt/coldfusion/lib lrwxrwxrwx 1 root root 16 Feb 2 2000 cron -
Port mySQL to VxWorks?
Hi, I have a question if mySQL can be ported to an embedded environment like VxWorks? Thanks, Andrew - 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: install
On Monday 16 April 2001 10:23, phelles wrote: Hi everybody!! I'm using mysql on linux Redhat7... When i exec safe_mysqld the server begin and... shut down, so i can't use it... i used an RPM version. If somebody could help me it could be great: one more try and i kill myself!! (excuse me for english: i'm french...) Anyway, thank you for your help!! phelles tail /var/lib/mysql/*.err this will tell you why side note - if you are using RH 7, make sure to use our RPM, not RH. In fact, whatever you are using, our recommendation for most systems is to use our latest available binary, if such is available. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: MYSQL Problem
Hi there, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. If you actually were able to handle that kind of load before, on the same hardware, what DB were you using? And why did you actually change? We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address You might want to have a look into the manual about the threading and/or file handle issues there are (this is assuming you're running things on Linux.) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office/fax: +44 20 72408283 Mobile: +44 7740291600 - 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
Binary install question of 3.23.36 on AIX.
Hi, I am installing the binary version of mysql 3.23.36 on AIX 4.3. When I run mysql_install_db, i get the following error /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive This error is occuring with the latest version of the zlib library. Can someone shed some light on this please!! Thank you, Alain - 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
TYPE=BDB is ignored!
Hello I compiled on an UltraSparc II Linux with libc-2.2.2 and say CREATE TABLE t (t int) TYPE=BDB; but it creates a MyISAM without any warning. Why? BDB seems to be compiled in correctly: ch@vore:~/test$ nm usr/bin/mysqld |grep berke 000822c0 t _GLOBAL_.D.have_berkeley_db 000822a4 t _GLOBAL_.I.have_berkeley_db 0019dd38 D have_berkeley_db Any hints how to debug this? bye, -christian- - 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
3.22.27 isamchk on RedHat 7.0
I just compiled MySQL 3.22.27 (yes, I know it's an old package) under RedHat 7.0. It compiles and installs fine and mysqld seems to run ok, but isamchk refuses to check tables: isamchk: error: 22 when opening ISAM-table 'note.ISM' The file exists and is readable by root: -rw-rw1 root root 1024 Apr 16 10:22 note.ISM I've dropped and recreated the table several times, with no change. All the tables in the database have this problem. From errno.h, error 22 is EINVAL ("Invalid Argument"). I took a peak at the source code. The error is being returned by ni_open(). Before I press deeper into the code, has anyone seen this problem before and/or know how to fix it? Much Thanks, -Brian Ellis Senior Project Engineer The iSpark Group, Inc. - 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
ENUM and C API
I might have missed it but is there a way to get the strings related to a enum from the database? (i.e. I have index 4 but I want the string that it goes with) thanks -Ian Johnson - 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
DataBaseIntegration.net domain...
NOTICE: THIS IS A ONE (1)-TIME MESSAGE AND IT WILL NOT REPEAT. THEREFORE THERE IS NO NEED FOR DELETION OR REMOVAL. *Your email address has already been discarded from our files. - Dear Colleagues, We took the time to choose your address as someone with a possible interest in the Database and Integration Industry IF NOT, we truly apologize and please disregard this message. ** Perhaps you have considered adding value to your existing site or creating a web-based business, directory or a national web portal. If you're interested then you need good domain name. The domain name should be easy to remember and also easy to pop up with the worlds search engines. We have to decided to sell our domain name DATABASEINTEGRATION.NET We will let it go for $5,500.00 USD -- It's the 2nd best name in the database integration industry. -Resale value is guaranteed. As Internet populations increase the names will increase in value also. We estimate that these domains will exceed an estimated value of $30 thousand dollars or more in less than 2 years. -The name is generic and free of any trademark violations or encumbrances and has never been used. -The name DOES NOT violate any cyber statutes or laws. If interested feel free to email me and we will contact you asap! Thanks! Joseph Cartagena--Domain Proprietor EMail: [EMAIL PROTECTED] THIS IS A ONE ONLY MAILING AND WILL REPEAT - 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: starting MySql on redhat 7
bobit wrote: Hi - here's my prob and background info. Tried the fix - it didn't work. MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Any thoughts...? Is MySQL actually running on your system? Even if you installed it, it's not started automatically on RedHat by default. snip My linux book isn't very good on dir permissions. Will chmod change these even if the directory is not empty. You don't use chmod to change permission for directories. Instead you can use chown to change the owner of directories. And how do u list permissions to a directory? ls -l only seems to work for files. ls -l does work for directories. In the error log in the same directory I also get: mysql.host doesn't exist - but this may be a susequent error. I'm a complete newbie so any help would be greatly appreciated. TIA - 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
make failes because conf_to_src seg faults
Description: When I was installing mysql from sources, I got a strange error. I looked at what was going on, and this is what I got. first of all, here's the error in from my "make" /bin/sh ../libtool --mode=link gcc -O6 -DDBUG_OFF -rdynamic -o conf_to_src conf_to_src.o -ldl -lcrypt -lnsl -lm -lpthread mkdir .libs gcc -O6 -DDBUG_OFF -rdynamic -o conf_to_src conf_to_src.o -ldl -lcrypt -lnsl -lm -lpthread /usr/bin/ld: warning: libc.so.5, needed by /lib/libdl.so, may conflict with libc.so.6 /lib/libc.so.5: the `getwd' function is dangerous and should not be used. /lib/libc.so.5: warning: `siggetmask' is obsolete; `sigprocmask' is best /lib/libc.so.5: warning: getresgid is not implemented and will always fail ./conf_to_src .. latin1 \ ./ctype_extra_sources.c make[2]: *** [ctype_extra_sources.c] Error 139 make[2]: Leaving directory `/home/darkness/devel/mysql/mysql-3.23.36/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/darkness/devel/mysql/mysql-3.23.36' make: *** [all-recursive-am] Error 2 I found that the conf_to_src program was seg faulting and not finishing that last bit of that file. (say, three lines and the }; that it needs) How-To-Repeat: I just did ./configure; make and the above error happened. Fix: I relinked the conf_to_src program (which I don't think did anything) and ran it again, outputting the data to console. I it still segfaulted, but all the data was on the screen, so I copied it into ctype_extra_src.c (is that right?) and then did "make" again. It seems to be compling fine. The first time I just added the "};" and didn't think about the missing data, it complied but mysqld segfaulted right away. Then I went and upgraded (I was using .32 the first time.. now I'm using .36). I hope this helps. I'm not sure. :-) Please feel free to contact me about any questions with this bug. please user "[EMAIL PROTECTED]". thanks! p.s. this computer is a heap I had to take over when I got the job. I'm not sure if there are lib conflicts, but... I'll take a closer look. Submitter-Id: submitter ID Originator:Seer Snively Organization: -- Seer Snively -- Lead Slacker -- Nethelp International MySQL support: none | licence | email support | extended email support ] Synopsis: make fails because conf_to_src seg faults Severity: Priority: Category: mysql Class: Release: mysql-3.23.32 (Source distribution) Environment: System: Linux cpi 2.2.6 #6 SMP Wed Jun 16 10:31:30 PDT 1999 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/local/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95/specs gcc version 2.95 19990728 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 12 1999 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x 1 root root 634880 Jun 4 1996 /lib/libc.so.4.7.6 lrwxrwxrwx 1 root root 14 Jun 12 1999 /lib/libc.so.5 - libc.so.5.4.46 -rwxr-xr-x 1 root root 614840 Oct 5 1998 /lib/libc.so.5.4.46 lrwxrwxrwx 1 root root 13 Jun 16 1999 /lib/libc.so.6 - libc-2.0.7.so -rwxr-xr-x 1 root root 2365709 Jun 16 1999 /lib/libc-2.0.6.so -rwxr-xr-x 1 root root 652412 Oct 24 1998 /lib/libc-2.0.7.so -rw-r--r-- 1 root root 10464086 Jun 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 344 Jun 16 1999 /usr/lib/libc.so Configure command: ./configure 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
UTF-8
prelude: - utf-8 is a 'string function friendly' version of UTF-32, a character mapping for all known human languages (with room for more). UTF is 4 bytes (4 * 8 = 32). Any of those 4 bytes can be 0, i.e. ''/NULL. A regular library string function will end the string at the first BYTE it finds as ''/NULL/0. UTF actually represents that character as 00 00 00 00. UTF uses variable length characters (1-4,5,6 maximum) but still maintains that ANY byte = 0, is the NULL character for string functions. This means that all sorts of characters above Decimal-128 will be in the stream. My question about using a mysql database is whether it is possible to store UTF-8 strings in the string/text style columns, keeping in mind that a 10 DISPLAYED character string may actually take 40 to 60 bytes. I haven't figured out how to get the data in, yet, but getting it out should be the same, it'll just display weird, depending on your program/terminal mapping for the font in use. - 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
Fwd: Metadata Retrieval
I am interested in retrieving Field and Type information from a named table. Currently, MySQL allows me to see a table's description via mysql describe TheTable; returning its structure in the form of a table, including the Fields and Types columns. I would like to retrieve the contents of these two columns. What is the SQL call that will do this? Sam Daniel Motorola 480-441-7431 - 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
Changes to compile successfully on Mac OS X release
I'd like to get a minor source change into the next revision of MySQL to make the standard source distribution compile on Mac OS X. I read somewhere to use some diffing tool when providing the bug report, but can't find those instructions. What's the proper way to get the revision into the tree? TIA, Roderick Mann rmann @ latencyzero.com.sansspam - 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: Metadata Retrieval
You can do this by just issuing that statement as a regular SQL query. I was able to connect via an ADO connection: set myRecordset = conn.execute("describe thedatabase.thetable") and I'm sure you could do this with php via mysql_query("describe thetable") In both cases you end up with a recordset that you can loop through. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Sam Daniel" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 16, 2001 8:47 PM Subject: Fwd: Metadata Retrieval I am interested in retrieving Field and Type information from a named table. Currently, MySQL allows me to see a table's description via mysql describe TheTable; returning its structure in the form of a table, including the Fields and Types columns. I would like to retrieve the contents of these two columns. What is the SQL call that will do this? Sam Daniel Motorola 480-441-7431 - 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
Calculating multiple instances in MySQL table..
Hi, I have a table with multiple instances of username (Basically a table of dial-in user's input/output octets). What I want to do (In Perl), was to select each username (And associated in/out octets), add them together, and finally print out a total for each user. eg. UsernameInOctetsOutOctets testuser134838230 1287123474 testuser2 123448 2882779871 I can currently do a query (search) on a particular username, but not search through the whole table and give me a grand total on all users. Any ideas/suggestions are greatly appreciated, Regards, MB - 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
question
Hello, I used to use a version of your client. The program I have is "mysqlgui-win-1.4a". I am using Windows 98. Could you tell me what the latest version of your software is and what the exact name is? There are so many programs and variations that I seem to be getting confused. I don't administer the databases, I just modify them for a game in a position called a deputy...such as changing room numbers, player descriptions/titles, etc. Any help you could give me would be greatly appreciated. Thank you. Deneen J. Petty
Re: TYPE=BDB is ignored!
Hi! On Apr 16, Christian Hammers wrote: Hello I compiled on an UltraSparc II Linux with libc-2.2.2 and say CREATE TABLE t (t int) TYPE=BDB; but it creates a MyISAM without any warning. Why? BDB seems to be compiled in correctly: ch@vore:~/test$ nm usr/bin/mysqld |grep berke 000822c0 t _GLOBAL_.D.have_berkeley_db 000822a4 t _GLOBAL_.I.have_berkeley_db 0019dd38 D have_berkeley_db Any hints how to debug this? bye, The above symbol does not means that BDB is compiled in. Try show variables like "have_bdb" 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
Formating fields.
Hi, How will we format numeric fields in MySql using PERL ? I want to display certain numeric formatted in the browser. I want to set the decimal points, currency etc. Thankyou Rajeev Ramanujan
Need bid for small job.
Hello Mysql, I am in need of a small database program that I need someone to build for me. The project is simple, goto http://www.parentprofiles.com, http://www.adoption.com, and http://www.birthmother.com. These 3 sites are all pulling a random family that is looking to adopt a child. We would like a table that has 1 line per family that looks like this: Primary_id | Accessed - 123 |3 Where the primary id will tie into another table (or be incorperated into the current one) and the field Accessed is automatically updated each time that family is shown on any of those servers. Adoption.com and ParentProfiles.com are both PHP servers and Birthmother.com is ASP. This is one project and we may use the person who does this for other projects in the future. We don't need full time help but some backup mysql experts are always handy to have around. Email me with a quote sheet and time frame to completion. Payment upon completion. Alan Halls Adoption.com Webmaster [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
Is MySQL training available in Japan/Tokyo?
To all MySQL users in Asia - most particularly in Japan, I would like to know if any MySQL training exists in Tokyo/Japan. Reply to: [EMAIL PROTECTED] Regards, Marc _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Selecting rows for editing
Hi, Now I'm completely stuck. I am codeing a (basic at this point) stock inventory in PHP/MySQL. I have all items in a table displayed in a table in PHP. Like this: if ($isstock 0) { //get value from a check on mysql_num_rows if ($action != "Edit") { for ($i = 0; $i = $isstock -1; $i++) { $row = mysql_fetch_array($query_res); print "tr"; print " td".$row['s_id']."/td"; print " td".$row['s_description']."/td"; print " td".$row['s_price']."/td"; print " td".$row['s_stock_quantity']."/td"; print " tdN/I/td"; print " tdN/I/td"; print " tdinput name='action' value='Edit' type='submit'input name='action' value='Delete' type='submit'/td"; print "/tr"; } } Now I want to edit the specific ".$row['s_id']." How do I pass this to MySQL in a usefull manner? Is there a specific row number in a MySQL table I can access and pass to a variable? (Thought is too do something along the lines of (totally ficticous): $rownum = mysql_get_rownum($result); $rownum = "txtItem" . $rownum; and then input type='hidden' name='Item' value='$rownum' Any ideas? Martin S. - 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
Server Connection Timeout
I have written an application that establishes a connection to a remote MySQL database, and accepts queries from clients. If the server does not receive a query in eight hours (as set by wait_timeout), then the connection to MySQL disappears and all my queries fail. How can I keep the connection alive? ... (Obviously sending a connect; won't work because the server is gone when I'll need it.. Should I just send a connect; every so often to make sure the server status alive?) Thanks for the advice.. -- Elliot L. Tobin - UD/CS '02 [EMAIL PROTECTED] Univ. of Delaware - Computer Science, Economics - - 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 I create database local in Windows upload to Linux server.
Hi Do you have a shell account on your server? It can be done but you would would need either ssh or telnet access. At 20:13 16/04/2001 -0400, SteveW wrote: Want to create databases programmatically, then upload to my host. Am using MS Access for my business database. Want to create a subset of the data in a mySQL database, and upload these to my website. Must be done on a routine basis and wanted to write the code in MS Access. Have been told by my ISP host that it does not work that way, that I must use a PHP interface to mySQL online (which would be to cumbersome, the way I understand it) and the data is stored somewhere out there in never-never land on the server. I need to do this programmatically, generating the database from my current business data. Would appreciate any advice and to email be directly. [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 Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: Fwd: Metadata Retrieval
At 17:47 16/04/2001 -0700, Sam Daniel wrote: I am interested in retrieving Field and Type information from a named table. Currently, MySQL allows me to see a table's description via mysql describe TheTable; returning its structure in the form of a table, including the Fields and Types columns. I would like to retrieve the contents of these two columns. What is the SQL call that will do this? You can use SHOW FIELDS FROM tableName; Sam Daniel Motorola 480-441-7431 - 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 Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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
how is this done
Hi, I have the following tables: Country: id | int(5) | | PRI | NULL| auto_increment | country | varchar(35) | | MUL | || contid | int(5) City: id| int(5) | | PRI | NULL| auto_increment | city | varchar(35) | | MUL | || countryid | int(5) | Special: id int(5) contid int(5) cityid int(5) I am using php for this project. Right now it is related to mysql. What I want is to display the names of the countries and cities from the Special table instead of the ids. What would be the correct syntax for the select statement? TIA Adrian - 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