Problem

Hi, I've downloaded mysql 3.23.46 version and currenlty runnig solaris 2.8 relase 10/00 on intel platform. I'm getting the following error during the ./configure stage in creating my makefile. checking size of char... 0 configure: error: No size for char type. A likely cause for this co

Re: Can this be done?

How about UPDATE myTable SET DueField = 0, StatusField = if(StatusField='O', 'C', StatusField) WHERE PrimaryKeyField = 'XYZXYZ' See http://www.mysql.com/doc/C/o/Control_flow_functions.html for more info on IF() function. -steve At 12:41 P

Re: libmysqlclient documentation project

On Saturday 08 December 2001 09:01 pm, Colin Faber wrote: > Is anyone else interested in documenting libmysqlclient? Just a basic > set of function guidelines would be nice. The public API is documented in our manual... -- MySQL Development Team For technical support contracts, visit https://or

Re: Random

At 3:19 PM -0800 12/8/01, Rob@TH wrote: >Hmm still nothing :/ >Any other possibilities? The suggestion offered below is a workaround that seems logical given the lack of ORDER BY RAND() prior to MySQL 3.23. Unfortunately, it doesn't work due to the behavior of the optimizer in pre-3.23 versions.

Re: Join

Thank you for that , I just needed somewhere to start from and am new to doing something like this. -Original Message- From: Neil Zanella <[EMAIL PROTECTED]> To: "Barry.J.Rumsey" <[EMAIL PROTECTED]> Date: Sun, 9 Dec 2001 00:29:40 -0330 (NST) Subject: Re: Join > > Before you proceed I w

libmysqlclient documentation project

Is anyone else interested in documenting libmysqlclient? Just a basic set of function guidelines would be nice. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php

Re: Join

Before you proceed I would advise you to revise your relational model. For instance why do you have both id and artistid in both tables? Can more than one artist sing or participate in the production of the same song? If yes then your database should probably look like: Artists(artist_id, artist

Join

I have a database with two tables: table1 id, artistid, artist table2 id, artistid, songtitle What I would like to know is how do I join these two. artistid in both of them have the same value. What I'm after in the end is to be able to search by artist and return a list of songtitles from that

RE: compile errors

Still not compiling. New issue now... # rpm -q gcc gcc-3.1-0.10 ./configure --cache-file=config.cache --with-mysqld-user=mysql --localstatedir=/usr/local/mysql/var --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/lock/mysql.sock --without-berkeley-db --without-bench --enable-sh

Re: Random

On Sunday 09 December 2001 07:19, [EMAIL PROTECTED] wrote: > Hmm still nothing :/ > Any other possibilities? > > Rob > - Original Message - > From: "Kodrik" <[EMAIL PROTECTED]> > To: "Rob@TH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Saturday, December 08, 2001 8:45 AM > Subject: Re

Re: From Oracle to the MySQL Database Server

Hi Tony, - Original Message - From: "Tony Buckley" <[EMAIL PROTECTED]> > Coming from an Oracle background, I started off hating mySQL. So far, I > have only 'played' with it, but now have enough confidence to start using it > for real. It is super fast and my test loads (as much as I

Re: HOW TO : SQL Request in a file

At 7:39 PM +0100 12/8/01, Fred Taurus wrote: >Hello > >Is it possible to put the result of a Mysql request in a file > >and how to do this ? > >I try > >mysql >SELECT name from table where name like 'B%'; > file.txt > >but error ! > >Thanks for your help > >Frederic mysql> \T query.out Logging to

Re: specific command or mySQL++ command

At 6:55 PM -0500 12/8/01, Mike Gleason Jr Couturier wrote: >Hello list ! > >Is there a command to know the current database name >the user is using ... > See http://www.mysql.com/doc/M/i/Miscellaneous_functions.html >Or in mySQL++, is there a way to know the current database >the u

Re: adding more data to a field

Rob: I assume you are using something like PHP as a front-end. I think you would be best to SELECT the desired field, append the new data then UPDATE the database row using SET xx WHERE xx etc. Gerald Jensen - Original Message - From: "Rob@TH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

adding more data to a field

Hi all, Is it possible to add more data to a field in mysql without deleting other data in that same field? Lets say I have field called info. I have entered data into it by a form. Now when I return to the form I want to add more info to it without deleting all the existing data. Hmmm Rob -

specific command or mySQL++ command

Hello list ! Is there a command to know the current database name the user is using ... Or in mySQL++, is there a way to know the current database the user is using ? Thanks ! - Before posting, please check: http://www.m

Re: Input from those of you with LARGE MySql databases

Well, I can't currently link you to the systems I'm mentioning, but we have performed several restore's from dumps in the last several weeks on my current project (due to some really messed up hardware). Considering the fact that the db's are a little over 20gb, I consider them pretty large, a

Input from those of you with LARGE MySql databases

Thanks Richard and you others for good input concerning "Annoying article", I myself have nothing but good experience from using the MySql database but reading articles like this one and another one on the same web talking about "when you outgrow MySql, then you must change to the more advanced d

First Question

This is my first question to the list. Anybody know of a condensed index/glossary of SQL keywords that MySQL ver. 3.22.19 uses? Neo-Genus Multimedia Studios Boyd White Database Engineer [EMAIL PROTECTED] (903)731-9644 - Before

mysql@lists.mysql.com

Dear Mike, I recommend that you 1. stop waiting for response from the user group 2. 'find' every occurance of *MySQL* in you machine 3. Delete it. 4. download the latest version 5. attempt to rpm -inh the new version 6. upon failure, go back to using MS Access and windoz Mike --- Mike Willia

Re: Random

Rob@TH wrote: > Hmm still nothing :/ > Any other possibilities? [ Selecting a random entry from a database ] Generally this is a hard problem. Ordering by rand() is really wasteful because the DB has to select *all* entries, order them, and then pick one. There are more efficient solutions a

Latin-2

Hi: Just a short Q: - if I install MySQL through rpm is it possible with any sort of postintallation to change the code page e.g. from Latin-1 to Latin-2. Thanx and bye. Bojan -- ~~~ Bojan IVANCIC Ljubljana, SLOVENIA [EMAIL PROTECTED] ~~

Re: Annoying article about MySql

Arjen, "Arjen G. Lentz" wrote: > Hi, > Thanks for the great reply! > > - Original Message - > From: "Richard S. Huntrods" <[EMAIL PROTECTED]> > > > Basically, the "mysqldump" output is missing the "use xxx" command to > > change to the target database. I have a perl script that does t

Re: Random

Hmm still nothing :/ Any other possibilities? Rob - Original Message - From: "Kodrik" <[EMAIL PROTECTED]> To: "Rob@TH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 08, 2001 8:45 AM Subject: Re: Random > Try > > ("select field 1, field2, field3, rand() as rnd > wher

DELETE with cross table WHERE condition

Hi, I have to port an SQL expression like DELETE FROM TableA FROM TableB WHERE TableA.ID = TableB.IDA AND TableB.IDB=42 from another SQL dialect to MySQL. The twice "FROM" is no mistake, it's done to declare "TableB" for the WHERE expression. In (some) other SQL dialects this is possible/lega

[PERFORMANCE] Wrong flags in recent MySQL/InnoDB binaries on Windows cause slow performance

Hi! We just found out that recent MySQL AB binaries on Windows have UNIV_SYNC_DEBUG defined in univ.i. That makes InnoDB a lot, maybe 10 times, slower than the normal version. Miguel is right now compiling new binaries where the flag is set right. Thus if you have seen high CPU usage on Windows,

Re: Annoying article about MySql

> > I used Oracle8i before (under very heavy load) and did not have any problems > there. I am now using MySql under not so heavy load and have not yet had any > problems with it, but just want to be prepared when and if they come along. > Oracle 8i rel 3 enterprise edition - 28,000 pounds sterl

Re: HOW TO : SQL Request in a file

Check out the 'INTO OUTFILE' portion of the 'SELECT' command: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -rh >Hello > >Is it possible to put the result of a Mysql request in a file > >and how to do this ? > >I try > >mysql >SELECT name from table where name

HOW TO : SQL Request in a file

Hello Is it possible to put the result of a Mysql request in a file and how to do this ? I try mysql >SELECT name from table where name like 'B%'; > file.txt but error ! Thanks for your help Frederic - Before posting, pl

Re: Annoying article about MySql

Hi, - Original Message - From: "Richard S. Huntrods" <[EMAIL PROTECTED]> > Basically, the "mysqldump" output is missing the "use xxx" command to > change to the target database. I have a perl script that does that (and > extracts the table defs to another file for documentation). Have

Re: are my queries bloated?

Hi Erik, - Original Message - From: "Erik Price" <[EMAIL PROTECTED]> > I see. If I mentally apply this advice to the rest of my database, it > seems that I should index (or apply a prefix index) to any column that > holds search criteria -- such as files.file_name or > subprojectweb.su

join & multi

Can anyone tell me where I could find a good tutorials on join & multi select queries from a database Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Random

Try ("select field 1, field2, field3, rand() as rnd where blah blah blah order by rnd limit 1") On Saturday 08 December 2001 10:35 am, [EMAIL PROTECTED] wrote: > Hi, > > I am trying to pull up one random name in mysql 3.22.21 but not having much > luck. > Here is what I have done: > $select=$

Re: Annoying article about MySql

Ingvar, I have not used mysql data dumps directly to restore my databases, but I take the mysqldump output and massage them a bit, then use them for restores. Basically, the "mysqldump" output is missing the "use xxx" command to change to the target database. I have a perl script that does that

Re: Packet is Larger than max_allowed_packet from server configuration

You're using a _very_ old version of the MM.MySQL driver. This problem has been fixed quite awhile ago. Please upgrade to the latest driver, which is 2.0.8 available from http://mmmysql.sourceforge.net/ -Mark > > Chris Stark wrote: > > > > > > Hi, > > > > > > I am having a problem with t

Random

Hi, I am trying to pull up one random name in mysql 3.22.21 but not having much luck. Here is what I have done: $select=$dbh->prepare("select * from $thetable where url is not null order by rand() limit 1"); I have tried everything, but nothing seems to work. Can anyone help. Rob -

Can't start up MySql

Couldn't find answer to this question anywhere. A newbie OSX and MySql question: I installed MySql through Fink but now that I try to start up I type "mysqld" at the prompt, but all I get is this: mysqld: Can't change dir to '/sw/var/mysql/' (Errcode: 13) 011208 16:11:38 Aborting 011208 16:1

mysqladmin does not install

I installed MySQL-3.23.26-1.i386.rpm and MySQL-client-3.23.26-1.i386.rpm on RedHat 7.1, but for some reason mysqladmin does not show up. I have removed it and reinstalled, but it is not there. Any ideas how to resolve this? Raymond --

Can't install mysql on RedHat-7.2.

Dear sir, I used mysql-3.23.46 running on RedHat-7.2. When I used command below. ./configure --prefix=/usr/local/mysql --with-charset=tis620 It has messages below. checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any

Re: innodb won't allocate the memory i ask it to

Yeh I forgot to originally state that I was using freebsd. You were correct, freebsd is compiled by default to not allow processes bigger than roughly 500megs. I recompiled the kernel, changing the limit to 1.5 gigs and now it runs fine using all my memory. For anyone else who needs the howto for

Thumbs Plus! and MySQL

Hi all, Just browsing through the windows application Thumbs Plus! and I see it can be linked via ODBC to external database servers. Seeing that all my other databases are there already I can see and opportunity to share some information. Is there anyone here with experience of using MySQL as th

Re: Help files??

Mike Copeland writes: > Greetings! > > I am new to MySQL. How do I link the help file (*.cnf) to MySQLGUI? > I read the readme files, not sure where to put the *.cnf so it is in the > path for MySQLGUI. Any help you can give me would be greatly appreciated. > > (I am learning development in PHP,

Annoying article about MySql

I was just reading an annoying article from a user who was moving from MySql to Postgres because of stability problems and because of problems restoring "large" MySql data-dumps. I checked his site and it does not have the appearance of a very heavy loaded site so I am not sure what he means by la

RE: innodb won't allocate the memory i ask it to

If you are running FreeBSD, there is an inner limit, which doesn't allow malloc() calls greater then 500MB. You need to reconfigure the kernel sources and recompile (or change your InnoDB parameters to use less then 500MB of RAM). Chris Schreiber -Original Message- From: Heikki Tuuri [m

Re: innodb won't allocate the memory i ask it to

Rich, >I have a system with 1gig of ram and i am trying to get the innodb buffer to >be about 750megs. Whenever I set the value in the database config file it >won't start with an error along the lines of, > >011207 21:02:42 mysqld started >InnoDB: Fatal error: cannot allocate 67108864 bytes of