installing 2 servers on the same Win 2K machine
Hello, I am planning to install 2 mysql servers on the same box whish runs Win2K. Has anyone experianced this before? Regards Okan - 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
cant create tables .....
hi guyz im stuck bad i cant create tables, the tables which had NO foreign keys or they didmt refer to another table were created fine but the ones WITH foreign key ... refferring to fieldz in other table(s) cant be created mysql>create table lang ( lang_id int auto_increment primary key, lang_ char(20) ); query ok, 0 rows effected mysql>create table usr_inf ( foreign key lang_id refrences lang(lang_id), ); gives me this error : error 1064: u ve an error in ur sql syntex near 'refrences lang(lang_id)'at line 1 i even tried this without (lang_id) but it still doesnt work where m i messing it up guyz id really appriciate any help on this thnx a million ... all of u stuck bad toby . _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: Thank you!I need your help!
"ÕÅÉƽð" wrote: > > I'm sorry that my English is very week!I come from Chinese ! My computer OS is >RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory! > the bad command message is : > NOTE: This is a MySQL binary distribution. It's ready to run, you don't > need to configure it! Don't sweat the language issue, but I've removed all non-essential messages and left the one that matters: you're trying to compile something that is ready to run. Try: /etc/init.d/mysql start And, see what happens. If that doesn't work, get the binary server or the full source version. RedHat has the mysql server on the CD as an RPM. Just install that... Van -- = Linux rocks!!! http://www.dedserius.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
Thank you!I need your help!
I'm sorry that my English is very week!I come from Chinese ! My computer OS is RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory! the bad command message is : [root@guanqun zsj]# cd /usr/local/src/zsj [root@guanqun zsj]# cd mysql-4.0.1-alpha-pc-linux-gnu-i686 [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# ./configure --prefix=/usr/lo cal/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 980101 0:19:39 ./bin/mysqld: Shutdown Complete 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 password 'new-password' ./bin/mysqladmin -u root -h guanqun.com 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/mysqld_safe & 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 Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/local/src/zsj/mysql-4.0.1-alpha- pc-linux-gnu-i686/data 980101 00:19:39 mysqld ended [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make make: *** No targets specified and no makefile found. Stop. [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make install make: *** No rule to make target `install'. Stop. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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: get months between two dates
Consider taking a look at the manual: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Perhaps read parts of it, too. Fix your PC's date (the current year for most of us is 2002). Many of us who receive e-mail dated in the past filter it to /dev/null. Van -- = Linux rocks!!! http://www.dedserius.com/ = "D.K.Dubey" wrote: > > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > - 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 months between two dates
Hi, Can anybody tell me how i can calculate the months between two dates in mysql. thanks in advance Regards D K Dubey - 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 help me
I couldn't ./configure and make mysql.The mistake is: 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/mysqld_safe & 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 Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/local/src/zsj/mysql-4.0.1-alpha- pc-linux-gnu-i686/data 020624 12:23:27 mysqld ended [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make make: *** No targets specified and no makefile found. Stop. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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 help me
I couldn't ./configure and make mysql.The mistake is: 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/mysqld_safe & 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 Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/local/src/zsj/mysql-4.0.1-alpha- pc-linux-gnu-i686/data 020624 12:23:27 mysqld ended [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make make: *** No targets specified and no makefile found. Stop. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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: help starting up mysql
See below: > oops, Mac OS X. > > on 6/23/02 10:16 PM, Danny, typed: > > > Hello, > > > > What version of UNIX are you running? > > Solaris, Linux, FreeBSD, BSDI? > > > > You can find that out my typing in uname -a . . . > > > >> Hi, > >> I hope I'm at the right list! > >> > >> I'm trying to start mysql -I have installed the db. > >> > >> Now I'm getting the following: > >> > >> [localhost:~] lloyd% sudo safe_mysqld --user=root & > >> [1] 630 > >> [localhost:~] lloyd% Starting mysqld daemon with databases from > >> /usr/local/mysql/data > >> 020623 20:25:20 mysqld ended > >> > >> mysqladmin version > >> ./bin/mysqladmin: connect to server at 'localhost' failed > >> error: 'Can't connect to local MySQL server through socket > > '/tmp/mysql.sock' > >> (61)' > >> Check that mysqld is running and that the socket: '/tmp/mysql.sock' > > exists! So does the socket exist? If it exists, are the permissions correct for the user you have mySQL running as? > >> [1] + Done sudo safe_mysqld --user=root > >> [localhost:~] lloyd% mysql > >> ERROR 2002: Can't connect to local MySQL server through socket > >> '/tmp/mysql.sock' (61) > >> > >> What do I need to do, please? I myself made the directory to store the sockets in by hand. I doubt that was the right thing to do, but I was able to get mySQL to run, query the permissions table from the command line, etc. > >> (Does this list have a searchable archive?) Look here: http://www.mysql.com/documentation/searchlists.html Also, the AIMS group (MARC) list (un-official?): http://marc.theaimsgroup.com/?l=mysql&r=1&w=2 -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help starting up mysql
oops, Mac OS X. Lloyd on 6/23/02 10:16 PM, Danny, typed: > Hello, > > What version of UNIX are you running? > Solaris, Linux, FreeBSD, BSDI? > > You can find that out my typing in uname -a > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, June 24, 2002 11:01 AM > Subject: help starting up mysql > > >> Hi, >> I hope I'm at the right list! >> >> I'm trying to start mysql -I have installed the db. >> >> Now I'm getting the following: >> >> [localhost:~] lloyd% sudo safe_mysqld --user=root & >> [1] 630 >> [localhost:~] lloyd% Starting mysqld daemon with databases from >> /usr/local/mysql/data >> 020623 20:25:20 mysqld ended >> >> mysqladmin version >> ./bin/mysqladmin: connect to server at 'localhost' failed >> error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' >> (61)' >> Check that mysqld is running and that the socket: '/tmp/mysql.sock' > exists! >> [1] + Done sudo safe_mysqld --user=root >> [localhost:~] lloyd% mysql >> ERROR 2002: Can't connect to local MySQL server through socket >> '/tmp/mysql.sock' (61) >> >> What do I need to do, please? >> >> (Does this list have a searchable archive?) >> >> Lloyd - 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
UDF on win2k??
hi, i checked the manual, but i want a confirmation here: Mysql for window doesn't have UDF, right? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: help starting up mysql
Hello, What version of UNIX are you running? Solaris, Linux, FreeBSD, BSDI? You can find that out my typing in uname -a - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 11:01 AM Subject: help starting up mysql > Hi, > I hope I'm at the right list! > > I'm trying to start mysql -I have installed the db. > > Now I'm getting the following: > > [localhost:~] lloyd% sudo safe_mysqld --user=root & > [1] 630 > [localhost:~] lloyd% Starting mysqld daemon with databases from > /usr/local/mysql/data > 020623 20:25:20 mysqld ended > > mysqladmin version > ./bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' > (61)' > Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! > [1] + Done sudo safe_mysqld --user=root > [localhost:~] lloyd% mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (61) > > What do I need to do, please? > > (Does this list have a searchable archive?) > > Lloyd > > > - > 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
Building MySQL 3.23.51 on AIX using VisualAge compiler rev 5020
I'm trying in vain to build the latest version of MySQL 3.23.51 (downloaded today) on a new AIX box we've recently setup. It has the latest IBM patches for the VisualAge C++ compiler v5, bringing it up to rev 5020. When building, there are two problems.. One is that the configure script improperly determines the proper way to use gethostbyname_r for this platform and causes the errors when compiling my_gethostbyname.c due to not setting HAVE_GETHOSTBYNAME_R_RETURN_INT. Instead it tries to use a function that returns a struct, which causes lots of problems. I hacked that problem by hand in config.h and acconfig.h.. Also, libtool needed to be hacked due to it passing an option to the compiler similar to "{-wl},-berok".. I just removed the "{-wl}," and left it as "-berok".. The next problem is a bit more difficult.. It arises when libtool is invoked in libmysql_r, and is passing a bad option to the compiler (-L with no other option following it) gmake[2]: Entering directory `/quest/vista/rflower/src/databases/mysql/irvvsdu02/mysql-3.23.51/libmysql_ r' /bin/sh ../libtool --mode=link xlc_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 -g -DDBUG_ON -DSAFE_MUTEX -I /usr/local/include -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -L /usr/local/lib -o libmysqlclient_r.la -rpath /opt/mysql/lib/mysql -version-info 10:0:0 libmysql.lo net.lo violite.lo password.lo get_password.lo errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo typelib.lo safemalloc.lo my_alloc.lomf_format.lo mf_path.lo mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo charset.lo hash.lo mf_iocache.lo my_seek.lo my_pread.lo mf_cache.lo my_gethostbyname.lo getopt.lo getopt1.lo getvar.lo my_lib.lo strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lostrcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl_r -lm rm -fr .libs/libmysqlclient_r.la .libs/libmysqlclient_r.* .libs/libmysqlclient_r.* xlc_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 -bM:SRE -o .libs/libmysqlclient_r.so.10.0.0 libmysql.o net.o violite.o password.o get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o my_create.o my_delete.o mf_tempfile.o my_open.o mf_casecnv.o my_read.o my_write.o errors.o my_error.o my_getwd.o my_div.o mf_pack.o my_messnc.o mf_dirname.o mf_fn_ext.o mf_wcomp.o typelib.o safemalloc.o my_alloc.o mf_format.o mf_path.o mf_unixpath.o my_fopen.o my_symlink.o my_fstream.o mf_loadpath.o my_pthread.o my_thr_init.o thr_mutex.o mulalloc.o string.o default.o my_compress.o array.o my_once.o list.o my_net.o charset.o hash.o mf_iocache.o my_seek.o my_pread.o mf_cache.o my_gethostbyname.o getopt.o getopt1.o getvar.o my_lib.o strmov.o strxmov.o strnmov.o strmake.o strend.o strnlen.o strfill.o is_prefix.o int2str.o str2int.o strinstr.o strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o strtoull.o strtoll.o llstr.o ctype.o dbug.o -L -lz -lcrypt -lnsl_r -lm -lc -bexpall -bnoentry -berok xlc_r: 1501-208 command option L is missing a subargument gmake[2]: *** [libmysqlclient_r.la] Error 40 gmake[2]: Leaving directory `/quest/vista/rflower/src/databases/mysql/irvvsdu02/mysql-3.23.51/libmysql_ r' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/quest/vista/rflower/src/databases/mysql/irvvsdu02/mysql-3.23.51' gmake: *** [all-recursive-am] Error 2 Any comments on this one? I'm thinking again that libtool is at fault here, but I'm not 100% sure.. - 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
help starting up mysql
Hi, I hope I'm at the right list! I'm trying to start mysql -I have installed the db. Now I'm getting the following: [localhost:~] lloyd% sudo safe_mysqld --user=root & [1] 630 [localhost:~] lloyd% Starting mysqld daemon with databases from /usr/local/mysql/data 020623 20:25:20 mysqld ended mysqladmin version ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [1] + Done sudo safe_mysqld --user=root [localhost:~] lloyd% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) What do I need to do, please? (Does this list have a searchable archive?) Lloyd - 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 Query using ASP
OOPS sorry I found the answer by myself It was just the % symbol that was misplaced :)) -Message d'origine- De : Alexandre Zglav [mailto:[EMAIL PROTECTED]] Envoyé : dimanche, 23. juin 2002 23:09 À : [EMAIL PROTECTED] Objet : RE: MySQL Query using ASP -Message d'origine- De : Alexandre Zglav [mailto:[EMAIL PROTECTED]] Envoyé : dimanche, 23. juin 2002 23:07 À : [EMAIL PROTECTED] Objet : MySQL Query using ASP Hi all ! once again thanks for the help you provide me by being so active on this mailing list :) I have a litle problem querying a MySQL DB using an ASP script . Everything works perfectly with my DSN and ODBC driver ( MyODBC ) and I can access the entries of a MySQL DB quite easely using an ASP script with simple queries. Now I am having big trouble when querying a variable. Let me explain . Here is a piece of code I use to get the entries in a table using a WHERE clause and a LIKE clause : <% @language="VBSCRIPT" %> <% Option Explicit %> HFT MOBILE FOREIGN EXCHANGE CONVERTER <% set ConnObj=Server.CreateObject("ADODB.Connection") ConnObj.open "PQATEST" ' This is the querry I use set RecordSet= ConnObj.execute("SELECT CurrencyA, RatetoCHF FROM data WHERE CurrencyA Like ' CHF%' ") If (NOT RecordSet.EOF) Then RecordSet.MoveFirst While (NOT RecordSet.EOF) Response.write(FormatNumber(RecordSet("RatetoCHF"),6)) Response.write("") RecordSet.MoveNext wend ConnObj.close set ConnObj=nothing %> Ok this querry works perfectly and I get back all the enties where CurrencyA is Like 'CHF' Now what If I try a variant like this one : ' Same as before so dont bother ... :) <% @language="VBSCRIPT" %> <% Option Explicit %> HFT MOBILE FOREIGN EXCHANGE CONVERTER <% ' ok now lets define a variable dim CurrencyA 'Lets assign a value to it ( note that the value will be given by a formulary in a web page ) CurrencyA = "CHF" 'Same as before set ConnObj=Server.CreateObject("ADODB.Connection") ConnObj.open "PQATEST" 'Now here is my new querry. I'm getting the value of variable CurrencyA with concatenation. ( This works perfect with Access ) set RecordSet= ConnObj.execute("SELECT CurrencyA, RatetoCHF FROM data WHERE CurrencyA Like ' " & CurrencyA & " '% ") ' Same as before blablabla If (NOT RecordSet.EOF) Then RecordSet.MoveFirst While (NOT RecordSet.EOF) Response.write(FormatNumber(RecordSet("RatetoCHF"),6)) Response.write("") RecordSet.MoveNext wend ConnObj.close set ConnObj=nothing %> Now here is the error message I get in the generated webpage Microsoft OLE DB Provider for ODBC Drivers error '80040e09' [TCX][MyODBC]You have an error in your SQL syntax near '' at line 1 /PQA/test.asp, line 19 I just dont get where the problem is as I'm quite used to do it this way with M$ Access . It seems that MySQL gets the " character as a part of the LIKE statement and IT SHOULDNT !! Well I'm quite despaired now, going to bed after hours of research in all the forums out there, hoping that tomorow some nice People like you will have answered me . Thanks a lot in advance and see ya :) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Query using ASP
-Message d'origine- De : Alexandre Zglav [mailto:[EMAIL PROTECTED]] Envoyé : dimanche, 23. juin 2002 23:07 À : [EMAIL PROTECTED] Objet : MySQL Query using ASP Hi all ! once again thanks for the help you provide me by being so active on this mailing list :) I have a litle problem querying a MySQL DB using an ASP script . Everything works perfectly with my DSN and ODBC driver ( MyODBC ) and I can access the entries of a MySQL DB quite easely using an ASP script with simple queries. Now I am having big trouble when querying a variable. Let me explain . Here is a piece of code I use to get the entries in a table using a WHERE clause and a LIKE clause : <% @language="VBSCRIPT" %> <% Option Explicit %> HFT MOBILE FOREIGN EXCHANGE CONVERTER <% set ConnObj=Server.CreateObject("ADODB.Connection") ConnObj.open "PQATEST" ' This is the querry I use set RecordSet= ConnObj.execute("SELECT CurrencyA, RatetoCHF FROM data WHERE CurrencyA Like ' CHF%' ") If (NOT RecordSet.EOF) Then RecordSet.MoveFirst While (NOT RecordSet.EOF) Response.write(FormatNumber(RecordSet("RatetoCHF"),6)) Response.write("") RecordSet.MoveNext wend ConnObj.close set ConnObj=nothing %> Ok this querry works perfectly and I get back all the enties where CurrencyA is Like 'CHF' Now what If I try a variant like this one : ' Same as before so dont bother ... :) <% @language="VBSCRIPT" %> <% Option Explicit %> HFT MOBILE FOREIGN EXCHANGE CONVERTER <% ' ok now lets define a variable dim CurrencyA 'Lets assign a value to it ( note that the value will be given by a formulary in a web page ) CurrencyA = "CHF" 'Same as before set ConnObj=Server.CreateObject("ADODB.Connection") ConnObj.open "PQATEST" 'Now here is my new querry. I'm getting the value of variable CurrencyA with concatenation. ( This works perfect with Access ) set RecordSet= ConnObj.execute("SELECT CurrencyA, RatetoCHF FROM data WHERE CurrencyA Like ' " & CurrencyA & " '% ") ' Same as before blablabla If (NOT RecordSet.EOF) Then RecordSet.MoveFirst While (NOT RecordSet.EOF) Response.write(FormatNumber(RecordSet("RatetoCHF"),6)) Response.write("") RecordSet.MoveNext wend ConnObj.close set ConnObj=nothing %> Now here is the error message I get in the generated webpage Microsoft OLE DB Provider for ODBC Drivers error '80040e09' [TCX][MyODBC]You have an error in your SQL syntax near '' at line 1 /PQA/test.asp, line 19 I just dont get where the problem is as I'm quite used to do it this way with M$ Access . It seems that MySQL gets the " character as a part of the LIKE statement and IT SHOULDNT !! Well I'm quite despaired now, going to bed after hours of research in all the forums out there, hoping that tomorow some nice People like you will have answered me . Thanks a lot in advance and see ya :) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: (fwd) sorting question
I wrote earlier: >select b.id, a.aid, a.wid, a.start, a.length >into outfile 'newindex.txt' >from wordindex a, wordforms b >where a.wordform = b.wordform >order by b.id, a.id, a.wid, a.start; I've actually sat down and tried this at the mysql command line. Problem was, I started it at about 11pm last night and it's 1:20pm today. Not only is it still sitting there, but it hasn't written a single thing out yet (if I look at the outfile, it's there, but 0 length). For an idea of how large the file is, when the above command is done without the order by restrictions, I get a file of the form 551772 1 1 44 6 877857 1 1 52 11 703278 1 1 65 4 563277 1 1 71 5 806092 1 1 78 8 863071 1 1 88 3 956338 1 1 93 8 (etc) that output takes about three - four hours to create, and its finished size is -rw-r--r-- 1 ctmoore staff1831793634 Jun 22 22:29 newindex.b.txt Is mysql unable to handle something this large when it has to sort as well? Or are there some whizbit things I can do to fine tune this? Thanks, --Cindy - 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: Threads or Prozesses on Linux, and how to control them?
On Sun, Jun 23, 2002 at 08:02:45PM +0100, Paul Roberts wrote : > php will close the connection when the script finishes unless > you are using mysql_pconnect which opens a persistent > connection. Yup, ever resource besides persistent ones are cleaned up upon script termination. > From: "Joseph Bueno" <[EMAIL PROTECTED]> > To: "Markus Fischer" <[EMAIL PROTECTED]> > mysqld uses threads (you already found the right documentation). > > > How long is the life-time of a connection if there's no > > request comming anymore? The mysqld is acesssed with PHP and > > I'm using normal mysql_connect() so connections aren't > > persisten so they should go after some time? > > > > > > The thread is created when a client opens a new connection and destroyed > when the client closes the connection (unless you explicitely ask mysqld > to keep some of them, see 'thread_cache_size' server parameter). Ok, I do not use thread_cache_size and looking into the mysql documentation the default thread_cache_size is 0. Since PHP then closes the connection, how is it possible that there are about 22-24 threads running? This site is my all means not a busy site. If I check the sql log it takes up to 5 to 10 seconds before a new query occurs which means that I seldomly get two connection attempts in the same second ... It doesnt seem to exceed the 24 limit though. just curious and thanks for the inforamtion, - Markus - 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: Threads or Prozesses on Linux, and how to control them?
php will close the connection when the script finishes unless you are using mysql_pconnect which opens a persistent connection. http://za2.php.net/manual/en/ref.msql.php Paul Roberts [EMAIL PROTECTED] - Original Message - From: "Joseph Bueno" <[EMAIL PROTECTED]> To: "Markus Fischer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 6:36 PM Subject: Re: Threads or Prozesses on Linux, and how to control them? Markus Fischer wrote: > [Please CC: directly to me, I'm not subscribed] > > Hi, > > maybe a pointer to the documentation is sufficient, but does > mysqld uses linux-threads or processes? mysqld uses threads (you already found the right documentation). > > And is there way to control them? After I start up mysqld I > see 3 processes with ps. After some time (e.h. 12 hours) I > spotted about 24 (!) of them. > > I've enabled sql logging and see that only every few seconds > requests are comming, even more time. I never see the number > if processes shrinking and I don't remember setting a limit > somewhere (compared to apache where I can control this). > > On http://www.mysql.com/doc/M/y/MySQL_threads.html I found > > "Every connection has its own thread." > > A few senteces above on this page there were talks about > tcp/ip, but I'm only using sockets for the whole time, so > this applies there too? > You get one thread per client connection. It is the same for any communication channel (TCP/IP, UNIX socket,...). > How long is the life-time of a connection if there's no > request comming anymore? The mysqld is acesssed with PHP and > I'm using normal mysql_connect() so connections aren't > persisten so they should go after some time? > > The thread is created when a client opens a new connection and destroyed when the client closes the connection (unless you explicitely ask mysqld to keep some of them, see 'thread_cache_size' server parameter). I have no experience with PHP, are you sure that the connection is closed at the end of the HTTP request ? > thx for any hints, > > - Markus > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > Regards -- Joseph Bueno - 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: Threads or Prozesses on Linux, and how to control them?
Markus Fischer wrote: > [Please CC: directly to me, I'm not subscribed] > > Hi, > > maybe a pointer to the documentation is sufficient, but does > mysqld uses linux-threads or processes? mysqld uses threads (you already found the right documentation). > > And is there way to control them? After I start up mysqld I > see 3 processes with ps. After some time (e.h. 12 hours) I > spotted about 24 (!) of them. > > I've enabled sql logging and see that only every few seconds > requests are comming, even more time. I never see the number > if processes shrinking and I don't remember setting a limit > somewhere (compared to apache where I can control this). > > On http://www.mysql.com/doc/M/y/MySQL_threads.html I found > > "Every connection has its own thread." > > A few senteces above on this page there were talks about > tcp/ip, but I'm only using sockets for the whole time, so > this applies there too? > You get one thread per client connection. It is the same for any communication channel (TCP/IP, UNIX socket,...). > How long is the life-time of a connection if there's no > request comming anymore? The mysqld is acesssed with PHP and > I'm using normal mysql_connect() so connections aren't > persisten so they should go after some time? > > The thread is created when a client opens a new connection and destroyed when the client closes the connection (unless you explicitely ask mysqld to keep some of them, see 'thread_cache_size' server parameter). I have no experience with PHP, are you sure that the connection is closed at the end of the HTTP request ? > thx for any hints, > > - Markus > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > Regards -- Joseph Bueno - 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
mysql shuts itself down and doesn't restart
Hi, members, I'm relatively new to mySQL. I have several databases up and running but am facing one recurring, and quite annoying, problem: mysqld is shutting itself down. Here's the sequence that results in the shutdown: 020623 0:29:23 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER Status information: Current locks: key_cache status: blocks used:... . . . handler status: . . . Table status: . . . 020623 0:29:25 /usr/libexec/mysqld: Normal shutdown 020623 0:29:25 /usr/libexec/mysqld: Shutdown Complete 020623 00:29:25 mysqld ended Unfortunately, the daemon doesn't restart; I have to restart it manually. Can anyone please help me determine what I can do to ensure that the server is up whenever a request comes in? I really appreciate your help. Thanks. Joe Rogoiyo - 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) sorting question
OK< I must say I don't think much of this filter if it couldn't tell it was a relevant question. After all, there's a select statement in it!! Anyway, any help or comments appreciated. Since initially sending this, I've learned why my predecesser did it this way -- eight hours later, and it's still working on the output -- much too long. Previously it would take about three hours to write the unsorted file out and then unix's sort another hour or two. But the unix sort is breaking on it at the moment (I suspect due to the current size of the output). So to add to this question, is there some way of optimizing this? --- Forwarded Message Date:Sun, 23 Jun 2002 10:20:22 +0200 From:[EMAIL PROTECTED] To: Cindy <[EMAIL PROTECTED]> Subject: Re: sorting output Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've taken over a project put together by someone else. This person did a lot of very weird things :-) and I'm thinking I can save myself some work. First, he created a file as follows select b.id, a.aid, a.wid, a.start, a.length into outfile 'newindex.txt' from wordindex a, wordforms b where a.wordform = b.wordform; It looks roughly like this: 370210 1 1 155 11 917880 1 1 168 7 1259959 1 1 178 8 789078 1 1 188 4 735168 1 1 194 4 499918 1 1 200 8 ... Then he sorted it out, basically by sorting the first field, then within that sort, by the second, then the third, and then the fourth (if I'm reading the sort man page correctly): /usr/xpg4/bin/sort -n -o newindex1.txt -k 1,1 -k 2,2 -k 3,3 -k 4,4 newindex.txt My question is this: can't I just output the darned thing already sorted? With something like: select b.id, a.aid, a.wid, a.start, a.length into outfile 'newindex.txt' from wordindex a, wordforms b where a.wordform = b.wordform order by b.id, a.id, a.wid, a.start; or are there arcane restrictions on a select that is output to a file? But anyway, seems to me I've already got the ability to sort this silly thing out beforehand and so eliminating a step. Thanks, - --Cindy - -- [EMAIL PROTECTED] --- End of Forwarded Message - 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
Reporting Help
I'm trying to extract information from MySQL with Microsoft Access but it will not pull a query with BIGINT columns correctly. I'm using the newest ODBC driver, version 3.51.03 and MySQL Server Alpha 4.0.1. I've installed the ODBC driver, configured the DSN, and can access all other types of columns from what I have tested so far. I've tried creating a dummy timestamp column like the documentation says and that doesn't work. I cannot use the option "Change BIGINT columns to INT" because then my data does not display correctly when the number is over 4294967295. I also tried recreating the link in Access and that doesn't work. I must have number columns that can support a number up to 99. (18 characters long) Can anyone else make a suggestion on how to correct this or is there a better way to generate reports with MySQL? Thank you for any help... 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: Strings query question
SELECT id, songname FROM tablename WHERE TRIM(BOTH ' ' FROM songname)="One"; See: http://www.mysql.com/doc/S/t/String_functions.html Gurhan - Original Message - From: <[EMAIL PROTECTED]> To: "Jan Peuker" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 8:58 AM Subject: Re: Strings query question > Thanks, that worked for song named "Empire", however, > when I checked other song names such as songname > called "One" I get two results: > > | id | songname | > +++ > | 35 | > You're Still The One | > | 57 | > One | > +++ > 2 rows in set (0.00 sec) > > How do I get exact match only between two strings or > remove whitespace before and after string? I can't seem > to find any good emaples of string comparisons for exact > match. > > Songname field is a VARCHAR(55). I thought VARCHAR saves > only the length of the string where as CHAR adds > whitespace to parts not used in the field > > > "Like" is better because maybe there is a \n or \r\n after your string, > > further it seems there are many whitespaces after the word. > > Try WHERE songname LIKE "%Empire%". > > > > just my 0,02 > > > > jan > > > > > > - Original Message - > > From: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > Sent: Sunday, June 23, 2002 2:27 PM > > Subject: Strings query question > > > > > > I do not understand string comparison. Why doesn't the > > following work: > > > > SELECT id, songname FROM songs WHERE songname = "Empire"; > > > > All I get is: Empty set (0.00 sec) > > > > I know the string exists in the database: > > > > In record 135 exists: > > Empire | > > | 135 | > > > > Do I have to use "LIKE"? > > > > I want to match a string from one table with a string > > from another table so I can display the data from the > > matched record. > > > > select movietable.id, movietable.songname, songs.id, > > songs.songname FROM movietable, songs WHERE > > movietable.songname = songs.songname; > > > > Results: Empty set (0.19 sec) > > > > This doesn't work either > > select movietable.songname, movietable.ID, > > songs.songname, songs.id FROM movietable, songs WHERE > > movietable.songname = "Empire"; > > > > Yet, I know that movietable.songname contains a song > > called "Empire" and movietable.songs also contains a > > song called "Empire" > > > > How do I match the two strings? > > > > Running Linux with MySQL-3.23.32-1.7 > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Bug - bug list rejected
* Chris Beasley > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's > because of MySQL. > I have a value I am inserting into a database and above and below > my query I > can echo out the value and it is correct, but the query keeps > assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it. This is a classic. :) Your field is defined as a TINYINT, an signed single byte datatype with a max value of 127. You should redifine the field type to a SMALLINT, probably even a UNSIGNED SMALLINT. http://www.mysql.com/doc/C/o/Column_types.html > -- Roger - 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 Bug - bug list rejected
I don't think this is a bug, you probably choose TINYINT datatype for the column, and the maximum value a TINYINT column can have is 127, so anything over 127 will automatically be changed to 127 silently by MySQL. Choose an appropriate column datatype for your field. See: http://www.mysql.com/doc/C/o/Column_types.html Gurhan - Original Message - From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 10:46 AM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's because of MySQL. > I have a value I am inserting into a database and above and below my query I > can echo out the value and it is correct, but the query keeps assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it. > > More detailed explanation is here: > > http://www.sitepointforums.com/showthread.php?s=&postid=477502 > > Check out the thread, if I don't have absolute proof of a MySQL bug then I > don't think such proof would be possible to get. > > Chris Beasley > > > - > 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 Bug - bug list rejected
Hi, Your column comid is probably declared as a tinyint which has a range between -128 and 127 (for not UNSIGNED column). If you want to allow larger values, change the column type accordingly. (Take a look here : http://www.mysql.com/doc/C/o/Column_types.html ) Regards, Jocelyn Fournier - Original Message - From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 4:46 PM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's because of MySQL. > I have a value I am inserting into a database and above and below my query I > can echo out the value and it is correct, but the query keeps assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it. > > More detailed explanation is here: > > http://www.sitepointforums.com/showthread.php?s=&postid=477502 > > Check out the thread, if I don't have absolute proof of a MySQL bug then I > don't think such proof would be possible to get. > > Chris Beasley > > > - > 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: Strings query question
* [EMAIL PROTECTED] > Thanks, that worked for song named "Empire", however, > when I checked other song names such as songname > called "One" I get two results: > > | id | songname | > +++ > | 35 | > You're Still The One | > | 57 | > One | > +++ > 2 rows in set (0.00 sec) > > How do I get exact match only between two strings or > remove whitespace before and after string? To remove the unwanted \n or \r\n from your table, you can use the REPLACE() function: UPDATE songtable SET songname = TRIM(REPLACE(REPLACE(songname,'\n',''),'\r','')) Beware that this will remove _all_ return and linefeed characters, not only leading and trailing. The outer TRIM() function removes only leading/trailing _space_ characters. The outer TRIM() may be unnecessary if you don't have "\n title" in your data, only "\ntitle", "\rtitle" or "\r\ntitle". Removing '\r' is only needed if the data contains '\r', which it may do if the data comes from a windows environment. If the data is originally produced on your linux machine, you may simplify to: UPDATE songtable SET songname = REPLACE(songname,'\n','') > I can't seem > to find any good emaples of string comparisons for exact > match. Exact matching is done using = (the equal sign), but you don't have an exact match in this case... http://www.mysql.com/doc/S/t/String_functions.html > http://www.mysql.com/doc/S/t/String_comparison_functions.html > > Songname field is a VARCHAR(55). I thought VARCHAR saves > only the length of the string where as CHAR adds > whitespace to parts not used in the field CHAR fields are padded with _space_ characters, not any whitespace... and these space characters are automatically removed when you retrieve the data. Your \n and/or \r characters are considered a part of your string, and is not ignored. -- Roger - 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
MySQL Bug - bug list rejected
I tried posting this on the bug list and it rejected it. I've got this bug in a php script of mine and I think it's because of MySQL. I have a value I am inserting into a database and above and below my query I can echo out the value and it is correct, but the query keeps assuming it is "127" No matter what I do, I've renamed the variable, renamed the field, changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just making up this number, there is no place it could get it. More detailed explanation is here: http://www.sitepointforums.com/showthread.php?s=&postid=477502 Check out the thread, if I don't have absolute proof of a MySQL bug then I don't think such proof would be possible to get. Chris Beasley - 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: garbage data stored .....
* toby - > im working with some unicode data , store it in mysql db and retrieve it > now its storing the data fine when i use longtext or mediumtext > EXCEPT for a few characters Try using longblob or mediumblob. -- Roger sql - 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
help please!!!
well I have problem and I don´t know where ask for help, so i´m trying you. My problem is i´m developing my project using mysql 4.0.1, in a single computer (not net), OS windows 98,and using Delphi 5. well SOMETIMES (NOT IN ALL RECORDS) when i try to edit a record the program send me an exception (to be more especific when then POST is being executed), the message is the following "Could´t perform the edit because another user changed the record", i´m not using the table in another aplication and there´s no other user, maybe it´s a case of configuration that i didn´t during the configuration of the alias in the ODBC, or maybe it´s problem of version of mysql 4.0.1 or myodbc that i´m using. So, if sombody can help i´ll thank a lot, cause i´m getting crazy with this and my project is getting poor. Thank you a lot. __ AcessoBOL, só R$ 9,90! O menor preço do mercado! Assine já! http://www.bol.com.br/acessobol - 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: Strings query question
Thanks, that worked for song named "Empire", however, when I checked other song names such as songname called "One" I get two results: | id | songname | +++ | 35 | You're Still The One | | 57 | One | +++ 2 rows in set (0.00 sec) How do I get exact match only between two strings or remove whitespace before and after string? I can't seem to find any good emaples of string comparisons for exact match. Songname field is a VARCHAR(55). I thought VARCHAR saves only the length of the string where as CHAR adds whitespace to parts not used in the field > "Like" is better because maybe there is a \n or \r\n after your string, > further it seems there are many whitespaces after the word. > Try WHERE songname LIKE "%Empire%". > > just my 0,02 > > jan > > > - Original Message - > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Sent: Sunday, June 23, 2002 2:27 PM > Subject: Strings query question > > > I do not understand string comparison. Why doesn't the > following work: > > SELECT id, songname FROM songs WHERE songname = "Empire"; > > All I get is: Empty set (0.00 sec) > > I know the string exists in the database: > > In record 135 exists: > Empire | > | 135 | > > Do I have to use "LIKE"? > > I want to match a string from one table with a string > from another table so I can display the data from the > matched record. > > select movietable.id, movietable.songname, songs.id, > songs.songname FROM movietable, songs WHERE > movietable.songname = songs.songname; > > Results: Empty set (0.19 sec) > > This doesn't work either > select movietable.songname, movietable.ID, > songs.songname, songs.id FROM movietable, songs WHERE > movietable.songname = "Empire"; > > Yet, I know that movietable.songname contains a song > called "Empire" and movietable.songs also contains a > song called "Empire" > > How do I match the two strings? > > Running Linux with MySQL-3.23.32-1.7 > > - > 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
Strings query question
I do not understand string comparison. Why doesn't the following work: SELECT id, songname FROM songs WHERE songname = "Empire"; All I get is: Empty set (0.00 sec) I know the string exists in the database: In record 135 exists: Empire | | 135 | Do I have to use "LIKE"? I want to match a string from one table with a string from another table so I can display the data from the matched record. select movietable.id, movietable.songname, songs.id, songs.songname FROM movietable, songs WHERE movietable.songname = songs.songname; Results: Empty set (0.19 sec) This doesn't work either select movietable.songname, movietable.ID, songs.songname, songs.id FROM movietable, songs WHERE movietable.songname = "Empire"; Yet, I know that movietable.songname contains a song called "Empire" and movietable.songs also contains a song called "Empire" How do I match the two strings? Running Linux with MySQL-3.23.32-1.7 - 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: Understanding relational database setup/construction
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cal -- ...and then Cal Evans said... % % TjL, % % To start with: Thanks for the titles! ... % Work your way through both books in a couple of months and then spend every % waking hour organizing data into tables for a couple of years and you'll be This is what scares me. I want to "get it" *NOW*! :-) % there. (You know you have arrived when start assigning family members % primary keys beause, well everybody knows that SSN's aren't unique!) ;) Or required :-) % % % HTH, % =C= HAND & sql query :-D - -- David T-G * It's easier to fight for one's principles (play) [EMAIL PROTECTED] * than to live up to them. -- fortune cookie (work) [EMAIL PROTECTED] http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9Fa1uGb7uCXufRwARAgHJAJ9xBmdWFTtm4XL1ENxq/vnoMe1fvgCeKBf8 eTizD4btLRgz+zDRC2hJBQ0= =fX/z -END PGP SIGNATURE- - 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
Threads or Prozesses on Linux, and how to control them?
[Please CC: directly to me, I'm not subscribed] Hi, maybe a pointer to the documentation is sufficient, but does mysqld uses linux-threads or processes? And is there way to control them? After I start up mysqld I see 3 processes with ps. After some time (e.h. 12 hours) I spotted about 24 (!) of them. I've enabled sql logging and see that only every few seconds requests are comming, even more time. I never see the number if processes shrinking and I don't remember setting a limit somewhere (compared to apache where I can control this). On http://www.mysql.com/doc/M/y/MySQL_threads.html I found "Every connection has its own thread." A few senteces above on this page there were talks about tcp/ip, but I'm only using sockets for the whole time, so this applies there too? How long is the life-time of a connection if there's no request comming anymore? The mysqld is acesssed with PHP and I'm using normal mysql_connect() so connections aren't persisten so they should go after some time? thx for any hints, - Markus - 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: Load problems with 3.23.51
On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: > Hi all, > > I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and > tried 51. No dice. It does not handle load, CPU and the load average go > through the roof. I'm using Red Hat Linux 7.2 and the official mysql > binaries. It appears to be slow to connect, causing 0.5 to 1.0 second > delay on connection. Using persistent connections from PHP does not make > much of a difference. I thought it might be the hostname lookup changes > so I chose skip-grant-tables. This doesn't actually skip the hostname > lookup though and had no effect. > > Most queries are shorter than 1 second so this problem causes > catastrophic problems by making queries last a multiple times longer, > which make the number of concurrent queries jump exponentially. This is > a bad thing. And sadly makes 3.23.51 unusable. > > Does anyone else note these types of issues? As another data point for you, I've got 3.23.51 running on our master quite well. The difference is that I built it from source (to get a critical InnoDB patch). I don't recall which compiler the MySQL folks used (and which glibc), but my source build used Debian Woody's gcc 2.95.4. That could have something to do with it... Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 24 days, processed 523,371,775 queries (248/sec. avg) - 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
importing ms sql tables
Hi there, I must start out by saying that i am a newbie in the Mysql arena. If i can i will give a bit of background information. Where i work we currently have a MS SQL 7.0, It has a database on there of support calls (100,000 records) that i would like to take and import into Mysql. Thus far i have exported the 24 tables from the database in CSV format and transferred the files to the linux machine. Now from reading through the online manual i see there is a LOAD DATA LOCAL INFILE function that is turned off by default, to enable i have pass mysql an option . somewhere ... Is this the only thing i need to do to get the data into mysql? And if i do get this done will it then take on the properties of the tables that i am importing, eg when i do a create table you have to specify the table size etc. As i said i am only new to this, and would like to thank anyone for their assistance. On another note, having gone through some tutorials online and having found some of them a little brief on information and examples, is anyone able to suggest some good references. Thankyou in advance for your assistance. Regards Sebastian - 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
mysql daemon started asynchronously prevents logout - why ?
Hi all: I am running mysql-max 3.23.51 on linux 2.4.x and my shell is bash. The 'huponexit' shell option is off. The mysqld (mysql-max daemon) is probably not important for this discussion, any other daemon would do as well. Firstly, I can start mysqld (or other programs) asynchronously by saying: #> mysqld & [1] 858 #> bin/mysqld: ready for connections #> jobs [1]+ Running bin/mysqld & #> It's quite interesting that if I now say 'fg', the process comes up in the foreground but after that I cannot type anything (ctrl-z or bg have no affect). The daemon is trapping everything. But let's say, I don't say 'fg', instead, I say logout. #> logout Well, I am now stuck, am *not* logged out, and the shell does not accept any more commands. I can only logout if I kill the mysqld process from another shell (in another console). At *that* point, I see some 'mysql shutting down' messages and then I finally logout. I see the exact same behavior even if I originally start the daemon by saying: #> nohup mysqld & I was wondering, is this normal behavior ? I mean if I have a async process running in the background, (started either with '&' or 'nohup'), then I should be able to exit the shell by saying 'logout' right ? How can a asynch daemon prevent me from logging out ? 'logout' should kill mysqld (whether that's desirable is another story) but why/how does mysqld prevent a logout in the first place ? Anyone have an explanation ? Best regards, --j __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Permissions are now denied from the mysql client
Ruben I Safir wrote: > > I recently installed mysql on a new system and the client on works with root? > > Whats up? > > ruben@www2:~> !mys > mysql -p > Enter password: > ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > ruben@www2:~> > mysqld isn't running. Launch mysqld then try using the mysql client to access the databases. - 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: update syntax
You can achieve a similar thing with the WHERE column IN (SELECT column FROM table WHERE ..) subselect. In the current version of MySQL, this is not yet supported, but I've heard fearies tell that it will be in version 4.1, or else some other version to be released in the somewhere near future. -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Egor Egorov [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 20 juni 2002 15:53 Aan: [EMAIL PROTECTED] Onderwerp: Re: update syntax RBRoa, Thursday, June 20, 2002, 8:07:54 AM, you wrote: R> Is it possible to include another table in [where clause] using the update R> syntax in MySQL?.. R> e.g R> update xtran set f="X" where switch.rc=xtran.rc; R> something like this...a two tables involved in the update but one table only R> to modify... Using only MySQL nope. R> R.B.Roa -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Permissions are now denied from the mysql client
Of course it's running. I can only get in as the root user of the system On 2002.06.23 03:51 Brandon McCombs wrote: > > > Ruben I Safir wrote: > > > > I recently installed mysql on a new system and the client on works with root? > > > > Whats up? > > > > ruben@www2:~> !mys > > mysql -p > > Enter password: > > ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' >(2) > > ruben@www2:~> > > > > mysqld isn't running. Launch mysqld then try using the mysql client to > access the databases. > -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 - 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
Load problems with 3.23.51
Hi all, I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and tried 51. No dice. It does not handle load, CPU and the load average go through the roof. I'm using Red Hat Linux 7.2 and the official mysql binaries. It appears to be slow to connect, causing 0.5 to 1.0 second delay on connection. Using persistent connections from PHP does not make much of a difference. I thought it might be the hostname lookup changes so I chose skip-grant-tables. This doesn't actually skip the hostname lookup though and had no effect. Most queries are shorter than 1 second so this problem causes catastrophic problems by making queries last a multiple times longer, which make the number of concurrent queries jump exponentially. This is a bad thing. And sadly makes 3.23.51 unusable. Does anyone else note these types of issues? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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