How to change database directory?
Right now, my MySQL databases are inside /var/lib/mysql. I need to move them into /home, because there is not enough room in the /var partition for the databases to grow much more. This is a production server. How can I safely move the MySQL databases into /home, with minimal downtime and no data corruption? I'm guessing that I should: 1. Change mysqld configuration file to use /home/mysql instead 2. /etc/rc.d/init.d/mysql stop # stop mysqld 3. Keep checking ps -A | grep mysql until mysqld is stopped 4. mv /var/lib/mysql /home/mysql 5. /etc/rc.d/init.d/mysql start # start mysqld Is this correct? And how would I do step #1? Thanks, -Philip Mak ([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: why doesn't this work? (C code)
Peter Faulks writes:
On Sat, 21 Apr 2001 14:12:20 +0300 (EEST), Sinisa Milivojevic wrote:
As our manual clearly describes one connection can be used for one
query at a time, unless you use threads and mutexes.
G'day
As I said, it worked fine b4 and I got it to work again. I _assumed_
the reason it fell over was because of an unneccessary call to
mysql_free_result().
Without actually having looked at MySql's source code, would it be
logical to assume that a call to mysql_store_result() would free the
'cursor' resources as it's last act, and mysql_free_result() simply
frees the 2D char array result set? If so, then I can't see where the
problem would be
This is a worry - I use this method (inner and outer cursors) all the
time. (I come from using Sybase / embedded SQL - where you can declare
cursors and use host variables)
I'm only really using MySql because that's what most ISP's seem to
provide. If this issue is going to cause me grief, I might have to find
an ISP who provides Postgres...:-)
Regards
Hi!
mysql_store_result does not free any memory.
Memory is freed by mysql_free_result only.
If you wish to have multiple cursors, you should try to use local
variables only.
That is especially very easy and flexible with MySQL++.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PATCH2: bug report
Hi!
"Andrew" == Andrew Schmidt [EMAIL PROTECTED] writes:
Description:
Andrew tough one to describe. the step by step example shows all
Andrew basicly once a table gets more than 1 row and doing a select with no
Andrew result will yield a blank date... gah please see the example =)
cut
When I emailed you a patch for this, I did accidently remove one row
from the source.
Here is a patch you have to apply after my previous patch to fix this.
= sql/sql_select.cc 1.95 vs edited =
*** /tmp/sql_select.cc-1.95-6144Sat Apr 21 17:12:59 2001
--- edited/sql/sql_select.ccSun Apr 22 10:57:16 2001
***
*** 4907,4912
--- 4907,4913
}
if (idx (int) join-send_group_parts)
{
+ copy_fields(join-tmp_table_param);
copy_funcs(join-tmp_table_param.funcs);
init_sum_functions(join-sum_funcs);
if (join-procedure)
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
grant permissions
Hello. I want to create a user in mysql that can create and "grant" other users with permissions to a specific table. I created user with permitions of "grants", and permissions of "insert" and "grant" to "mysql" database, and I cant add users with that user. I want that this user could add users, but not remove them. another question - can I create such user, but without permissions to change properties of user root, or to create user with root permition. and one more question: Can I make additional users-permitions table or data-base in MySql in order to use it for specific database? Thank you, Tamar Klein - 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: Bug in the SET type when using 1..64 as values, 63 is ok
[EMAIL PROTECTED] writes:
Description:
Hi,
I noticed this when making a set called groups with 64 values from 1 to 64.
When inserting or updating the table with a numeric value ex 15 (should set
value 1-4),
select * from whatever doesn't show anything in that colum (not even NULL). If
using
1 to 63 it works.. 0 to 63 doesn't. 0 to 62 and Z doesn't.
I'm not on the list, so the bug might already be reported (didn't find it when
searching tho),
I'm not a guru, so I might have done something wrong (sorry;-), and please cc
replies to me ;-)
Thanks for a great product!
How-To-Repeat:
create table settest (
id int,
s1 set('1','2','3','4'),
s2
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63'),
s3
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'));
insert into settest values (1,15,15,15);
select * from settest;
Fix:
Only use 63 fields ;-)
Submitter-Id:submitter ID
Originator: Magnus Espeland
Organization:
MySQL support: none
Synopsis:Bug in the SET type with 64 entries
Severity:non-critical
Priority:medium
Category:mysql
Class: sw-bug
Release: mysql-3.23.37 (Official MySQL RPM)
Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version3.23.37
Protocol version 10
ConnectionLocalhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 hours 40 min 50 sec
Threads: 2 Questions: 158 Slow queries: 0 Opens: 38 Flush tables: 1 Open
tables: 19 Queries per second avg: 0.003
Environment:
System: Linux kelso 2.2.16-3 #1 Mon Jun 19 18:49:25 EDT 2000 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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Dec 9 08:09 /lib/libc.so.6 -
libc-2.1.3.so
-rwxr-xr-x1 root root 4101836 Sep 6 2000 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20273284 Sep 6 2000 /usr/lib/libc.a
-rw-r--r--1 root root 178 Sep 6 2000 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
From our fine manual:
`SET('value1','value2',...)'
A set. A string object that can have zero or more values, each of
which must be chosen from the list of values `'value1'',
`'value2'', `...' A `SET' can have a maximum of 64 members. *Note
SET::.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: french characters
In order to see french characters you have to put in your php4/html page header the line: META http-equiv="Content-Type" content="text/html; charset=iso-8859-2" Put this line in all your pages that writing or reading from mysql server. I'm not sure about iso code - try to find your language code... Original massege: -- hi, i'm running mysql server version 3.23.33 on a win98 machine using the following characterset : latin1 i have the following problem when i enter french characters like à or é... into the database using php4 scripts they are improperly recorded and returned like ? or , what i want to know is what's the reason for this? bad character set? (in which reason how to change it and which one to choose?) is ¨PHP responsible for this? --Tamar Klein - 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: compress problem when using MySQL++
Wm Terry writes:
I seem to have a problem similar to others, but none of the suggested
solutions seem to solve it. It's the standard "undefined reference to
`compress'" while using MySQL++. What am I missing. Many solutions
appear to address libmysqlclient. So I'm not sure if the problem is
MySQL or MySQL++ oriented (though MySQL is working fine and the MySQL++
examples make fine).
$ make metamgrd
gcc -c -g -I/usr/local/mysql metamgrd.C
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd
-lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0x126): undefined reference to `compress'
collect2: ld returned 1 exit status
make: *** [metamgrd] Error 1
I've remade a MySQL++ example for grins and it works fine.
# make simple1
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I../sqlplusint -I../sqlplusint
-I/usr/local/mysql/include/mysql -g -O2 -c simple1.cc
/bin/sh ../libtool --mode=link c++ -g -O2 -L/usr/local/mysql/lib/mysql
-o simple1 simple1.o ../sqlplusint/libsqlplus.la -lz -lmysqlclient
c++ -g -O2 -L/usr/local/mysql/lib/mysql -o .libs/simple1 simple1.o
../sqlplusint/.libs/libsqlplus.so -lz -lmysqlclient -lz -lmysqlclient
-Wl,--rpath -Wl,/usr/local/lib
creating simple1
Running simple1 causes a core dump, but I'm guessing that has to do with
not having the appropriate db and dbaccess (didn't modify the code). I
figured I'd start by using modified parts of the examples in my own app
and that that would be just as good a test (if I can make it).
I have checked and config.h for MySQL does have HAVE_COMPRESS defined.
I've rebuilt MySQL and MySQL++ from scratch (started with the MySQL RPM
install when I build the system - first time I've used development stuff
from an RPM, so I decided to start from scratch just to make sure).
gcc version 2.96 2731 (Red Hat Linux 7.0)
Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown
Help would be greatly appreciated.
Thanks, William
Hi!
First, regarding core dump, please rebuild MySQL++ with this
connection.cc :
Second, downgrade to 2.95.2 as 2.96 is very buggy when it comes to
C++.
Third, compress and uncompress are defined in zlib library.
The above is a bug in your linker. Try including static zlib in a link
args.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in the SET type when using 1..64 as values, 63 is ok
Magnus Espeland writes:
Well, 0 to 63 and 1 to 64 is the max, but not more than max... Shouldn't it
work?
And I reckon '1' is a string and not a number (with the quotes) ?
:-)
`SET('value1','value2',...)'
A set. A string object that can have zero or more values, each of
which must be chosen from the list of values `'value1'',
`'value2'', `...' A `SET' can have a maximum of 64 members. *Note
SET::.
MVH/Best Regards
--
Magnus Espeland
[EMAIL PROTECTED]
PGP key: 0xEE977A6F
"We are star stuff" -Delenn
Nope.
MySQL automatically assigns numbers for each SET / ENUM item, from 0
up.
And yes, "1" is a string.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
french characters
hi, i'm running mysql server version 3.23.33 on a win98 machine using the following characterset : latin1 i have the following problem when i enter french characters like or ... into the database using php4 scripts they are improperly recorded and returned like ? or , what i want to know is what's the reason for this? bad character set? (in which reason how to change it and which one to choose?) is PHP responsible for this? please help thank you in advance - 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
anyone try install mysql on Webvisions virtual server b4?
I am having problem installing mysql into virtual host server. How do I select where Mysql should be installed to? how do i set which path i want the mysql.sock to be installed? - 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: purpose of groupadd and useradd
Hi Everybody! Installing Mysql on a sparc sun solaris 2.7 machine. The manual from msyql.com mentions adding "user" and "group." What's the purpose of this? Thanks for your help! My guess would be to have mysql running under it's own uid/gid in the event someone uses it to gain unauthorised access to your system, or other similar reasons. jason - 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 1046: No Database Selected
On Fri, 20 Apr 2001, Siomara Pantarotto wrote: Date: Fri, 20 Apr 2001 19:35:52 -0300 From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: ERROR 1046: No Database Selected Hi all, I am getting this error mysql create table Product ( - productID numeric(10), - name varchar(30), - primary key(productID) - ); ERROR 1046: No Database Selected mysql How do I fix that please??? siomara mysqluse the-database-y-created-before; -- jean-michel - 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: Information Technique
Samir Baghdadi wrote: Salut Mr/Mme, J'ai une question prcise : Comment coder les caractres spciaux (de type , ,..) dans une BDD MySql Le problme c'est que j'ai developp avec JSP un site en utilisant le Systme d'exploitation Windows (les essais taient positifs). Lors de l'hbergement, (Sur adgraphix) les caractres spciaux ne sont pas insrs correctement dans la BDD Par exemple devient ? J'espre avoir une rponse, mme si ngative Merci Salutations, Samir: Je ne sais pas si MySQL avec le support de BDB fonctionne avec les caractres spciaux. En outre, je ne suis pas sr comme NLS tendu (support de langue maternelle) est avec des Windows. Vous pourriez devoir compiler MySQL vous-mme avec un compilateur des Windows C pour que ceci travaille, bien que, je ne sache pas. Respects, Van Mr/Mme Hello, I have a precise question: How to code them special characters (of type with, 3rd..) in BDD MySql the problem it is that I developp with JSP a site by using the Operating system Windows (them tests were positive). At the time of lodging, (On adgraphix) the characters special are not inserted correctly in BDD For example into becomes? I hope to have an answer, even if if negative Merci Greetings, Samir: I don't know if MySQL with BDB support works with special characters. Also, I'm not sure how extensive NLS (Native Language Support) is with Windows. You might need to compile MySQL yourself with a Windows C compiler for this to work, though, I wouldn't know how. Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
login behaviour
I have installed MySQL 3.23.26 on a Win 2K server. Set up a user: - name: Remote - host: % and "localhost" - password: password The 2 user entries are confirmed when I query the user table. The problem is: When trying to connect to the database from another PC, if I leave the password blank when prompted, then I connect ok. However, when I enter the valid password, it says: access denied for 'Remote@localhost' (using password: YES). This means that my server is totally unsecure, as someone can try to guess a user name and use blank as password. Can someone offer help in fixing this behaviour? Thanks Fred - 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
Using mifluz for full text indexing
Has anyone here used mifluz for full text indexing of TEXT columns in MySQL? I have a table with a "num" (MEDIUMINT, unique row identifier) and "message" (MEDIUMTEXT, the column to be indexed) column. I'd like to be able to do full text searches on the "message" column and get back a list of "num". I think that mifluz is the best library to use for doing this because of its scalability and robustness. I can't use MySQL's built-in full text indexing because I need phrase searching. I have a problem, though. After reading through the mifluz documentation, I can't figure out how to create the inverted index and populate it with words. Does anyone know how to do this (I'm guessing a program that reads the data from the database and calls the mifluz routines is required)? Or, is there another, easier to use, good full text searching package that I can use for searching MySQL text columns? Thanks, -Philip Mak ([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
storing mail files in mysql
I would appreciate pointers to scripts that parse mail files (linux mailbox format or rmail format would be even better) and store the parsed information in a mysql database. Thanks, Jim Jim Hollan, ProfessorWeb: http://hci.ucsd.edu Department of Cognitive Science Phones: (858) 822-2476 (fax) University of California, San Diego (858) 534-8156 (office) La Jolla, CA 92093-0515 USA (858) 534-6771 (department) - 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: Installation prob on i386 solaris 2.6
Database configure problem: When running configure I get the following error: configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. I checked for libm.a and found it in /usr/lib Any idea where I should look to figure this out? Thanks for any advice you can send my way , Anatole - 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
MSACCESS v.s. MYSQL
Hi there I have an application that is currently running on MSACCESS, using ADO and Visual Basic 6.0 I am looking at alternate databases and have been testing with MYSQL for some days now. I have noticed a couple distinct differences in some of the SQL statements, but have managed to come around these. I do seem to be having one problem, and that is when I am trying to write a blank value to a column. The column is set to "Null allowed=YES", but when I try and write rs.addr3=variable "" it says "Multipe steps generate errors" which when using access, mean't I never had the ' ""' at the end. By the way, variable in this particular case equals nothing Also, has anyone moved from Access to MYSQL on a live application, what kind of things did you encounter when doing this migration? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 - 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: Running a private copy of mysqld
On Sun, Apr 22, 2001 at 12:09:24PM -0400, Bernie Cosell wrote: how to get it there... I'd appreciate a 'howto' [or a ptr to the docs or whatever] for what I need to do to get the new datadirectory set up. THANKS! mysql_install_db.sh it's in the /path/to/your/mysql/source/scripts directory Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3000 ext. 291 - 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 mysql under FreeBSD
Hi, I have test two systems with mysql Linux Slackware 7.1 kernel 2.2.16 and FreeBSD-4.2-STABLE. I have mysql 3.23.36 only running on this two hosts and hosts are the same (PIII 800 Mhz Ami MegaRaid RAID 1 18.2 Go 1 Go RAM). I copy the database from FreeBSD to Linux and I launch a same select on this two hosts. Results on FreeBSD: mysql select count(*) from transat; +--+ | count(*) | +--+ | 3394568 | +--+ 1 row in set (0.00 sec) mysql select * from transat where id='HGUI'; (...) | HGUI | 2001-04-20 17:35:03 | 79.7 | 8 | 0 | |0 | | +-+-++-+-+-+--+ 3951 rows in set (1.29 sec) Results on Linux: mysql select count(*) from transat; +--+ | count(*) | +--+ | 3394568 | +--+ 1 row in set (0.00 sec) mysql select * from transat where id='HGUI'; (...) | HGUI | 2001-04-20 17:35:03 | 79.7 | 8 | 0 | |0 | | +--+-++-+-+-+--+ 3951 rows in set (0.16 sec) I don't know why there is a big difference between this two systems. Somebody can explain me why ? Please reply to [EMAIL PROTECTED] Thank you. spe. -- [EMAIL PROTECTED]
Re: compress problem when using MySQL++
On Sun, 22 Apr 2001, Sinisa Milivojevic wrote:
Wm Terry writes:
I seem to have a problem similar to others, but none of the suggested
solutions seem to solve it. It's the standard "undefined reference to
`compress'" while using MySQL++. What am I missing. Many solutions
appear to address libmysqlclient. So I'm not sure if the problem is
MySQL or MySQL++ oriented (though MySQL is working fine and the MySQL++
examples make fine).
$ make metamgrd
gcc -c -g -I/usr/local/mysql metamgrd.C
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd
-lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0x126): undefined reference to `compress'
collect2: ld returned 1 exit status
make: *** [metamgrd] Error 1
I've remade a MySQL++ example for grins and it works fine.
# make simple1
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I../sqlplusint -I../sqlplusint
-I/usr/local/mysql/include/mysql -g -O2 -c simple1.cc
/bin/sh ../libtool --mode=link c++ -g -O2 -L/usr/local/mysql/lib/mysql
-o simple1 simple1.o ../sqlplusint/libsqlplus.la -lz -lmysqlclient
c++ -g -O2 -L/usr/local/mysql/lib/mysql -o .libs/simple1 simple1.o
../sqlplusint/.libs/libsqlplus.so -lz -lmysqlclient -lz -lmysqlclient
-Wl,--rpath -Wl,/usr/local/lib
creating simple1
Running simple1 causes a core dump, but I'm guessing that has to do with
not having the appropriate db and dbaccess (didn't modify the code). I
figured I'd start by using modified parts of the examples in my own app
and that that would be just as good a test (if I can make it).
I have checked and config.h for MySQL does have HAVE_COMPRESS defined.
I've rebuilt MySQL and MySQL++ from scratch (started with the MySQL RPM
install when I build the system - first time I've used development stuff
from an RPM, so I decided to start from scratch just to make sure).
gcc version 2.96 2731 (Red Hat Linux 7.0)
Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown
Help would be greatly appreciated.
Thanks, William
Hi!
First, regarding core dump, please rebuild MySQL++ with this
connection.cc :
[ Part 2, Application/OCTET-STREAM 6KB. ]
[ Cannot display this part. Press "V" then "S" to save in a file. ]
[ Part 3: "message body text" ]
Second, downgrade to 2.95.2 as 2.96 is very buggy when it comes to
C++.
Third, compress and uncompress are defined in zlib library.
The above is a bug in your linker. Try including static zlib in a link
args.
When you say the bug is in the linker, do you mean in the linker app
itself or how I'm using it? In terms of the static zlib, don't I have that
covered with
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
-lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
or am I missing something else?
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
___W__i__l__l__i__a__m_D__a__n_T__e__r__r__y___
How do we acquire wisdom along with all these shiny things? -David Brin
PGP public key: http://www.knotworks.com/wdt_pgp_pubkey.asc
fingerprint: DC 80 E4 18 E2 CB AC F4 8C 59 9B 9C BB A2 D7 4B
[ Part 2, Application/OCTET-STREAM 6KB. ]
[ Cannot display this part. Press "V" then "S" to save in a file. ]
[ Part 3: "message body text" ]
Second, downgrade to 2.95.2 as 2.96 is very buggy when it comes to
C++.
Third, compress and uncompress are defined in zlib library.
The above is a bug in your linker. Try including static zlib in a link
args.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
names ...
Hi - i have a problem giving names to some tables or fields. using a name like "select" or some predefined SQL-standard-words causes errors because it is not seen as a name, but as a command. any solution to this ? - 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: names ...
Don't use mysql predefind names... you can add one letter to each field name, or try to use '' for example: 'search' (I'm not sure it's working like that. maybe in some versions of mysql) You wrote: Hi - i have a problem giving names to some tables or fields. using a name like "select" or some predefined SQL-standard-words causes errors because it is not seen as a name, but as a command. any solution to this ? --Tamar Klein - 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 about mysql under FreeBSD
Yes, I try to use with softupdates or async but results is the same. DD are SCSI U3W Disks. Have an idea ? spe. -- [EMAIL PROTECTED] - Original Message - From: "Andrey Nepomnyaschih" [EMAIL PROTECTED] To: "Sebastien Petit" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, April 22, 2001 7:35 PM Subject: RE: question about mysql under FreeBSD Hello over there, Do you have softupdates enabled? Have a good time, Andrey Nepomnyaschih [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: names ...
Stephan Weileder wrote: Hi - i have a problem giving names to some tables or fields. using a name like "select" or some predefined SQL-standard-words causes errors because it is not seen as a name, but as a command. any solution to this ? http://www.mysql.com/doc/R/e/Reserved_words.html -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com .3550 Arapahoe Ave, #6 .. . . . .Boulder, CO 80303, U.S.A. - 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
Sorting on multiple tables
This is more of a SQL question than a MySQL question, but I'll ask here. I have a series of tables, each with widely differing structures. Each table has an "id" and "timestamp" field, a number of other wildly different fields, and an identifier (name, title, owner... it's different in every table) that I wish to display. My goal is to gather all of the information from all tables, sort by date, and display. I cannot find any way to do this with a single SQL call, however. My current solution is to do the following... create table tmp (id int primary key, modified date, ident tinytext); insert into tmp select id, timestamp, name from loc; insert into tmp select id, timestamp, title from media; insert into tmp select id, timestamp, owner from inventory; ... select * from tmp order by modified; drop table tmp; Is there an easier/faster way? Thanks, Scott -- Scott F. Crosby E-Mail : [EMAIL PROTECTED] Web : http://www.skroz.net "If a cluttered desk signs a cluttered mind, of what, then, is an empty desk a sign?" -- Albert Einstein "Science is like sex: sometimes something useful comes out, but that is not the reason we are doing it" -- Richard Feynman "What good is science if it isn't used for EVIL!?" I can accept encrypted messages enciphered with Verisign or GPG/PGP. Both public keys can be found at http://www.skroz.net PGP signature
[NEWBIE] Problem to launch mysqld
I try to execute "safe_mysqld --user=mysqladmin " and the system return: "chown: mysqladmin: usesager invalide Starting mydqld daemon with databases from var/lib/mysgl 010422 : 17:59:25 mysqld ended" I'm extremely newbie in Linux and I waould appreciate some help To launch MySQL PII 350 Mhz running Linux Redhad 7.0 distribution Thanks -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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
flow control in mysql
Hi, Does mysql query support iteration? Can I write loop logic in a mysql qurey? thanks. - 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
Referer Count
I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT COUNT(*) FROM members WHERE ref1 = 25; To get a list of the top referers and the # of referrals they have, my query is: SELECT DISTINCT(ref1) AS member_id, COUNT(*) AS count FROM members GROUP BY ref1 ORDER BY count DESC LIMIT 100 However, what I need, is a list of the top referers, along with their member information...name, email, password, etc. I tried using the following query, as I read about it in the MySQL manual, but it doesn't work: SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)), LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_id GROUP BY a.ref1 ORDER BY count DESC LIMIT 10 This gives me correct info for the distinct a.ref1 and count fields, and produces data for the rest of the fields, but it is not actually that member's data. Is this possible to do with one query? If I want to get the top 100 referers' data, I don't want to do 100 separate queries. Please help! Thanks, Daren Cotter - 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: flow control in mysql
At 2:54 PM -0400 4/22/01, Kevin Xin Lin wrote: Hi, Does mysql query support iteration? Can I write loop logic in a mysql qurey? thanks. No. You'll need to use a programming language that supports iteration and run the query from within the language. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
command in windows
Hi, I need to know how to do the various commands in windows. I tried c:\mysql It says Bad command or file name. Someone please help me. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Referer Count
why are you using distinct(ref1)? also count(*) is ambiguous in this case. should be count(a.*). you have a ref1 column in both tables, but you don't join them on it. that's kind of confusing but won't cause the problem. member_id is the primary key on the members table, right? Otherwise you could get bad data. I think eliminating the distinct will solve your problem: select a.id, count(a.*) as nrows, b.field1, b.field2, etc. from a, b where a.id=b.id group by a.id, b.field1, b.field2, etc. order by nrows desc limit 100 note you can put a.id alone in the group by, but this is not ANSI sql, so it might be best to avoid this mysql-specific behavior. braxton -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 5:31 PM To: [EMAIL PROTECTED] Subject: Referer Count I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT COUNT(*) FROM members WHERE ref1 = 25; To get a list of the top referers and the # of referrals they have, my query is: SELECT DISTINCT(ref1) AS member_id, COUNT(*) AS count FROM members GROUP BY ref1 ORDER BY count DESC LIMIT 100 However, what I need, is a list of the top referers, along with their member information...name, email, password, etc. I tried using the following query, as I read about it in the MySQL manual, but it doesn't work: SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)), LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_id GROUP BY a.ref1 ORDER BY count DESC LIMIT 10 This gives me correct info for the distinct a.ref1 and count fields, and produces data for the rest of the fields, but it is not actually that member's data. Is this possible to do with one query? If I want to get the top 100 referers' data, I don't want to do 100 separate queries. Please help! Thanks, Daren Cotter - 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
web application integration
Hi, Can anyone please point me toward any tutorials /. books regarding integrating web mysql data with ,say, a LAN-based accounting system? I'm not sure how to interface with dynamic files continually upgraded by surfers. Any comments welcome. regards, Graham - 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: command in windows
At 12:37 PM -0700 4/22/01, ricky gonzalez wrote: Hi, I need to know how to do the various commands in windows. I tried c:\mysql It says Bad command or file name. Give the correct path to the program (perhaps C:\mysql\bin\mysql) or add the directory in which the programs are installed to your PATH setting. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Referer Count
At 2:31 PM -0800 3/22/01, Daren Cotter wrote: I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT COUNT(*) FROM members WHERE ref1 = 25; To get a list of the top referers and the # of referrals they have, my query is: SELECT DISTINCT(ref1) AS member_id, COUNT(*) AS count FROM members GROUP BY ref1 ORDER BY count DESC LIMIT 100 However, what I need, is a list of the top referers, along with their member information...name, email, password, etc. I tried using the following query, as I read about it in the MySQL manual, but it doesn't work: You're asking for a summary as well as a listing. You'll need two queries. One to get the member_id for the top 25 referers, another to pull the information for those members. You can use ...WHERE member_id IN (list) on the second query, where "list" is a comma separated list of the member_id values. Probably best to put this stuff in a Perl script or something so that you can manipulate the list and construct the queries easily. SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)), LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_id GROUP BY a.ref1 ORDER BY count DESC LIMIT 10 This gives me correct info for the distinct a.ref1 and count fields, and produces data for the rest of the fields, but it is not actually that member's data. Is this possible to do with one query? If I want to get the top 100 referers' data, I don't want to do 100 separate queries. Please help! -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error 2003
Hi, I am getting an "error 2003 Can't connect MySQL server on Local Host (10061)" What does it mean? What should I do? __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Referer Count
Actually, I did get it figured out...it was a small mistake SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)) , LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_ date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_i d GROUP BY a.ref1 ORDER BY count DESC LIMIT 20; Daren Cotter CEO, InboxDollars.com http://www.inboxdollars.com (507) 382-0435 -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 12:58 PM To: Daren Cotter; [EMAIL PROTECTED] Subject: Re: Referer Count At 2:31 PM -0800 3/22/01, Daren Cotter wrote: I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT COUNT(*) FROM members WHERE ref1 = 25; To get a list of the top referers and the # of referrals they have, my query is: SELECT DISTINCT(ref1) AS member_id, COUNT(*) AS count FROM members GROUP BY ref1 ORDER BY count DESC LIMIT 100 However, what I need, is a list of the top referers, along with their member information...name, email, password, etc. I tried using the following query, as I read about it in the MySQL manual, but it doesn't work: You're asking for a summary as well as a listing. You'll need two queries. One to get the member_id for the top 25 referers, another to pull the information for those members. You can use ...WHERE member_id IN (list) on the second query, where "list" is a comma separated list of the member_id values. Probably best to put this stuff in a Perl script or something so that you can manipulate the list and construct the queries easily. SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)), LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_id GROUP BY a.ref1 ORDER BY count DESC LIMIT 10 This gives me correct info for the distinct a.ref1 and count fields, and produces data for the rest of the fields, but it is not actually that member's data. Is this possible to do with one query? If I want to get the top 100 referers' data, I don't want to do 100 separate queries. Please help! -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: web application integration
Graham, What kind of files are they? (Access? M$ SQL? .DFB? other?) Cal http://www.calevans.com -Original Message- From: Graham Nichols [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 2:53 PM To: [EMAIL PROTECTED] Subject: web application integration Hi, Can anyone please point me toward any tutorials /. books regarding integrating web mysql data with ,say, a LAN-based accounting system? I'm not sure how to interface with dynamic files continually upgraded by surfers. Any comments welcome. regards, Graham - 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
wrong dependency to db.h
Hi! "ch" == ch [EMAIL PROTECTED] writes: Description: ch sql/Makefile.in has a dependency to ../bdb/build_unix/db.h at ch line 621. This file is not presence in mysql-3.23.37. How-To-Repeat: ch N/A Fix: ch delete the reference? This reference is automaticly generated by automake and I don't know how we could delete this. The reason it is there is that to make a distribution, we have to compile with configure option to include both Berkeley DB and InnoDB in the distribution file. The dependency is a side effect of this. On the other hand, we have compiled the MySQL 3.23.37 source distribution with a variate of compilers and make programs and we haven't noticed any problems with the above dependency. What kind of problems did you encounter with it? 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
Re: compress problem when using MySQL++
I solved my own problem. A simple switch in the order of the libraries
listed in the link command did the trick.
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
-lstdc++ -L/usr/lib/mysql -lmysqlclient -lz -lsqlplus
On Sun, 22 Apr 2001, William Dan Terry wrote:
On Sun, 22 Apr 2001, Sinisa Milivojevic wrote:
Wm Terry writes:
I seem to have a problem similar to others, but none of the suggested
solutions seem to solve it. It's the standard "undefined reference to
`compress'" while using MySQL++. What am I missing. Many solutions
appear to address libmysqlclient. So I'm not sure if the problem is
MySQL or MySQL++ oriented (though MySQL is working fine and the MySQL++
examples make fine).
$ make metamgrd
gcc -c -g -I/usr/local/mysql metamgrd.C
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd
-lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0x126): undefined reference to `compress'
collect2: ld returned 1 exit status
make: *** [metamgrd] Error 1
I've remade a MySQL++ example for grins and it works fine.
# make simple1
c++ -DHAVE_CONFIG_H -I. -I. -I.. -I../sqlplusint -I../sqlplusint
-I/usr/local/mysql/include/mysql -g -O2 -c simple1.cc
/bin/sh ../libtool --mode=link c++ -g -O2 -L/usr/local/mysql/lib/mysql
-o simple1 simple1.o ../sqlplusint/libsqlplus.la -lz -lmysqlclient
c++ -g -O2 -L/usr/local/mysql/lib/mysql -o .libs/simple1 simple1.o
../sqlplusint/.libs/libsqlplus.so -lz -lmysqlclient -lz -lmysqlclient
-Wl,--rpath -Wl,/usr/local/lib
creating simple1
Running simple1 causes a core dump, but I'm guessing that has to do with
not having the appropriate db and dbaccess (didn't modify the code). I
figured I'd start by using modified parts of the examples in my own app
and that that would be just as good a test (if I can make it).
I have checked and config.h for MySQL does have HAVE_COMPRESS defined.
I've rebuilt MySQL and MySQL++ from scratch (started with the MySQL RPM
install when I build the system - first time I've used development stuff
from an RPM, so I decided to start from scratch just to make sure).
gcc version 2.96 2731 (Red Hat Linux 7.0)
Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown
Help would be greatly appreciated.
Thanks, William
Hi!
First, regarding core dump, please rebuild MySQL++ with this
connection.cc :
[ Part 2, Application/OCTET-STREAM 6KB. ]
[ Cannot display this part. Press "V" then "S" to save in a file. ]
[ Part 3: "message body text" ]
Second, downgrade to 2.95.2 as 2.96 is very buggy when it comes to
C++.
Third, compress and uncompress are defined in zlib library.
The above is a bug in your linker. Try including static zlib in a link
args.
When you say the bug is in the linker, do you mean in the linker app
itself or how I'm using it? In terms of the static zlib, don't I have that
covered with
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
-lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
or am I missing something else?
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
___W__i__l__l__i__a__m_D__a__n_T__e__r__r__y___
How do we acquire wisdom along with all these shiny things? -David Brin
PGP public key: http://www.knotworks.com/wdt_pgp_pubkey.asc
fingerprint: DC 80 E4 18 E2 CB AC F4 8C 59 9B 9C BB A2 D7 4B
[ Part 2, Application/OCTET-STREAM 6KB. ]
[ Cannot display this part. Press "V" then "S" to save in a file. ]
[ Part 3: "message body text" ]
Second, downgrade to 2.95.2 as 2.96 is very buggy when it comes to
C++.
Third, compress and uncompress are defined in zlib library.
The above is a bug in your linker. Try including static zlib in a link
args.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\
Re: How to install the grant tables and start the server
Hi, I need to know how to install the grant tables and start the server on windows platform in mysql. Someone please let me know. It's much appreciated. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1046: No Database Selected
Hello all, I wonder if someone could send me a java code showing how to access a mysql databse. I will appreciate very much, actually my job is counting on that. Thanks in advance Siomara _ 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
Java Example for connection
Hello all, I wonder if someone could send me a java code showing how to access a mysql databse. I will appreciate very much, actually my job is counting on that. Thanks in advance Siomara _ 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: How to install the grant tables and start the server
Hi, I need to know how to install the grant tables and start the server on windows platform in mysql. Someone please let me know. It's much appreciated. The grant tables are preinstalled as part of the Windows distribution. You don't need to install them. As for starting the server, the relevant section of the manual describes how to do this: http://www.mysql.com/doc/W/i/Windows.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transaction
Hi,all Does the latest version of mysql 3.23.37 is the binary version support transation? - 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: Referer Count
yet another argument for sub-selects :) Paul DuBois wrote: At 2:31 PM -0800 3/22/01, Daren Cotter wrote: I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT COUNT(*) FROM members WHERE ref1 = 25; To get a list of the top referers and the # of referrals they have, my query is: SELECT DISTINCT(ref1) AS member_id, COUNT(*) AS count FROM members GROUP BY ref1 ORDER BY count DESC LIMIT 100 However, what I need, is a list of the top referers, along with their member information...name, email, password, etc. I tried using the following query, as I read about it in the MySQL manual, but it doesn't work: You're asking for a summary as well as a listing. You'll need two queries. One to get the member_id for the top 25 referers, another to pull the information for those members. You can use ...WHERE member_id IN (list) on the second query, where "list" is a comma separated list of the member_id values. Probably best to put this stuff in a Perl script or something so that you can manipulate the list and construct the queries easily. SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password, concat(UCASE(SUBSTRING(b.first_name,1,1)), LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email, b.html_mail, b.ref1, DATE_FORMAT(b.signup_date, '%b %e, %Y') AS signup_date FROM members AS a, members AS b WHERE a.active_member = 'Y' AND a.ref1 = b.member_id GROUP BY a.ref1 ORDER BY count DESC LIMIT 10 This gives me correct info for the distinct a.ref1 and count fields, and produces data for the rest of the fields, but it is not actually that member's data. Is this possible to do with one query? If I want to get the top 100 referers' data, I don't want to do 100 separate queries. Please help! -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Accessing MySQL throught an Applet
I am using Tomcat version 3.2.1. I am trying to connect to a data base from an applet and I am getting the following error: 2001-04-22 05:41:00 - Ctx( /examples ): 404 R( /examples + /jsp/student/org/gjt/ mm/mysql/Driver.class + null) null My driver is in: C:\tomcat\jakarta-tomcat-3.2.1\lib My applet is in: C:\tomcat\jakarta-tomcat-3.2.1\webapps\examples\jsp\student What can I do to connect the database from the applet? Should I give some permissions? Thanks, Dana __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Src distribution of MySQL takes up a lot of space
Hi, I'm new to MySQL and I've recently installed MySQL (MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it seems to be consuming so much of my hard disk space. Is this normal? I'm wondering if anyone encountered this problem before or can advise wat I can do abt it? Thanks, Neo - 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: french characters
i doubled checked things, the problem is in the database server french characters are not accepted as is, my sql converts them to , or ? any solution for this?? At 14:06 22/04/01 +0300, you wrote: In order to see french characters you have to put in your php4/html page header the line: META http-equiv="Content-Type" content="text/html; charset=iso-8859-2" Put this line in all your pages that writing or reading from mysql server. I'm not sure about iso code - try to find your language code... Original massege: -- hi, i'm running mysql server version 3.23.33 on a win98 machine using the following characterset : latin1 i have the following problem when i enter french characters like or ... into the database using php4 scripts they are improperly recorded and returned like ? or , what i want to know is what's the reason for this? bad character set? (in which reason how to change it and which one to choose?) is PHP responsible for this? --Tamar Klein - 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
Connecting to mysql as root
Hi, I have got a problem while connecting to MySQL. While I am trying to connect to mysql it shows an error 'Acces denied for user [EMAIL PROTECTED] (USING PASSWORD : NO), but mysql server is still running. I have written a CGI program using PERL to connect to the mysql database. Using this program I am able to connect to the database and get the results. For connecting I have given the user as root and no password in the PERL scipt. Is there any way to connect to the database in the normal way, I mean from the shell ? Thank You Rajeev Ramanujan
Generic questions
Where may I find more detail information about MySQL DBA? How MySQL handle very large table (10,000,000 records)? How can I give direction where store data files? example: /var/lib/mysql | MYDATABASE | SPACE1 (/dev/sda3) | SPACE2 (/dev/sdb1) | --- SPACE3 (/dev/sdc2) Is it possible specify size and location of designated data files for a specific tables (like in Oracle create a table space and give a location of datafiles)? What are MySQL limits? All the questions relate to MySQL on Linux. Thanks, AMJ
Re: french characters
There are probably several changes to be made... 1- store characters in 'binary' fields and not text or char fields; 2- convert them into html entities before sending to the client (e.g. à is converted to agrave;). most languages can do it easily; 3- include charset as outlined previously, possibly adding the language extension as suggested (fr) in order to make it even more friendly to your users. Regards Jose Carlos i doubled checked things, the problem is in the database server french characters are not accepted as is, my sql converts them to , or ? any solution for this?? At 14:06 22/04/01 +0300, you wrote: In order to see french characters you have to put in your php4/html page header the line: META http-equiv=Content-Type content=text/html; charset=iso-8859-2 Put this line in all your pages that writing or reading from mysql server. I'm not sure about iso code - try to find your language code... Original massege: -- hi, i'm running mysql server version 3.23.33 on a win98 machine using the following characterset : latin1 i have the following problem when i enter french characters like à or é... into the database using php4 scripts they are improperly recorded and returned like ? or , what i want to know is what's the reason for this? bad character set? (in which reason how to change it and which one to choose?) is ¨PHP responsible for this? --Tamar Klein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Information Technique
j'ai eu le meme probleme mais en environnement de développement, ce que je sait c'est que ca dépend du characterset de votre base de donnée faut demander à votre hebergeur le characterset (dans les environnement variables) du serveur mysql ou votre base est hebergée At 23:33 21/04/01 +0200, you wrote: Salut Mr/Mme, J'ai une question précise : Comment coder les caractères spéciaux (de type à, é,..) dans une BDD MySql Le problème c'est que j'ai developpé avec JSP un site en utilisant le Système d'exploitation Windows (les essais étaient positifs). Lors de l'hébergement, (Sur adgraphix) les caractères spéciaux ne sont pas insérés correctement dans la BDD Par exemple à devient ? J'espère avoir une réponse, même si négative Merci ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling Errors
I get the following error when i type make. Don't have the slightest clue :/ thanks in advance.. l,/usr/local/mysql/lib/mysql creating thread_test make[2]: Leaving directory `/usr/local/mysql-3.23.37/client' Making all in strings make[2]: Entering directory `/usr/local/mysql-3.23.37/strings' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include-O3 -DDBUG_O FF -c strxmov.c In file included from /usr/include/bits/posix1_lim.h:126, from /usr/include/limits.h:30, from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/include/limits.h:117, from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/include/syslimits.h:7, from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/include/limits.h:11, from ../include/global.h:166, from strxmov.c:16: /usr/include/bits/local_lim.h:43: warning: `PTHREAD_DESTRUCTOR_ITERATIONS' redefined /usr/include/pthread.h:60: warning: this is the location of the previous definition In file included from /usr/include/unistd.h:175, from ../include/global.h:192, from strxmov.c:16: /usr/include/bits/posix_opt.h:76: warning: `_POSIX_THREADS' redefined /usr/include/pthread.h:39: warning: this is the location of the previous definition /usr/include/bits/posix_opt.h:83: warning: `_POSIX_THREAD_PRIORITY_SCHEDULING' redefined /usr/include/pthread.h:42: warning: this is the location of the previous definition In file included from ../include/global.h:94, from strxmov.c:16: /usr/include/pthread.h:65: warning: redefinition of `pthread_t' /usr/include/bits/pthreadtypes.h:120: warning: `pthread_t' previously declared here /usr/include/pthread.h:68: warning: redefinition of `_pthread_descr' /usr/include/bits/pthreadtypes.h:34: warning: `_pthread_descr' previously declared here /usr/include/pthread.h:83: conflicting types for `pthread_mutex_t' /usr/include/bits/pthreadtypes.h:82: previous declaration of `pthread_mutex_t' /usr/include/pthread.h:93: conflicting types for `pthread_cond_t' /usr/include/bits/pthreadtypes.h:59: previous declaration of `pthread_cond_t' /usr/include/pthread.h:120: conflicting types for `pthread_attr_t' /usr/include/bits/pthreadtypes.h:51: previous declaration of `pthread_attr_t' /usr/include/pthread.h:130: conflicting types for `pthread_mutexattr_t' /usr/include/bits/pthreadtypes.h:89: previous declaration of `pthread_mutexattr_t' /usr/include/pthread.h:134: conflicting types for `pthread_condattr_t' /usr/include/bits/pthreadtypes.h:66: previous declaration of `pthread_condattr_t' /usr/include/pthread.h:138: warning: redefinition of `pthread_key_t' /usr/include/bits/pthreadtypes.h:69: warning: `pthread_key_t' previously declared here /usr/include/pthread.h:142: warning: redefinition of `pthread_once_t' /usr/include/bits/pthreadtypes.h:93: warning: `pthread_once_t' previously declared here make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.37/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.37' make: *** [all-recursive-am] Error 2 - 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
purpose of groupadd and useradd
Hi Everybody! Installing Mysql on a sparc sun solaris 2.7 machine. The manual from msyql.com mentions adding user and group. What's the purpose of this? Thanks for your help! __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Bug in the SET type when using 1..64 as values, 63 is ok
Description:
Hi,
I noticed this when making a set called groups with 64 values from 1 to 64.
When inserting or updating the table with a numeric value ex 15 (should set
value 1-4),
select * from whatever doesn't show anything in that colum (not even NULL). If
using
1 to 63 it works.. 0 to 63 doesn't. 0 to 62 and Z doesn't.
I'm not on the list, so the bug might already be reported (didn't find it when
searching tho),
I'm not a guru, so I might have done something wrong (sorry;-), and please cc
replies to me ;-)
Thanks for a great product!
How-To-Repeat:
create table settest (
id int,
s1 set('1','2','3','4'),
s2
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63'),
s3
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'));
insert into settest values (1,15,15,15);
select * from settest;
Fix:
Only use 63 fields ;-)
Submitter-Id: submitter ID
Originator:Magnus Espeland
Organization:
MySQL support: none
Synopsis: Bug in the SET type with 64 entries
Severity: non-critical
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.23.37 (Official MySQL RPM)
Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.37
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 hours 40 min 50 sec
Threads: 2 Questions: 158 Slow queries: 0 Opens: 38 Flush tables: 1 Open tables:
19 Queries per second avg: 0.003
Environment:
System: Linux kelso 2.2.16-3 #1 Mon Jun 19 18:49:25 EDT 2000 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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Dec 9 08:09 /lib/libc.so.6 - libc-2.1.3.so
-rwxr-xr-x1 root root 4101836 Sep 6 2000 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20273284 Sep 6 2000 /usr/lib/libc.a
-rw-r--r--1 root root 178 Sep 6 2000 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thanks for: Outer and left join definition
Hello, I just wanted to thank everybody who helped me to understand the topic below. I am going to unsubscribe from this list now, so please address any further message, if any, to: [EMAIL PROTECTED] Thank you for your time Marco On 2001/04/14 20:37:15 +0100, M. Fioretti wrote: Hello, I am a translator with quite a good knowledge of programming and of HTML/CGI/Perl/Apache and many other web related topics. I am translating part of a book on PHP and, for the reasons above, I have had no problems so far. I am having problems however, in translating a short section where, discussing interaction with MySQL is discussed, the terms left join and outer join are mentioned. I would be really grateful to whoever could explain to me, in non technical English, what the two terms above mean, so that I can complete the translation. Thank you in advance, Marco Fioretti - 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
