One shot bug report

2001-03-06 Thread szii
The Makefile generated by v3.23.33 for BDB 3.2.9a has a line which is incorrect. ./configure --with-raid In db-3.2.9a/build_unix/Makefile --snip install: all install_include install_lib install_utility install_docs --end snip (it tries to execute install_include as a command since it's on a

Re: turn of column headings

2001-03-06 Thread Basil Hussain
Hi, > i am a novice, so bear with this rather trivial question. > how do i turn off the column-headers for select statements in mysql?? > > couldn't find any help with the online manual. If you are talking about when using the MySQL command line client, then it's simple. You just need to start

Re: Perl/mysql.

2001-03-06 Thread Gerald L. Clark
N Sikkandar Dulkarnai wrote: > > Hello there, > > I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How >do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some >one can send some basic structure of connecting into sql using perl and

Re: configure can't find LinuxThreads

2001-03-06 Thread Gerald L. Clark
That is an ancient version of Linux. [EMAIL PROTECTED] wrote: > > >Description: >When running ./configure it can't find LinuxThreads. >Environment: Linux 2.0.35 > downloaded and expanded LinuxThreads-2.1.3.tar.gz. > It seems the tarball do not include pthr

Off Topic Perl Mysql modules install problem

2001-03-06 Thread Curtis Maurand
Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L

load_file

2001-03-06 Thread Hesham Anan
Hi I have been trying to use load_file to store a file as a BLOB object in a database table but it always returns NULL although I have made sure that the path is correct and I have the appropriate priviliges. Any hints how to use load_file correctly ? =

RE: BDB tables on Linux

2001-03-06 Thread Mehalick, Richard RE SSI-GRAX
You must compile from source to get BDB support into mysql. Make sure you download the appropriate BDB source and place it in the mysql directory. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5

3.22.25 and RAND()

2001-03-06 Thread christopher sagayam
SELECT * from tablename ORDER BY RAND() does not work in 3.22.25 what is the equivalent ?? It works great in later versions chris _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

Re: Match Records

2001-03-06 Thread Neelesh
Hello , Can you please tell me how to use transaction in mysql. I am using mysql version 3.23.32. I want to use EJB over it , it is giving problem of transaction as it is not supporting ENTITY with CMP. Thanks , Neelesh - Original Message - From: "Bob Hall" <[EMAIL PROTECTED]> To: <[EM

Re: Default values

2001-03-06 Thread MikeBlezien
On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark" <[EMAIL PROTECTED]> wrote: Gerald, >>Try giving a number instead of a string as a default for an int. >> Not sure I follow, it is a number?? >>"MikeBlezien" wrote: >>> >>> Hello All, >>> >>> I've created a table(using MySQL 3.23.33),

troubles with joining list

2001-03-06 Thread Network
I don't see an address for the list owner so I'm mailing this here in hope of getting help. Why is the connection constantly resetting and not allowing me to join the list? This mail also serves as a test to see if I can post to the list without joining via [EMAIL PROTECTED] Mar 6 04:34:49 Im

Fwd: DBD::mysql

2001-03-06 Thread John Tsangaris
Tried sending this once and it didn't go through. - I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several

Searching for misses

2001-03-06 Thread alec . cawley
I have a couple of SQL queries, both of which involve searching for misses rather than searching for hits. Would anybody be kind enough take a little time to assist me? Suppose I have a table of products, a table of components, and a table which says which components are used in which products.

Re: trying to install on RedHat 7.0 and need help

2001-03-06 Thread Irmund Thum
Charles L Hagen schrieb: > > mysqld dead but subsys locked > it's successfully installed and running, but not really killed killall mysqld and start again you shouldn't post those long nonsense listings -- http://it97.dyn.dhs.org -- IrmundThum -

Use of certain keywords in SQL statements problematic

2001-03-06 Thread eric
>Description: We have just upgraded from 3.22.26a to 3.23.33. One table has a column name "FullText". However, any SQL statements (either using PHP or the command line interface) that directly reference the column will cause an SQL error, like: ---

Question regarding query optimising with between

2001-03-06 Thread Christian Hammers
Hello I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end between '2001-01-01' and '2001-04-01' affects just one

Re: Default values

2001-03-06 Thread Fred van Engen
On Mon, Mar 05, 2001 at 10:26:58PM -0600, MikeBlezien wrote: > Hello All, > > I've created a table(using MySQL 3.23.33), using default values: > > DROP TABLE IF EXISTS referral; > CREATE TABLE referral ( > refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, > refer_fname varchar(20) DEFAULT ''

Memory footprint

2001-03-06 Thread Simon Windsor
Hi On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16) kernel. Using top, one mysqld server uses 10MB whilst the other uses just 3MB. Both servers have identical configuaration files, the only difference is that server 1 is much busier. Can anyone explain why on

Re: MySQL License

2001-03-06 Thread Brooklyn Linux Solutions CEO
You can charge for any GPL'ed product you wish too. Ruben On 2001.03.05 22:31:41 -0500 Jeff Platzer wrote: > Maybe someone can help me out with MySQL's commercial license. > > If MySQL server has a GPL license and MySQL client libraries have LGPL > licenses, how can a paid commercial license be

[ANN] MySQL Studio v0.7 Released.

2001-03-06 Thread support
** After months of development We are proud to announce the first public version of MySQL Studio. http://dba-tools.com/ MySQL Studio provides an extremely easy to use interface to MySQL servers. A straig

problem under FreeBSD4.2-STABLE

2001-03-06 Thread Andrey Kotrekhov
Hi! Sometimes I look a problem with mysqld which load CPU. It work fine one week, two ... But ones something was happend and mysqld catch all CPU time. I don't know why. Mysqld continue work, but CPU load increase :( It catch 99% CPU I look in process list, kill all id, flush all tables and try a

installation problem with db-3.2.9a - makefile is not correct!

2001-03-06 Thread Craig Ian Dewick
Hi, I'm progressing through the install of mysql-3.23.33 with the db-3.2.9a package extracted and built within the mysql source tree, but it looks like the creation of ./db-3.2.9a/build_unix/Makefile hasn't worked correctly... This is what I get when I run 'make install' from the top-level of t

zombie_process

2001-03-06 Thread Littletree
I tune Mysql:key_buffer=64M,table_cache=256,sort_buffer=4M,record_buffer=1M,max_connections=200 I have RAM 516M,CPU 651MHz,many table,many connect from client. I use MySQL 3.23.25. I have problem . In system have zombie process which happen from perl script on apache server( example: index.pl(