converting database as text
Hi, Is there a way of converting mySQL database to a readable text file? What I mean is not importing the data via myODBC from another client, but by issuing a command to the Unix prompt (mySQL server itself) then it will generate a readable text file. Thanks in advance. Alex - 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: converting database as text
Hi Alexandrino. Have you tried % mysqldump db_name [table_name] ? Try it -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.ultracgis.com/sherzodR Sent on Jul 3 by Alexandrino B. Arvesu to [EMAIL PROTECTED] alex Hi, alex alex Is there a way of converting mySQL database to a readable text file? alex What I mean is not importing the data via myODBC from another client, but by alex issuing a command to the alex Unix prompt (mySQL server itself) then it will generate a readable text alex file. alex alex Thanks in advance. alex alex Alex alex alex alex alex alex - alex Before posting, please check: alexhttp://www.mysql.com/manual.php (the manual) alexhttp://lists.mysql.com/ (the list archive) alex alex To request this thread, e-mail [EMAIL PROTECTED] alex To unsubscribe, e-mail [EMAIL PROTECTED] alex Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php alex - 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 with LIMIT and including the total?
Hi, how to query a list of records limiting the score, but including the TOTAL of records satisfying the condition, all in one statement? i.e. SELECT title FROM news WHERE cond1 LIMIT 1, 10 plus SELECT count(*) from NEWS WHERE cond1 all in one. Thanks in advance Nico - 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
bin log question
using the old update logs I could look inside them and use the contents to help debug dynamic SQL statements. How do I do the same with the binary log? I have tried mysqlbinlog hostname.001 but get ERROR: Could not read entry at offset 5 : Error in log format or read error The documentation says.. mysqlbinlog hostname-bin.[0-9]* | mysql however I do not want to pipe the output to mysql, just to STDOUT so that I can examine it. Is there any way of doing this? Other things I have tried [mysql@data]$ mysqlbinlog --help Usage: mysqlbinlog [options] log-files Options: -s,--short-form just show the queries, no extra info -o,--offset=N skip the first N entries -h,--host=serverget the binlog from server -P,--port=port use port to connect to the remove server -u,--user=username connect to the remove server as username -p,--password=password use this password to connect to remote server -j,--position=N start reading the binlog at postion N -?,--help this message [mysql@data]$ mysqlbinlog -s host-bin.001 ERROR: Could not read entry at offset 5 : Error in log format or read error [mysql@data]$ mysqlbinlog -s -j 6 host-bin.001 ERROR: failed on my_fseek() [mysql@data]$ mysqlbinlog -j 10 host-bin.001 ERROR: failed on my_fseek() [mysql@data]$ mysqlbinlog --offset=100 host-bin.001 ERROR: Could not read entry at offset 5 : Error in log format or read error [mysql@data]$ mysqlbinlog --offset=100 -j 110 host-bin.001 ERROR: failed on my_fseek() Thanks in advance, Robin Keech www.dialogue.co.uk Dialogue Communications (Estd. 1994) is a world leader in the development and implementation of mobile data and internet messaging solutions. The company's technology bridges the gap between the fixed and mobile worlds - delivering carrier class platforms to both service providers and enterprise customers around the globe. - 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 to make symbolic link under windows
Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If so, how? Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - 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 make symbolic link under windows
Unfortunately, symbolic links are a Unix / Linux feature, not Windows. Regards, Sebastiaan J.A. Kamp Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If so, how? Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - 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: selecting with LIMIT and including the total?
How about something like this: SELECT title FROM news WHERE cond1 LIMIT 1, 10 union SELECT count(title) from NEWS WHERE cond1 LIMIT 1, 10 -Original Message- From: nsabbi [mailto:[EMAIL PROTECTED]] Sent: Tue, 03 July 2001 09:48 To: [EMAIL PROTECTED] Subject: selecting with LIMIT and including the total? Hi, how to query a list of records limiting the score, but including the TOTAL of records satisfying the condition, all in one statement? i.e. SELECT title FROM news WHERE cond1 LIMIT 1, 10 plus SELECT count(*) from NEWS WHERE cond1 all in one. Thanks in advance Nico - 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
ERROR :Can't find file: './mysql/host.frm' (errno: 13)
I have installed mysql with rpm method (from cd ditribuition). But when i start the demon with the 'safe_mysql ' command, the demon stop immediatelly and i found the message in Subject in the /var/log/mysql.log file. The demon starts normally with the command 'safe_mysql --skip-grant-tables ' The script mysql_install_db isn't in error. I have just read the manual (install and post installation section) but ... I have made all that you have indicated in :-((( Can you help me? Thanks anyway. How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.36 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for redhat- linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 11 min 18 sec Threads: 1 Questions: 11 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 0 Queries per second avg: 0.016 Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.4.2-2 #1 Sun Apr 8 19:37:14 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin /cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 mag 7 21:38 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x2 root root 5578134 apr 6 21:30 /lib/libc- 2.2.2.so -rw-r--r--1 root root 26350254 apr 6 21:27 /usr/lib/libc.a -rw-r--r--1 root root 178 apr 6 21:27 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec- prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc -- datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib -- libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com - -mandir=/usr/share/man --infodir=/usr/share/info --without-debug -- without-readline --enable-shared --with-extra-charsets=complex --with- bench --localstatedir=/var/lib/mysql --with-unix-socket- path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra- charsets=all --with-berkeley-db - 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: Mac OS X MySQL GUI
Hannes Niedner writes: Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or rather Darwin)? Hannes I wish I had one, as I would have tried it. FLTK libs work on Mac, so it is quite doable. If you want to do it and please go ahead. If you encounter problems, let me know. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
MySQL HELP -- Unable to start Win2k service
Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael
Re: How to make symbolic link under windows
At 17:16 03/07/2001 +0800, tpchan wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and NT/Win2k. 3- mysqld-max-nt.exe the optimized version for NT/Win2k with support for named pipes. I recommend to you the 3 option. The Max stuff besides the support of symbolic links has the support of transactional tables InnoDB and BDB. Below the instructions how to use the symbolic link. Notice if you don't want the support of InnoDB and BDB tables un comment the variables skip-innodb and skip-bdb. Otherwise read the item 8.7.2 InnoDB startup options of the \mysql\docs\Manual.html. 1- Create the configuration file c:\my.cnf or \windir\my.ini.file. 2- Edit the configuration file: [mysqld] basedir=c:/mysql datadir=c:/mysql/data use-symbolic-links #skip-innodb #skip-bdb Notice that in the sample above, you have the grant tables on c:\mysql\data. If you want to have all the databases on d:\ecom, so you don't need to use symbolic link, you only need to move the all c:\mysql\data\mysql directory to d:\ecom\mysql and modify the variable datadir=d:/ecom. Now assuming that you want a database called mylink on d:\ecom. First create on c:\mysql\data directory a file called mylink.sym. Edit this file with the text: d:\ecom\mylink Create the directory d:\ecom\mylink Regards, Miguel Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If so, how? Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
Re: MySQL HELP -- Unable to start Win2k service
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the possible issues before to run the service. Regards, Miguel Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
error in selecting database.
Hi, I try to connect to a database with the following code. #define host 192.168.105.105 #include mysql.h MYSQL mysql; int exiterr(int i) { fprintf(stderr,%s\n,mysql_error(mysql) ); exit(i); } int main(void) { /* . */ if (!(mysql_connect(mysql,host,usr1,abc123)) ) exiterr(1); fprintf(stderr,Connected to database!\n); if (mysql_select_db(mysql,test)) exiterr(2); fprintf(stderr,Connected to test database!\n); /* . */ } When trying from the same machine, everything works fine, but if I try to access the same database from some other machine(not having mysql), it connects to the database, but fails to find the database file. The output of the program is as follows: $ ./db Connected to database! Unknown database 'test' $ What is happening? Is it because the client machine does not have mysql installed? I compiled the program and ftp ed the binary to the other machine. What should I do now? Please help me. Thanks, Praveen.
Re: error in selecting database.
Hi, it's possible that db 'test' doesn't exists mysql should run, 'coz mysql_connect was successfull. check if you are connecting to right host and permissions from mysql (if usr1 has access to db test and have logon from another host other than localhost) but if mysql_error return this error -- db test doesn't exists Michal Dvoracek [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
FINALLY, got a core!
Hi, Well, 45 days later after doing everything I could to get it to dump a core (3.22.32), it did! So, the results are : Program terminated with signal 11, Segmentation fault. #0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638 1638*j= *join-best_positions[tablenr].table; (gdb) bt #0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638 #1 0x808aa10 in make_join_statistics (join=0xc244808, tables=0x0, conds=0x0, keyuse_array=0xc244d50) at sql_select.cc:899 #2 0x8089311 in mysql_select (thd=0x8932000, tables=0x895c0c8, fields=@0x893237c, conds=0x0, order=0x895c150, group=0x0, having=0x0, proc_param=0x0, select_options=5120, result=0x895c180) at sql_select.cc:337 #3 0x8075954 in mysql_execute_command () at sql_parse.cc:687 #4 0x807723f in mysql_parse (thd=0x8932000, inBuf=0x895c010 SELECT * from Cache_0001 ORDER BY Entry_Number LIMIT 0,1, length=60) at sql_parse.cc:1377 #5 0x8075064 in do_command (thd=0x8932000) at sql_parse.cc:428 #6 0x8074b0b in handle_one_connection (arg=0x8932000) at sql_parse.cc:292 #7 0xc203868 in _thread_kern_start () (gdb) Ok! So, where do I go from here?! Thanks, Tuc/TTSG Internet Services, 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
Re: Initial setup in Linux RH7.1
Yi-chen Lan [EMAIL PROTECTED] writes: When I try to run mysql, the system give an erroe message Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I checked the above directory and found out there is no such file 'mysql.sock'. Please help me to solve this problem. How did you try to start it? The correct way is service mysql start. -- Trond Eivind Glomsrød Red Hat, 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
Re: Problems installing Msql-Mysql-modules
You are missing libz. Vien Huynhle wrote: href=file://C:\Program Files\Common Files\Microsoft Shared\Stationery\ This is what I have done [root@MySQL Msql-Mysql-modules-1.2216]# perl Makefile.PL Which drivers do you want to install? 1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] q^H1 Checking if your kit is complete... Looks good [root@MySQL Msql-Mysql-modules-1.2216]# perl Makefile.PL Which drivers do you want to install? 1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] 1 Do you want to install the MysqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [n] Where is your MySQL installed? Please tell me the directory that contains the subdir 'include'. [/usr/local] Which database should I use for testing the MySQL drivers? [test] On which host is database test running (hostname, ip address or host:port) [localhost] 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 Note (probably harmless): No library found for -lgz Using DBI 1.18 installed in /usr/lib/perl5/site_perl/mips-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [root@MySQL Msql-Mysql-modules-1.2216]# 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 -I./blib/arch -I./blib/lib -I/usr/lib/perl5/mips-linux/5.00404 \ -I/usr/lib/perl5 -Ilib -MExtUtils::PerlPP \ -e ppp dbd/dbimon.in dbimon lib/DBD/mysql/Install/Config.pm PAGER=cat /usr/bin/perldoc mysql/lib/DBD/mysql.pm README make[1]: Entering directory `/home/MYSQL/Msql-Mysql-modules-1.2216/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 cc -c -I/usr/lib/perl5/site_perl/mips-linux/auto/DBI -I/usr/local/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/mips-linux/auto/DBI -I/usr/lib/perl5/mips-linux/5.00404 -Dbool=char -DHAS_BOOL -I/usr/local/include -O2-DVERSION=\2.0416\ -DXS_VERSION=\2.0416\ -fpic -I/usr/lib/perl5/mips-linux/5.00404/CORE -DDBD_MYSQL dbdimp.c dbdimp.c: In function `MysqlReconnect': dbdimp.c:2157: warning: assignment from incompatible pointer type /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/lib/perl5/site_perl/mips-linux/auto/DBI/Driver.xst mysql.xsi /usr/bin/perl -I/usr/lib/perl5/mips-linux/5.00404 -I/usr/lib/perl5 /usr/lib/perl5/ExtUtils/xsubpp -typemap /usr/lib/perl5/ExtUtils/typemap mysql.xs mysql.tc mv mysql.tc mysql.c Warning: duplicate function definition 'rows' detected in mysql.xs, line 381 cc -c -I/usr/lib/perl5/site_perl/mips-linux/auto/DBI -I/usr/local/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/mips-linux/auto/DBI -I/usr/lib/perl5/mips-linux/5.00404 -Dbool=char -DHAS_BOOL -I/usr/local/include -O2-DVERSION=\2.0416\ -DXS_VERSION=\2.0416\ -fpic -I/usr/lib/perl5/mips-linux/5.00404/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH=/usr/local/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/mipsel-linux/2.7.2 cc -o .././blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/lib/mysql-L/usr/local/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/gcc-lib/mipsel-linux/2.7.2 -lgcc ld: cannot open -lz: No such file or directory make[1]: *** [.././blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/home/MYSQL/Msql-Mysql-modules-1.2216/mysql' make: *** [subdirs] Error 2 [root@MySQL Msql-Mysql-modules-1.2216]# make test make[1]: Entering directory `/home/MYSQL/Msql-Mysql-modules-1.2216/mysql' LD_RUN_PATH=/usr/local/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/mipsel-linux/2.7.2 cc -o .././blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/lib/mysql-L/usr/local/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/gcc-lib/mipsel-linux/2.7.2 -lgcc ld: cannot open -lz: No such file or directory make[1]: *** [.././blib/arch/auto/DBD/mysql/mysql.so] Error 1
Re: problems with float calculations?
Thomas J Keller wrote: OK. Radius contains the radius, in miles, from the center of the Zipcode area. In the following query, the latitudes and longitudes have been calculated to yield a 20 X 20 mile square centered on the base Zipcode (in this case, 68504). +---+-+--+---+ | zip | city| latitude | longitude | +---+-+--+---+ | 68462 | WAVERLY | 40.9139 | 96.5270 | | 68504 | LINCOLN | 40.8391 | 96.6565 | +---+-+--+---+ 2 rows in set (0.09 sec) DEBUG: query = SELECT * FROM zipcodes WHERE (latitude BETWEEN '40.694382199711' AND '40.983817800289') AND (longitude BETWEEN '96.547008929014' AND '96.765991070986') ORDER BY state, county, city, zip ASC 68504: Radius: 10 Distance 0 miles Waverly (68462) should have been selected in this query, but is not. As you No, WAVERLY's longitude is not between 96.547008929014 and 96.765991070986. will see by the following query (with radius set to 12 miles) Wavery is less than 9 miles from 68504. DEBUG: query = SELECT * FROM zipcodes WHERE (latitude BETWEEN '40.665438639653' AND '41.012761360347') AND (longitude BETWEEN '96.525110714817' AND '96.787889285183') ORDER BY state, county, city, zip ASC 68462: Radius: 12 Distance 8.5137543957707 miles 68504: Radius: 12 Distance 0 miles NOTE: I have also tried : DEBUG: query = SELECT * FROM zipcodes WHERE (latitude 40.665438639653 AND latitude 41.012761360347) AND (longitude 96.525110714817 AND longitude 96.787889285183) ORDER BY state, county, city, zip ASC With the same results. NOTE: on advice from somone in #mysql, I tried altering the columns from float to decimal. Made no difference at all. - 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 -- Gerald L. Clark [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: restoring a database on nt4
Whith Unix it is: mysql database logfile. Pete Kuczynski wrote: I can't seem to find any documentation on how to set this up an a windowz box. Can anyone help? Pete Gerald Clark wrote: Run your transaction log against the restored database. Pete Kuczynski wrote: Hoping someone can point me in the right direction. I have Nusphere Mysql database in production [using mysql/PHP/apache, no perl]. The database has 1 table, 20 columns, with 3500 entries and growing. I am backing up the database to tape 2 times a day. At noon and at 5pm, both are full backups. Let's say the disk should crask at 4pm, one hour prior to the next full backup. Now I restore the database from the noon backup, how do I restore 4 hours worth of transactions, so the database is up to date? Again, the Mysql database is on a NT4.0 server. Thanks in advance for any insight! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - 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 attachment.txt Content-Type: text/plain -- Gerald L. Clark [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 -- Gerald L. Clark [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
count() problem - URGENT !!
I have 2 tables: 1) t1 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t1; +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | +++ 4 rows in set (0.20 sec) 2) t2 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t2; ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1 | 2001-07-03 15:03:34 | | 2 | 1 | 2001-07-03 15:03:34 | | 3 | 1 | 2001-07-03 15:03:34 | | 4 | 2 | 2001-07-03 15:03:34 | | 5 | 3 | 2001-07-03 15:03:34 | | 6 | 3 | 2001-07-03 15:03:34 | ++---+-+ 6 rows in set (0.31 sec) I make the folowing query: select t1.number,count(t2.id_t1) from t1 left join t2 on t1.id=t2.id_t1 where t2.t='01-07-03 15:03:34' group by t1.number; I see: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | ++-+ What happend with column number and value four What is correct query to have result below, but where clausule must stay: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | | four| 0 | ++-+ PLEASE HELP. Regards: Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
INSERT problem
Hi all, I'm new to the whole PHP and MySql stuff and I hopeful that I can get a push in the right direction for what I'm sure is a very sinple problem. I have succesfully created a databse using telnet and added data to it also using telnet. I have also succesfully got the data to display on a page using PHP. My problem is adding data from the PHP page. My insert code is: $query = INSERT INTO guests ; $query .= (guest_id, guest_name, ; $query .= guest_email, guest_time, guest_message) ; $query .= values(,'$name','$email',NULL,'$message'); mysql_pconnect(localhost,blahblah,blahblah) or die(Unable to connect to SQL server); mysql_select_db(blah) or die(Unable to select database); mysql_query($query) or die(Insert Failed!); When I add data via the form, npthing seems to happen, it does not add the data to the databse, nor does it pop any errors. Any help would be appreciated...tia
Re: Create Login?
I need to create a new login for a already created database. I have tryed to from the command prompt of my windows 2000 adv server box. c:\mysql\binCreate User mark c:\mysql\bin this is the directory Create User mark There is no executable named Create. You have to start mysql first, then issue your commands within that program. - 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: ERROR :Can't find file: './mysql/host.frm' (errno: 13)
The error indicated means that the table host is missing. I would reinstall the package. If it doesn't work, I would download the latest package from mysql.com and install that (it is the recommended path, anyway) - it works fine. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Looking for list of ckocking charecters
I'm trying to insert varchars into a field with a Insert and update query. Does anyone have a complete list of the charecters that need to be escaped/dealt with in order to get problem free queries on the INsert and Updates. ex. ' needs to be replaced with '' thanks in advance dan Daniel D. McCutcheon Software Engineer InnoSoft Inc. 1 Market Place, Suite 22 Essex Jct. VT 05452 (802) 878-9066 x 110 - 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
FW: java connection
The driver name is: //be careful, case sensitive org.gjt.mm.mysql.Driver the url is jdbc:mysql://localhost/mydb of course replace mydb with your database name. There are 2 supported JDBC drivers for MySQL (the mm driver and the Reisin JDBC driver). You can find a copy of the mm driver at http://mmmysql.sourceforge.net/ or http://www.mysql.com/Downloads/Contrib/ and the Reisin driver at http://www.caucho.com/projects/jdbc-mysql/index.xtp For documentation consult any JDBC documentation and the driver's own documentation for MySQL-specific features Regards - 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[2]: Reporting Tool : Linux?
It's not just the calculation of the reports, but also the presentation. PHP is certainly capable of producing nice reports. But tools like Crystal Reports have their place. If you can find me another tool that can easily produce publication quality reports (headers, footers, proper page breaks and page numbering etc) I'd like to hear about it! Regards, Gary Huntress Code 4113 Naval Undersea Warfare Center Newport, RI 02841 1-800-669-6892 x28990 -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 10:09 AM To: Mazur Cc: [EMAIL PROTECTED] Subject: Re[2]: Reporting Tool : Linux? I just figured I can't be the first guy on the block that wants to design reports out of MySQL without using Windows. I mean, I recall MySQL boasting that NASA uses MySQL...what the heck do they use for reporting? Of course, I suppose if you have MySQL on an NT machine, you can add Crystal Reports. I would never get the idea to use a tool for that. Why? First, you have to master the tool. Next, if you do, you can only do what the tool allows you to do. It is much easier to do your own reporting with php (or Perl, if you prefer that). It's a snap, and you can do anything you like. I guess, that's the way all the experts do it. Read the entertaining and instructive article at http://www.mysql.com/articles/wizard/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
please help: empty field on table merge
I am currently experiencing a strange problem that I have not seen prior today. It appeared on an existing database without any changes in the DB version or the system (win2000). The problems describes as 'loss of the content of a column when selecting from two tables'. eg: I have two tables activation and theaters where 'theact' refers to 'actval'. +--++---+ activationtheaters +--++---+ actid actval theid theact thenam theadr thezip 1 0 1 1 aaa aas 2 1 2 0 bbb bbsdsdf +--+ 3 1 ccc dsdf sdf +---+ The problem now is that as soon I do a joint query such as: SELECT * FROM theaters,activation WHERE theact=actval I am spontaneously loosing the content of one of the theater columns. +--+ actid actval theid theact thenam theadr thezip +--+ 21 1 1 aaa 10 2 0 bbb sdf 21 1 1 ccc sdf +--+ Selecting one of the tables individually works fine, but as soon as they are merged, one of the columns completely looses its content. I have never seen this before an I cannot imagine where the problem comes from. It appreas as well on PHP/Apache as on the mysql shell with raw sql statements. The column that looses it's content is alway the same one in the same query, but it might show up fine in a query that joins the column in question with a third table. I managed to get rid of one of the cases by setting the flag for the buggy column to 'NOT NULL' and then back to 'NULL' and tought the NULL setting could have something to do with it. But I keep spotting the problem now and I have to triple-check all my queries again... Has anyone seen somthing similar? I'm using 3.23.29a-gamma on win2000 any help or pointer is appreciated. patrick./ - 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
Possible bug in InnoDB
I have the same problem with Mysql-3.23.39 compiled by myself running in Linux box. However the problem goes away if I alter table type from InnoDB to MyISAM. Therefore this problem is related with InnoDB. Here is the query which generates ERROR 1028: Sort aborted. SELECT service.sowid,servdate,removedate FROM service,sowherd WHERE service.sowid=sowherd.sowid AND servdate removedate ORDER BY servdate; I was NOT able to produce a small test example although I tried my best. If someone is interested in solving the problem, I can give you the dataset. On Tue, 3 Jul 2001, Sinisa Milivojevic wrote: Cal Evans writes: MySQL Error: ERROR 1028: Sort aborted Anybody know what this means? Ok, I can figure out what it MEANS, I'm getting it on a rather complicated select statement with an order by clause. Does it mean something specific like 'you need a better index' or is it just exactly what it means? Cal http://www.calevans.com Hi! This is a rare error and usually caused by no space in TMPDIR or by bad disk or RAM. - 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
Problem with count() - URGENT
I have 2 tables: 1) t1 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t1; +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | +++ 4 rows in set (0.20 sec) 2) t2 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t2; ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1 | 2001-07-03 15:03:34 | | 2 | 1 | 2001-07-03 15:03:34 | | 3 | 1 | 2001-07-03 15:03:34 | | 4 | 2 | 2001-07-03 15:03:34 | | 5 | 3 | 2001-07-03 15:03:34 | | 6 | 3 | 2001-07-03 15:03:34 | ++---+-+ 6 rows in set (0.31 sec) I make the folowing query: select t1.number,count(t2.id_t1) from t1 left join t2 on t1.id=t2.id_t1 where t2.t='01-07-03 15:03:34' group by t1.number; I see: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | ++-+ What happend with column number and value four What is correct query to have result below, but where clausule must stay: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | | four| 0 | ++-+ PLEASE HELP. Regards: Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
db connection.
Hi, What exactly are the steps to connect a machine to db in another machine(mysql configurations, perl-cgi as well as C APIs)? Are there any prerequisites? Is it possible to connect from a machine which does not have mysql installed in it? Kindly answer. Thanks, Rohan M __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update table using regular expressions MySQL
I want to update 160 records in a table. The field contains a variable value and a constant prefex like 'constant: unique value for this record' Is there such an UPDATE statement that would update this field into 'unique value for this record' They way I would do it otherwise is using Perls regular expressions like (this is rather pseudocode just to make the point) $foo = 'constant: unique value for this record'; $foo =~ s/constant:(.+)//sg; $bar = $1; #(and hopefully $1 would hold 'unique value for this record') UPDATE my_table SET field = $bar WHERE field = $foo; Any ideas? Help greatly appreciated. Hannes - 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 HELP -- Unable to start Win2k service
I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Looking for list of ckocking charecters
I'm trying to insert varchars into a field with a Insert and update query. Does anyone have a complete list of the charecters that need to be escaped/dealt with in order to get problem free queries on the INsert and Updates. ex. ' needs to be replaced with '' I work with php. They have a funcion addslashes. This function takes care of all those, so I don't have to. The function definition says: Returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote ('), double quote (), backslash (\) and NUL (the null byte). -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Urgent:MySql problem
Was this an install from the RedHat CD? If so then remove and reload with the current stable version from MySQL's site. This has happend to alot of folk hereg Cheers -Original Message- FROM: Antonio Carlos Venancio Junior TO: sachin CC: [EMAIL PROTECTED] DATE: Tue 7/3/01 10:26 SUBJECT: RE: Urgent:MySql problem Sachin, MySQL is not running. Check the logfiles to see whats wrong ... ;) On 01-Jun-2006 sachin wrote: Hello, I am working on RH Linux 7.0 MySql is not working at all. My MySql files are under /usr/bin. It gives the following error on running any mysql command Can't connect to localMySql server through socket 'var/lib/mysql/mysql.sock'(111) Please Help me. Thank You Sachin Ate´ Antonio [ [EMAIL PROTECTED] | [EMAIL PROTECTED] | [EMAIL PROTECTED] ] [ http://floripa.zoing.net | http://www.zoing.net | http://www.showZ.com.br ] [ ICQ# 9253680 | Floripa | MySQL | PHP | FreeBSD - The Power to Serve ] Elevators smell different to midgets - 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: Update table using regular expressions MySQL
Thanks Karel, This worked almost out of the box, just needed to find out that 'len+1' has to be replaced with the actual number and is not automatically set (like len = length('CONSTANT%'). But the manual also explains this very well, I just didn't think of substring. Hannes On 7/3/01 9:13 AM, karel pitra [EMAIL PROTECTED] wrote: len = strlen(CONSTANT); UPDATE my_table SET field=substring(field,len+1) WHERE field LIKE 'CONSTANT%' On Tue 3. July 2001 17:49, you wrote: I want to update 160 records in a table. The field contains a variable value and a constant prefex like 'constant: unique value for this record' Is there such an UPDATE statement that would update this field into 'unique value for this record' They way I would do it otherwise is using Perls regular expressions like (this is rather pseudocode just to make the point) $foo = 'constant: unique value for this record'; $foo =~ s/constant:(.+)//sg; $bar = $1; #(and hopefully $1 would hold 'unique value for this record') UPDATE my_table SET field = $bar WHERE field = $foo; Any ideas? Help greatly appreciated. Hannes - 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
Question
Hello, The product is very helpful and works fine in general. I tried to use create table and edit tables in the Commands, Tables menu but there is no response. Are these supposed to work in this version? If yes how I should set it up. Thanks, Rafael.
Funny :-)
Why do I keep getting Unsubscribe notices? Am I that anoying LOL. Cheers M ;-) Got MySQL - 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: INSERT problem
I have succesfully created a databse using telnet and added data to it also using telnet. Why not do it with myPhpAdmin? Google shows you the address. Very convienient. It pays at least in the long run - you won't bother with telnet to maintain your db. I have also succesfully got the data to display on a page using PHP. Good. My problem is adding data from the PHP page. When I add data via the form, npthing seems to happen, it does not add the data to the databse, nor does it pop any errors. I didn't bother to understand your code and look for an error source. You could look for an error message of mysql. Ypur code ahows that the query has been issued successfully, hence no death. But the result of the query was not what you expected, hence there must be an error. Here is how I do it. Again, very convenient. You put out ten times as many queries this way. Not only that you are much more productive, it is much more fun this way, too. Use db_mysql.inc from PHPLIB (again: Google shows where to get it). Then write: include_once db_mysql.inc; //include library $datum = date(Y-m-d); //get date $db = new DB_Sql; //let the lib connect etc. $q = INSERT INTO (guest_name, guest_email, guest_time, guest_message) VALUES ('$name','$email','$datum','$message'); //do it all in once - so you see what you do. //don't provide for id's - use an autoincrement field instead and //let mysql provide for numbering. //if you have a date field, provide for a date value. It is easy. //if you have NULL values, omit them. $db-query($q); //let the lib do the stuff if ($db-Error) echo $db-Error . '\nbr'; //lib knows Error and shows it I use an editor with shortcuts. I have shortcuts for all this stuff, so I don't have to push the keys too often (RSI). You could automate this further. Include the above error statement into the query function in the library. If you work on production systems, qualify this error message by the existence of a cookie value which shows that you are testing. Hence other users won't see anything, but you do automatically. You can use the lib out of the box. Just provide for the connection data, password etc. Make sure you put the location of the lib outside your home dir or protect it with an .htaccess file, as the password is in plain text in the local.inc file. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Error Codes
I am looking for a concise listing of all the error codes that MySQL might return after issuing a SQL statement. The manual and other books I've checked have descriptions of the errors, but don't seem to collect them all into one reference. Thanks, [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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: Question (fwd)
-- Forwarded Message -- Date: Tuesday, July 03, 2001 1:03 PM -0400 From: William M. Quarles [EMAIL PROTECTED] To: Rafael Marcus [EMAIL PROTECTED] Subject: Re: Question Yes, absolutely, those are fundamental commands. You probably have not set up your access privileges properly. If you go to http://www.devshed.com/, you can read some tutrials that might help you better understand MySQL and user administration. Then read the appropriate sections in the MySQL documentation to fill in some of the holes. If you still need more assistance, O'Reilly publishing has a good MySQL book out. --On Tuesday, July 03, 2001 12:32 PM -0400 Rafael Marcus [EMAIL PROTECTED] wrote: Hello, The product is very helpful and works fine in general. I tried to use create table and edit tables in the Commands, Tables menu but there is no response. Are these supposed to work in this version? If yes how I should set it up. Thanks, Rafael. -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. -- End Forwarded Message -- -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - 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: java connection
Must I install additionally anything to use this driver org.gjt.mm.mysql.Driver ? I already have installed the JDK and MySQL. My system is Win98, and I'm making my first apps in Java and MySQL in my home PC. If the database name is lalibertad: Then the url is: jdbc:mysql://localhost/lalibertad Right? What about user and password? Where must I create the user? In the ODBC control panel of Win98? Or in the MySQL manager? How? What about the port? Must I specify them in the URL? Please explain me. Is there another mysql manual (not this from mysql.com) to learn from beginning step by step? Regards, Daniel Aderhold Thanks to all for your help. - Original Message - From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 9:37 PM Subject: Re: java connection // Copyright (c) 2000 Appiant Technologies import java.sql.*; public class ConnectMysql { public static void main (String[] args) { Connection conn = null; String url = jdbc:mysql://localhost/db_name; String url = jdbc:mysql://localhost/pip; try { Class.forName (org.gjt.mm.mysql.Driver).newInstance (); conn = DriverManager.getConnection (url, root, toor); System.out.println (Connected); String sql = select * from Folders where userName = 'Sio'; Statement sta = conn.createStatement(); ResultSet rs = sta.executeQuery(sql); while( rs.next() ){ System.out.println( rs.getString(1)+ + rs.getString(2)+ + rs.getString(3)); } } catch (Exception e) { System.err.println (Cannot connect to server); System.err.println (e); } finally { try { if (conn != null) { conn.close (); System.out.println (Disconnected); } } catch (Exception e) { /* ignore close errors */ } } } }; From: Daniel Aderhold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: java connection Date: Mon, 2 Jul 2001 18:46:08 -0500 Hi I'm new to MySQL. Please can anyone give me the connection sentences in Java. Exactly: How to charge the driver: Class.forName( I use windows98. And want to make experimental local connections. Regards, Daniel Aderhold _ 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: Funny :-)
LOL, No you are not (i guess). It's just this mailing list software that stupid :) So ignore it. Afterall, even though you are Annoying, that's this mailing list software making you annoying , isn't it :) -- sherzod_ruzmetov (sherzodR) email: [EMAIL PROTECTED] So what if I have a fertile brain? Fertilizer happens. -- Larry Wall in [EMAIL PROTECTED] Sent on Jul 3 by [EMAIL PROTECTED] to [EMAIL PROTECTED] massey massey Why do I keep getting Unsubscribe notices? Am I that anoying LOL. massey massey massey Cheers massey massey M ;-) massey massey Got MySQL massey massey massey - massey Before posting, please check: masseyhttp://www.mysql.com/manual.php (the manual) masseyhttp://lists.mysql.com/ (the list archive) massey massey To request this thread, e-mail [EMAIL PROTECTED] massey To unsubscribe, e-mail [EMAIL PROTECTED] massey Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php massey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation Problems on Solaris 8 box
I have been trying to install Mysql on a Solaris 8 box. Would anyone know what I need to install prier to installing Mysql??? The Solaris box is a fresh install. Thanks in advance, [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: Error Codes
Check the source for mysqld_error.h Fletcher Sandbeck wrote: I am looking for a concise listing of all the error codes that MySQL might return after issuing a SQL statement. The manual and other books I've checked have descriptions of the errors, but don't seem to collect them all into one reference. Thanks, [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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 -- Gerald L. Clark [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
MySQL on FreeBSD 4.1 OS
Hello all, We are looking at setting up on dedicated server with the FreeBSD 4.1 OS and was wonder how well MySQL has worked on this O/S. We would like to compile it with Innobase if possible. Appreciate any feedback, recommendations, pro/cons... etc.. THX Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL HELP -- Unable to start Win2k service
Hi guys, I have done the isamchk and nothing came up from there and the error log didn't reflect much to indicate any problem with the grant table. Where should I look into next ?? Thanks. Regrads, Michael - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Michael Tam [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 9:10 AM Subject: Re: MySQL HELP -- Unable to start Win2k service I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
fake ubsubs
I'v been getting them too. [EMAIL PROTECTED] wrote: Why do I keep getting Unsubscribe notices? Am I that anoying LOL. Cheers M ;-) Got MySQL - 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 -- Gerald L. Clark [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: SELECT form element with PHP/MySQL
Thanks to Gerald, Werner, Gerlinde and Josh for help with the SELECT form element. Gerald's was the simplest, most pragmatic solution, but I ended up figuring out something that was a bit more like Gerlinde and Josh suggested, but saving on a real 'if-then-else' loop and doing it all in one line: while ($row = mysql_fetch_object ($list)) { printf(OPTION VALUE=%s %s%s/OPTION\n, $row-id, $row-id == $formValues[listid] ? SELECTED : , $row-shortname); } So using the ternary operator I do the 'if-then' for each row - if the id for that row = the id stored in $formValues[listid], then the word 'SELECTED' gets printed on the line. If not then nothing is printed in that place - so if the 'listid' were '2', we'd get something like: OPTION VALUE=1 red/OPTION OPTION VALUE=2 SELECTEDwhite/OPTION OPTION VALUE=3 blue/OPTION I can see that this technique could be applied to check boxes and radio buttons as well. I'm liking that ternary operator! Nelson Check out the tutorial at the following link: http://www.thickbook.com/extra/php_loopoption.phtml For creating a new record, no problem - but if the form is displaying data from an existing record, I want the pulldown list to indicate the existing value for 'type'. I've done a brute-force 'if-then' version of this for a two value radio button, but doing a list like that could get ugly. I'm hoping that someone has a more elegant solution. Here's the code I'm using - the pulldown displays nicely. $list = mysql_query(SELECT id, type FROM contact_type, $link); printf(TRTD CLASS=\FormItem\Contact Type: /TD); printf(TD CLASS=\FormInput\SELECT NAME=toolnum); while ($row = mysql_fetch_object ($list)) { printf(OPTION VALUE=%s%s/OPTION, $row-id, $row-type); } printf(/SELECT%s/TD/TR\n, ($formValues) ? $formValues[id] : ); -- - 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: FINALLY, got a core!
On Tuesday 03 July 2001 06:35, Tuc wrote: Hi, Well, 45 days later after doing everything I could to get it to dump a core (3.22.32), it did! So, the results are : Program terminated with signal 11, Segmentation fault. #0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638 1638*j= *join-best_positions[tablenr].table; (gdb) bt #0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638 #1 0x808aa10 in make_join_statistics (join=0xc244808, tables=0x0, conds=0x0, keyuse_array=0xc244d50) at sql_select.cc:899 #2 0x8089311 in mysql_select (thd=0x8932000, tables=0x895c0c8, fields=@0x893237c, conds=0x0, order=0x895c150, group=0x0, having=0x0, proc_param=0x0, select_options=5120, result=0x895c180) at sql_select.cc:337 #3 0x8075954 in mysql_execute_command () at sql_parse.cc:687 #4 0x807723f in mysql_parse (thd=0x8932000, inBuf=0x895c010 SELECT * from Cache_0001 ORDER BY Entry_Number LIMIT 0,1, length=60) at sql_parse.cc:1377 #5 0x8075064 in do_command (thd=0x8932000) at sql_parse.cc:428 #6 0x8074b0b in handle_one_connection (arg=0x8932000) at sql_parse.cc:292 #7 0xc203868 in _thread_kern_start () (gdb) Ok! So, where do I go from here?! Upgrade to 3.23.39 first and see if the bug is still present. If yes, submit a full test case to [EMAIL PROTECTED] -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
links
Hey Everybody, I have an online database where I use a CGI script that uses the DBI to return values from Mysql. How do I return a LINK? For example, if I have a database for hockey players, and I return the name Wayne Gretzky. Is there a way to make that a link that will go to say, NHL.com ?? Where would I insert the html tag a href=http://www.nhl.com;Wayne Gretzky/a ?? Many thanks. simon = # Simon K. Chan [EMAIL PROTECTED] Great spirits have always encountered violent opposition from mediocre minds. -Albert Einstein __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling mysql
I am having trouble compiling mysql on and HP 9000 running HP-UX 10.20. I installed gcc 2.95.3 binaries and followed the instructions in the documentation page concerning the problem with MIT-pthreads (CFLAGS=-DHPUX -I/opt/dce/include CXXFLAGS=-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti CXX=gcc ./configure --with-pthread --with-named-thread-libs='-ldce' --prefix=/usr/local/mysql --disable-shared) but the make still stopped with this error. Making all in strings make[2]: Entering directory `/home/rac/mysql-3.23.39/strings' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -D__STDC_EXT__ -O3 -DDBUG_OFF -DHAVE_BROKEN_SNPRINTF -DSIGNALS_DONT_BREAK_READ -c strxmov.c In file included from strxmov.c:16: ../include/global.h:94: pthread.h: No such file or directory make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/home/rac/mysql-3.23.39/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/rac/mysql-3.23.39' make: *** [all-recursive-am] Error 2 There is also this warning in the docs: If you are compiling gcc 2.95 yourself, you should NOT link it with the DCE libraries (libdce.a or libcma.a) if you want to compile MySQL with MIT-pthreads. If you mix the DCE and MIT-pthreads packages you will get a mysqld to which you cannot connect. Remove the DCE libraries while you compile gcc 2.95! I installed gcc from a depot file does how do I know if gcc was complied in this manner? Any assistance at all would be greatly appreciated. David Hudgins Code 935 System Administrator NASA Goddard Space flight center Code 935 Bld 28 Rm 196a Greenbelt MD 20771 [EMAIL PROTECTED]
Re: Reporting Tool : Linux?
The ez way, use Mysqlfrom to access you database, run a query to extract the data you wisk, save it as html, looks very nice. http://www.anse.de/mysqlfront/download.php Regards, Pete Mazur wrote: :-) Ya, I was thinking I would try to stay away from formatting in HTML, and let the tool do it, quite like Crystal would (at least, I think it does...have only read books on it in Barnes Noble). But I could resort to using JSP's to build the reports. H, I will check Freshmeat too, though. I just figured I can't be the first guy on the block that wants to design reports out of MySQL without using Windows. I mean, I recall MySQL boasting that NASA uses MySQL...what the heck do they use for reporting? Of course, I suppose if you have MySQL on an NT machine, you can add Crystal Reports. Any additional dialog from anyone else (you too J.K. :-0 ) would be appreciated! Rob Mazur - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: Mazur [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 02, 2001 4:31 PM Subject: Re: Reporting Tool : Linux? Print to HTML. Pull up in browser. Print. But seriously, have you tried looking on freshmeat? j- k- On Monday 02 July 2001 14:32, Mazur wrote: OK, what are all you guys using for a reporting tool, with MySQL as a backend (where you don't need Windows)? I need a reporting tool to generate management reports/letters out of MySQL, which I will be using for a web-based application. I guess I am looking for something like Crystal Reports, but ported for Linux. I am suspecting I may be asking for too much at the moment. As far as I can see, I can not run Crystal on a Linux web server. So, what are you guys using to generate reports for the exec's such that you do not need a Windows machine in any part of the equation? Rob Mazur p.s. At the moment, I am thinking of using an MS Access link to MySQL to generate reports and mail merges, etc., but I hate to do that if I can help it.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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 -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - 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 HELP -- Unable to start Win2k service
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael
Re: Problem with count() - URGENT
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for four since there would be no condition to filter it out. You have placed the where clause on a t2 field however, and in the case of the extra empty row for the four value which would be added by the left join operation, it does NOT match the where clause (since it has no timestamp value), and therefore it is not included in the query. You need to change the where clause to return true for any rows that do not exist in t2 and which have no timestamp. If, instread you modify the where clause in your query to say: where t2.t='2001-07-03 15:03:43' OR t2.t IS NULL I believe you're query would work. At 04:49 PM 7/3/01 +0200, Ireneusz Piasecki wrote: I have 2 tables: 1) t1 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t1; +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | +++ 4 rows in set (0.20 sec) 2) t2 mysql describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql select * from t2; ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1 | 2001-07-03 15:03:34 | | 2 | 1 | 2001-07-03 15:03:34 | | 3 | 1 | 2001-07-03 15:03:34 | | 4 | 2 | 2001-07-03 15:03:34 | | 5 | 3 | 2001-07-03 15:03:34 | | 6 | 3 | 2001-07-03 15:03:34 | ++---+-+ 6 rows in set (0.31 sec) I make the folowing query: select t1.number,count(t2.id_t1) from t1 left join t2 on t1.id=t2.id_t1 where t2.t='01-07-03 15:03:34' group by t1.number; I see: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | ++-+ What happend with column number and value four What is correct query to have result below, but where clausule must stay: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | | four| 0 | ++-+ PLEASE HELP. Regards: Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [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: Possible bug in InnoDB
Hi! One more question: does the query work if you remove the ORDER BY? What does EXPLAIN say then? Regards, Heikki -Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, July 03, 2001 9:44 PM Subject: Re: Possible bug in InnoDB Hi! What are the table definitions like? How big tables? How many rows should be returned by the query? What does EXPLAIN SELECT ... say for InnoDB, respectively MyISAM tables? Does it work with smaller tables? What does EXPLAIN say for small tables? Do you have a lot of free space in your disk? Regards, Heikki Copied message: . I have the same problem with Mysql-3.23.39 compiled by myself running in Linux box. However the problem goes away if I alter table type from InnoDB to MyISAM. Therefore this problem is related withInnoDB. Here is the query which generates ERROR 1028: Sort aborted. SELECT service.sowid,servdate,removedate FROM service,sowherd WHERE service.sowid=sowherd.sowid AND servdate removedate ORDER BY servdate; I was NOT able to produce a small test example although I tried my best. If someone is interested in solving the problem, I can give you thedataset. On Tue, 3 Jul 2001, Sinisa Milivojevic wrote: Cal Evans writes: MySQL Error: ERROR 1028: Sort aborted Anybody know what this means? Ok, I can figure out what it MEANS, I'm getting it on a rather complicated select statement with an order by clause. Does it mean something specific like 'you need a better index' or is it just exactly what it means? Cal http://www.calevans.com Hi! This is a rare error and usually caused by no space in TMPDIR or by bad disk or RAM. - 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 on FreeBSD 4.1 OS
Hi Mike, We started with Fbsd 4.1 which seemed to run OK with MySQL, do NOT use 4.2 as it has threads bugs, but I would really recommend 4.3 has it has the bugs worked out, a great port of mysql (in /usr/ports/databases) and is faster. Ken - Original Message - From: MikemickaloBlezien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 1:48 PM Subject: MySQL on FreeBSD 4.1 OS Hello all, We are looking at setting up on dedicated server with the FreeBSD 4.1 OS and was wonder how well MySQL has worked on this O/S. We would like to compile it with Innobase if possible. Appreciate any feedback, recommendations, pro/cons... etc.. THX Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 HELP -- Unable to start Win2k service
Only time I had this error on a NT4 server was when I attempted to get logging to work and I made a mistake editing the mycnf and myini files. When I cycled the mysql service, it would no come back up. Removing the offending edit allowed it to start. Pete Michael Tam wrote: Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT query
List, Our site is running mysql server version 3.22.32 I'm a power user - not the DBA, so forgive my ignorance. Is it possible to corrupt data with a SELECT query? The connection is made via a shell script: mysql -h servername -u userid -ppassword database QUERY_INPUT SELECT c.id, s.id FROM customers c, simulations s WHERE c.name = 'Customer Name Here' AND s.cust_id = c.id AND s.name = 'Simulation Name Here' QUERY_INPUT During the period I was testing this script, our DBA indicated we lost some data. Is this just a coincidence? I can't see how a benign query could cause such a problem. Thanks. Craig Meyers Senior Engineer Invensys Dynamic Simulation - 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
bad date comparaison for dates like '00??-??-??'
Description: I have a table that stores only dates, no other fields. Whenever the date value is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE, DELETE or REPLACE can alter that row. I've tested it with other date as well, like '0001-04-12', the same problem appears. as far as i know, the limit is exactly 0099-12-31: 0099-12-31 : still bug 0100-01-01 : went fine How-To-Repeat: here is the table structure: CREATE TABLE daily_report_cut_off_date ( cut_off_date date DEFAULT '-00-00' NOT NULL, PRIMARY KEY (cut_off_date) ); and I run those queries: INSERT INTO daily_report_cut_off_date (cut_off_date) VALUES ('0001-06-01'); UPDATE daily_report_cut_off_date SET cut_off_date='2001-01-01' WHERE cut_off_date='0001-06-01'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 DELETE FROM daily_report_cut_off_date WHERE cut_off_date='0001-06-01'; Query OK, 0 rows affected (0.00 sec) the row is still there, untouched Fix: no workaround :( Submitter-Id: remi catherinot Originator:remi catherinot Organization: Webmotion Inc, MySQL support: none Synopsis: Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: System: Linux ramses.dev.lan 2.2.19pre13 #2 SMP Wed Apr 11 15:15:06 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jun 26 04:02 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 586720 Feb 8 1999 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 Jun 26 04:02 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 887712 Mar 25 17:35 /lib/libc-2.1.3.so -rw-r--r--1 root root 2089576 Mar 25 17:36 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 25 17:36 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Jun 26 04:40 /usr/lib/libc-client.a - c-client.a lrwxrwxrwx1 root root 19 Jun 26 04:40 /usr/lib/libc-client.so - libc-client.so.2000 -rw-r--r--1 root root 710412 Feb 28 13:43 /usr/lib/libc-client.so.2000 -rw-r--r--1 root root 665216 Apr 24 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all 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
MySQL Users in Hawaii?
Hello, My name is Kaj Arnö and I joined MySQL AB as VP Training on 1 June 2001 (see http://www.mysql.com/news/article-69.html). I'm a long time friend of Monty, since we went to school and university together, and I have followed his coding since 1978. After the upcoming O'Reilly Open Software Convention in San Diego (OSCON), I'm going to Hawaii with my family and would be eager to meet with any local MySQL users on Oahu, Maui or Big Island sometimes between July 27 and August 9. I'd love to hear more about how you use the MySQL DBMS and what we can do to make your life easier. If you give me and my family directions to where the surf is up, the volcanoes hot and the sushi fresh, I'd be even happier. Responses please to [EMAIL PROTECTED] Regards, Kaj -- Get Official MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Kaj S. Arnö [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, VP Training /_/ /_/\_, /___/\___\_\___/ Grankulla, Finland ___/ 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
Re: bad date comparaison for dates like '00??-??-??'
Remi Catherinot wrote: Description: I have a table that stores only dates, no other fields. Whenever the date value is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE, DELETE or REPLACE can alter that row. I've tested it with other date as well, like '0001-04-12', the same problem appears. as far as i know, the limit is exactly 0099-12-31: 0099-12-31 : still bug 0100-01-01 : went fine How-To-Repeat: here is the table structure: CREATE TABLE daily_report_cut_off_date ( cut_off_date date DEFAULT '-00-00' NOT NULL, PRIMARY KEY (cut_off_date) ); and I run those queries: INSERT INTO daily_report_cut_off_date (cut_off_date) VALUES ('0001-06-01'); UPDATE daily_report_cut_off_date SET cut_off_date='2001-01-01' WHERE cut_off_date='0001-06-01'; should use where cut_off_date like '0001-06-01'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 DELETE FROM daily_report_cut_off_date WHERE cut_off_date='0001-06-01'; Query OK, 0 rows affected (0.00 sec) same, = - like. the row is still there, untouched Fix: no workaround :( Submitter-Id: remi catherinot Originator:remi catherinot Organization: Webmotion Inc, MySQL support: none Synopsis: Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: System: Linux ramses.dev.lan 2.2.19pre13 #2 SMP Wed Apr 11 15:15:06 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jun 26 04:02 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 586720 Feb 8 1999 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 Jun 26 04:02 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 887712 Mar 25 17:35 /lib/libc-2.1.3.so -rw-r--r--1 root root 2089576 Mar 25 17:36 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 25 17:36 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Jun 26 04:40 /usr/lib/libc-client.a - c-client.a lrwxrwxrwx1 root root 19 Jun 26 04:40 /usr/lib/libc-client.so - libc-client.so.2000 -rw-r--r--1 root root 710412 Feb 28 13:43 /usr/lib/libc-client.so.2000 -rw-r--r--1 root root 665216 Apr 24 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all 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 - 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
transaction logs using nt4
Hi, I'm still trying to get an answer to this. When restoring a database [in the event of a disk crash for example], I would run my restore from tape and rebuild the database, then I would take the transaction logs and upload those into the database to bring it up to date. From what I cen tell, Mysql does NOT support transaction logging, at least not for NT. Can anyone help, if transactions are not supported, how are those folks that have mysql running on NT, restoring a database? I'm using Mysql version 3.23.27. Thanks! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - 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
core dump on new installation
Description: ./scripts/mysql_install_db fails on a new installation with: Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table longjmp botch. Illegal instruction (core dumped) Installation of grant tables failed! Back trace from .core file: (gdb) bt #0 0x827ae50 in ?? () #1 0x827dea8 in ?? () #2 0x5a100 in THD::THD () #3 0x5a9ac in select_export::~select_export () How-To-Repeat: run ./scripts/mysql_install_db Fix: None known. Have tried recompiling with optimization turned off, but with the same results. Submitter-Id: submitter ID Originator:Scott Ballantyne Organization: ScotSoft Research MySQL support: none Synopsis: core dump on new installation Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.22.32 (Source distribution) Environment: System: OpenBSD redhotmomma 2.9 GENERIC#34 sparc Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/sparc-unknown-openbsd2.9/2.95.3/specs gcc version 2.95.3 20010125 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't connect
What is the recommended procedure to correct this error: ...Can't connect to local MySQL server through socket '/tmp/mysql.sock'.. We seem to encounter this error quiet often. THX, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users in MySQL
Hi. Thanks all for your help. I'm new to MySQL. I'm using win98. Can anyone give the adress of another manual of MySQL (not from mysql.com). Specially I don't know how to manage users in MySQL. Can anyone give me a short explanation? Regards, Daniel Aderhold
Re: users in MySQL
Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED] aderho Can anyone give the adress of another manual of MySQL (not from mysql.com). Why is that ??? The manually you're not willing to use is indeed the *official* manual, which also means the more comprehensive one you can think of. If you don't find that comprehensive, there're none (I believe) to please you Sorry -- sherzod_ruzmetov (sherzodR) email: [EMAIL PROTECTED] I wasn't recommending that we make the links for them, only provide them with the tools to do so if they want to take the gamble (or the gambol). -- Larry Wall in [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
Question about DELETE and Index.
Hi, Does DELETE take advantage of index to locate more quickly row to be deleted ? Thank you :) Jocelyn Fournier Presence-PC
Re: INSERT problem
On Tue, 3 Jul 2001 23:01, Glyndower wrote: Hi all, I'm new to the whole PHP and MySql stuff and I hopeful that I can get a push in the right direction for what I'm sure is a very sinple problem. I have succesfully created a databse using telnet and added data to it also using telnet. I have also succesfully got the data to display on a page using PHP. My problem is adding data from the PHP page. My insert code is: $query = INSERT INTO guests ; $query .= (guest_id, guest_name, ; $query .= guest_email, guest_time, guest_message) ; $query .= values(,'$name','$email',NULL,'$message'); mysql_pconnect(localhost,blahblah,blahblah) or die(Unable to connect to SQL server); mysql_select_db(blah) or die(Unable to select database); mysql_query($query) or die(Insert Failed!); Add here if(mysql_errno) { echo 'Error: ' . mysql_error() . 'BR'; } and if there is an error returned by mysql it will be displayed. When I add data via the form, npthing seems to happen, it does not add the data to the databse, nor does it pop any errors. Any help would be appreciated...tia -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Now I can chop down that tree, said Tom with a heavy accent. - 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: Ms-Access vs MySQL
MySQL doesn't support certain features such as foreign keys and sub-selects but may do so in the future. This is documented in the mysql manual. MS Access is not very suitable for networks especially on a large scale. - Original Message - From: Wavyx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 1:19 Subject: Ms-Access vs MySQL Hi, I'm currently looking for a comparison between Access and MySQL. I mean a table with the advantages and inconvenients of both. I found the bench on mysql.com but I need a comparison not only a bench. Thanks for help Wavyx __ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif - 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: SELECT query
- Original Message - From: Craig Meyers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 3:20 Subject: SELECT query List, Our site is running mysql server version 3.22.32 I'm a power user - not the DBA, so forgive my ignorance. Is it possible to corrupt data with a SELECT query? Very unlikely. Have a look at the logs and see if something else was being performed at around the same time. The connection is made via a shell script: mysql -h servername -u userid -ppassword database QUERY_INPUT SELECT c.id, s.id FROM customers c, simulations s WHERE c.name = 'Customer Name Here' AND s.cust_id = c.id AND s.name = 'Simulation Name Here' QUERY_INPUT During the period I was testing this script, our DBA indicated we lost some data. Is this just a coincidence? I can't see how a benign query could cause such a problem. Thanks. Craig Meyers Senior Engineer Invensys Dynamic Simulation - 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't connect
Possibly because you haven't started the server. The manual contains information on this error in more detail. - Original Message - From: MikemickaloBlezien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 6:27 Subject: Can't connect What is the recommended procedure to correct this error: ...Can't connect to local MySQL server through socket '/tmp/mysql.sock'.. We seem to encounter this error quiet often. THX, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Insert queries add TWO records to database
On Wed, 4 Jul 2001 01:24, John (*\\*) wrote: Operating system: WinNT4 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Insert queries add TWO records to database All my insert queries seem to add two records to the database instead of one. I was using MS Access 2000 and did not have the problem. I am now using MySQL and all insert queries add 2 recs?! Eg. $sql = INSERT INTO Campaign (CampaignName,CampaignDesc,StartDate,EndDate,CompanyId,CampaignStatus,A dmini stratorId) VALUES ('$name','$desc','$start_date','$end_date',$company_id,0,1); $res_insert_campaign=mysql_query($sql,$conn); if (!$res_insert_campaign) { return false; } With the result: CampaignIdCompanyId AdministratorId CampaignNameCampaignDes StartDate EndDate ProposalPDF InvoicePDF CampaignStatus 1145 1 Test Alltesting 2001-07-03 2003-07-03 NULL NULL0 1245 1 Test Alltesting 2001-07-03 2003-07-03 NULL NULL0 (2 row(s) affected) Looks like you are using PHP - and it seems like you might be running the insert in a function given that you are returning a value?? Can you show a little more of your code? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Enter any 11-digit prime number to continue... - 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 meeeeeeeee
Hi, I am working on a banking project. we are planning to take our tour into vb/mysql combination. Please help me sending your comments. Thank you, V.Rajendrakumar. Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - 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
Data Binding
Dynamic HTML (DHTML) promises to change radically the way developers build Web applications. It empowers the client end of the Web server/browser relationship. The DHTML feature most oriented to the needs of database developers is data binding. Data binding can deliver data asynchronously from a server to a Web browser. This process allows browser users to start interacting with a database much more rapidly because they do not have to wait for the creation of the whole page on the server. Another important data binding innovation is the isolation of the data from the Web page, which makes it easier to perform maintenance tasks on databases shared across multiple Web pages. By storing a local data cache, it is possible to perform standard navigation, sorting, and filtering tasks without returning to a server. This approach speeds a surfer's experience while reducing network traffic and server load. Users can add, update, and delete records without constantly having to go back to the server for every change. Because data binding can directly couple with a remote data source, it eliminates the need for server-side processing of GET and POST requests. What about it??? How much does it cost to do it? compared to PHP/ Mysql/ apache ? Ken - 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[2]: Trouble with mysql
Hi! Peter == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Michael, Peter Thursday, June 28, 2001, 11:41:57 PM, you wrote: Peter I'm getting this again and again with two tables which are used in Peter quite the same fation - some selects, often updates, rare inserts, no Peter deletes: mysql repair table counter.quickstat; Peter +---++--+--+ Peter | Table | Op | Msg_type | Msg_text | Peter +---++--+--+ Peter | counter.quickstat | repair | warning | Number of rows changed from 168034 to 168022 | Peter | counter.quickstat | repair | status | OK | Peter +---++--+--+ Peter 2 rows in set (10.72 sec) Next time the table gets corrupt, please upload a copy to 'secret' before you repair it so that I can take a look at this when I come back. Do you have anything in the logs about the table being automaticly repaired? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How delete the first register in a table?
How can i do to delete the first row, tuple, register of a table? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 1:18 PM Subject: mysql Digest 2 Jul 2001 16:18:37 - Issue 1365 - 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
Official binaries core dump (Solaris 8 x86)
Hey all, the following bug report follows the mysqlbug spec, but if I can provide any other information, please let me know. Thanks. Description: I've installed the offical binaries from the mysql site and upon attempt ing to start the server, it core dumps. How-To-Repeat: Any time I attempt to start the server (/usr/local/mysql/bin/safe_mysqld --user=mysql ) it core dumps. Fix: Submitter-Id: Originator:Phil Dibowitz Organization: MySQL support: none Synopsis: Official binaries core dump on Solaris 8 x86 Severity: Priority: medium Category: mysql Class: support Release: mysql-3.23.39 (Official MySQL binary) Environment: System: SunOS Knight 5.8 Generic_108529-07 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /opt/sfw/bin/gmake /opt/sfw/bin/gcc /usr/ucb/cc GCC: Reading specs from /opt/sfw/lib/gcc-lib/i386-pc-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXX FLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtt i' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1586076 Jan 24 10:07 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 23 16:09 /lib/libc.so - ./libc.so. 1 -rwxr-xr-x 1 root bin 938916 Jan 24 10:07 /lib/libc.so.1 -rw-r--r-- 1 root bin 1586076 Jan 24 10:07 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 23 16:09 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 root bin 938916 Jan 24 10:07 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici al MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-s hared Perl: This is perl, version 5.005_03 built for i86pc-solaris Phil -- Insanity Palace of Metallica http://www.ipom.com [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: What's the best os?
On Sat, Jun 02, 2001 at 01:49:59PM +0400, Ilya Martynov wrote: AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have been ported on FreeBSD). In this case threads will spread across the CPUs as on Linux. JZ Funny you mention that... It comes up once in a while, but almost JZ everytime it's someone saying I've heard that you can... I've yet to JZ meet someone who does it and likes it. JZ I'm not saying it's bad, but it just seems like one of those things JZ that people suggest but don't actually have experience with. Ok. I did not compile MySQL with LinuxThreads on FreeBSD myself. I have no idea how to do it because I never tried to do it. But I do know that production server owned by company at which I work do run MySQL with LinuxThreads on FreeBSD. After switch on MySQL with LinuxThreads it was possible to see that perfomance was increased. Output of 'show proceslist' shows that MySQL server is much less loaded (because it handles requests faster) than before. Also people who tested it on test server before deploying on production said that it worked faster. This is real experience. Good to hear. I've heard similar reports from others. I'm going to have to find the time to try this myself. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 17 days, processed 133,432,323 queries (86/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
Re: help meeeeeeeee
Hi, I am working on a banking project. we are planning to take our tour into vb/mysql combination. Please help me sending your comments. Where would you like help sending my comments to? heh. It sounds like you are asking for comments reguarding your choice of vb/mysql... If that is the case, sure it can be done. The only problem I can see if you plan on having end users use this program, they would have to install and configure Mysql on their computers. This might be a bit of a burdon for them. But that is for you to decide. The list can offer more advice if you ask more specific questions. ryan - 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
case insensitive
hallo! in my table i have a column with the caracter char and binary. how can i search case insenitive? -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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 with perl error
The error log says, Can't call method do: on an undefined value. . . But the EXACT SAME code works on another script I'm running. I don't see any reason for it to suddenly have a problem. What does this error message MEAN? Code Snippet-- # Form was okay; get image type and contents and create new record. # Use REPLACE to clobber any old image with the same name. $mime_type = uploadInfo ($image)-{'Content-Type'}; ($full, $thumb) = read_image_file ($image); $dbh-do (REPLACE INTO image (name,listing_id,image,thumbnail,mime_type) VALUES(?,?,?,?,?), undef, $name, $listing_id, $full, $thumb, $mime_type) or bail_out(There's a problem with the upload); -End Snippet--- http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia Filter fixer: database,sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multidatabase systems - Sybase ASE/CIS
I manage several MySql Databases, each with some overlapping features. I would like to set up a multidatabase management system (federated database). Sybase has a product that at one time was called Omni Connect, and now is part of ASE 12.x called CIS. Also, Direct Connect somehow fits in this picture. Anyways, is there anyone on this list with experience with using a sybase product as a multidatabase server? Or does anyone have any experience with other solutions? Tom Thomas S. Brettin 505-665-3334 (office) 505-665-3024 (fax) - 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