strange difference between a != b and (a < b OR a > b)
>Description: a simple select on a large table does not use an indexed column when the WHERE clause uses a != b The same query using as WHERE a < b OR a > b (which of course does the same) *does* use an index. >How-To-Repeat: mysql < 1; *** actually same query, index on number'); EXPLAIN SELECT id from test WHERE number < 1 OR number > 1; drop database unequalproblem END_OF_FILE >Fix: the work around is in the prblem description >Submitter-Id: >Originator:[EMAIL PROTECTED] >Organization: European Design Centre b.v. >MySQL support: none >Synopsis: "WHERE a != b" evaluates different from "WHERE a < b OR a > b" >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.58 (Source distribution) >Environment: System: Linux archie 2.4.20-20.9 #1 Mon Aug 18 11:27:43 EDT 2003 i686 athlon i386 GNU/Linux Architecture: i686 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/3.2.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5) Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='i386-redhat-linux-g++' CXXFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 15 2003 /lib/libc.so.6 -> libc-2.3.2.so -rwxr-xr-x1 root root 1557296 Apr 8 2003 /lib/libc-2.3.2.so -rw-r--r--1 root root 2331360 Apr 8 2003 /usr/lib/libc.a -rw-r--r--1 root root 204 Apr 8 2003 /usr/lib/libc.so Configure command: ./configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--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-readline' '--without-debug' '--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-innodb' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--with-berkeley-db-includes=/usr/include' '--with-berkeley-db-libs=/usr/lib' '--enable-thread-safe-client' 'CFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' '! CXXFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' 'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A dash in user or host confuses the grant statement
>Description: the character '-' in username or hostname is not accepted by the GRANT sql statement. >How-To-Repeat: grant all on *.* to [EMAIL PROTECTED]; >Fix: don't use dashes, fixing the SQL parser. >Submitter-Id: >Originator:Bas Meijer >Organization: Escador >MySQL support: none >Synopsis: a dash in user or host is not accepted by the grant sql staemenet. >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Environment: System: Linux perl.atmm.nl 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 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 Aug 17 13:24 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /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
import fails when lines are too long
>Description: a mysql -p db < file.sql fails when sql contains TEXT fields that are long >How-To-Repeat: create table with text column,fill it with text, mysqldump this table into file.sql mysql -p db < file.sql >Fix: linewrapping the mysqldump file is a workaround, better buffers in mysql client should be the solution. >Submitter-Id: >Originator:ABVAKAVO >Organization: Escador >MySQL support: none >Synopsis: IMPORT halts on too long input lines >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribution) >Environment: System: SunOS fnv-01.cust.asmr-01.energis-idc.net 5.8 Generic_108528-09 sun4u sparc SUNW,UltraSPARC-IIi-cEngine Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make Compilation info: CC='/opt/SUNWspro/bin/cc' CFLAGS='-fast -xtarget=ultra2 -xarch=v9a -xprefetch=yes -s -I/usr/local/include' CXX='/opt/SUNWspro/bin/CC' CXXFLAGS='-fast -xtarget=ultra2 -xarch=v9a -xprefetch=yes -s -I/usr/local/include' LDFLAGS='-fast -xtarget=ultra2 -xarch=v9a -xprefetch=yes -s' LIBC: -rw-r--r-- 1 root bin 1759400 Sep 25 18:46 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 21 15:20 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Sep 25 18:47 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Sep 25 18:46 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 21 15:20 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Sep 25 18:47 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-libwrap=/usr/local/lib --with-mysqld-user=mysql --mandir=/usr/local/man --srcdir=/data/EIDCpackageadmin/SOURCES/mysql-3.23.41 Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
to many connections
reason to "to many connections" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
random record
hi, why its mysql database over random record use?
random record
hi, why its mysql database over random record use?
random data
excuse me have can I get from mysql database random 6 data item?
help me please with mysqlgui
When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve this and/or where I can find documentation on MySQLGui Kind regards, Bas Mooyman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
odbc on mandrake linux
Hi all, I am trying to couple Openoffice.org to MySQL using ODBC. Does anybody have an odbc driver functioning on a mandrake 8.2 linux machine? If so please tell me how to do it. Kind regards, Bas Mooyman. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 crashes after an update statement
>Description: MySQL crashes after issueing the following command : UPDATE BGW_Master, ICA_1_SplitInter SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt WHERE BGW_Master.I1_FileName = ICA_1_SplitInter.I1_FileName AND BGW_Master.I1_runDate = ICA_1_SplitInter.I1_runDate AND ICA_1_SplitInter.I1_Proc_Dt is null; This is wierd since it not such a complex SQL after all... >How-To-Repeat: Resumbit the SQL above >Fix: Not found a workaround yet... >Submitter-Id: Bas van Ritbergen >Originator:Super-User >Organization: O2 the Netherlands Haaksbergweg 75 1101 BR Amsterdam ZO +31-20-2004365 >MySQL support: none >Synopsis: MySQL crashes >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-4.0.4-beta-max (Official MySQL-max binary) >Environment: System: SunOS amBGw1 5.7 Generic_106541-17 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1707532 Oct 16 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 5 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 16 2001 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1707532 Oct 16 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 5 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 16 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-berkeley-db CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stepping back in time: copying data from 4.0.20 to 4.0.17, ok?
Hi all, I need to move a database from a 4.0.20 MySQL server to a 4.0.17 server. I expect it will work fine when simply scp-ing the whole /var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql directory, with only a minor version difference. Can anyone confirm this is going to work and will 4.0.17 be able to read the 4.0.20 generated data files without problems? I'd love to upgrade the 4.0.17 server but it's running another database that really can't go offline. Thanks in advance, Bas. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP] Re: Returning html code-PROB SOLVED
except there's no need to stripslashes(), in fact it could even break things..
unless you have magic_quotes_runtime enabled (default is off in the latest php)
bvr.
On Mon, 17 Dec 2001 16:33:24 -0700, Kevin Stone wrote:
>Ahh.. I was about to reply but nevermind. The two functions you're talking
>about are addslashes() and stripslashes(). Yes those are very handy. :)
>
>>
>>
>> > Does anyone know of an easy way to store html code in a mysql database,
>> and
>> > then retreive it, in such a way that it can display the page as if it
>were
>> a
>> > standard html page? Would using php be of benefit to me?
>>
>>
>> Figured it out. I completely forgot about two php functions that escape
>> problem characters in databases and unescape them when retrieved.
>>
>> Problem solved.
>>
>> Steve Osborne
>> [EMAIL PROTECTED]
>>
>> > /* Happy Holidays */
>> mysql_select_db('North_Pole');
>> mysql_query('SELECT reindeer FROM stable WHERE nose_color="red"');
>> ?>
>>
>>
>>
>>
>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [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
