Re: Selecting multiple rows based on array contents

2001-07-15 Thread Jeff S Wheeler
[This is an email copy of a Usenet post to "mailing.database.mysql"] How many authors are likely to be passed to this subroutine? As long as it is some ``reasonable'' number, I suggest you construct a query using IN(...). If you had a *huge* number of authors to check, you might resort to a JOI

Re: Version 3.22.32 Source to upgrade??

2001-07-15 Thread Jeremy Zawodny
On Mon, Jul 16, 2001 at 01:17:02PM -0400, R Talbot wrote: > As I had to compile my install and can't determine if I can upgrade > for Caldera Install. I can only locate source for 3.23.39 or 3.22.32 > and I am not sure if 3.23.39 will compile properly on my 2.2.10 > kernal. It should. Give it a

Re: your site

2001-07-15 Thread mysql
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your

MySQL-Front 1.22 available

2001-07-15 Thread Ansgar Becker
Hi *.*, MySQL Front 1.22 is available - download at http://anse.de/mysqlfront/download.php Changes: 1.22: - Added option in preferences-dialog: "Show native field-contents for Text-, BLOB- and Date-Fields" - Changed "Default Column-width in datagrids" to "Maximium column-width", which mean

Re: Replication Drama

2001-07-15 Thread Jeremy Zawodny
On Sun, Jul 15, 2001 at 10:24:17PM +0200, Warren van der Merwe wrote: > Hi there > > I have a triangular replication setup, works like a dream That's a good word for a 3-way replication setup, thanks. I keep describing it as a ring, but it really does look more like a triangle. > In my haste I

Re: Where to find help??

2001-07-15 Thread Van
Jeff Holzfaster wrote: > > Where is a good place to find help with some basic sql? I am having a > problem getting the query results I need. Don't tell me to consult the > manual because that is the first place I turned to. I just need a real life > example of the solution to see be able to pi

mysqlbug

2001-07-15 Thread xg
mysql£¬ÄúºÃ£¡ СµÜÔÚsco openserver5Öа²×°Mysqlʱ£¬³öÏֵĴíÎóÌáʾÈçÏ£º scripts/mysql_install_db: 11738 Killed scripts/mysql_install_db: 11739 Killed WARNING: Your libc libraries are not 100 % compatible with this MySQL version mysqld should work normally with the exception that host name resolvin

Meet MySQL Users & Developers at OSCON in San Diego...

2001-07-15 Thread Jeremy Zawodny
Are you coming to the Open Source Convention next week in San Diego, California? Would you like to meet fellow MySQL users and some of the MySQL developers? If so, plan to be in the room "Harbor Island II (East)" between 8pm and 10pm on Wednesday the 25th of July. There will be a BOF (Birds of

Re: Where to find help??

2001-07-15 Thread Michael Collins
At 11:52 PM -0500 7/15/01, Jeff Holzfaster wrote: >Where is a good place to find help with some basic sql? http://w3.one.net/%7Ejhoffman/sqltut.htm http://www.devshed.com/Server_Side/MySQL/Intro/ http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html For a reference book: SQ

Version 3.22.32 Source to upgrade??

2001-07-15 Thread R Talbot
I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2.4 edeskt

Where to find help??

2001-07-15 Thread Jeff Holzfaster
Where is a good place to find help with some basic sql? I am having a problem getting the query results I need. Don't tell me to consult the manual because that is the first place I turned to. I just need a real life example of the solution to see be able to pick it apart. I posted the request

RE: Client Command Line interface "auto" compellation 3.23.39

2001-07-15 Thread Paul DuBois
At 1:32 PM +1000 7/16/01, Noel Clarkson wrote: > >> > >> >interestingly, if I type sh I get 'show ' but if I type show >ta I >> >don't get 'show tables' which is what I would expect. >> >> Does "show tables" actually produce a list of tables, or no tables? >> On some systems, there is a bug i

Re: I am facing this error [ Urgent ]

2001-07-15 Thread Rolf Hopkins
This is a very common problem. It is documented in the manual and also in other places as Edna has already mentioned. Your php code has nothing to do with the cause of the problem. Basics: 1. Your server isn't running 2. Your paths to the socket file are incorrect. (Check php and mysql setting

RE: Client Command Line interface "auto" compellation 3.23.39

2001-07-15 Thread Noel Clarkson
> > > >interestingly, if I type sh I get 'show ' but if I type show ta I > >don't get 'show tables' which is what I would expect. > > Does "show tables" actually produce a list of tables, or no tables? > On some systems, there is a bug in glibc that prevents it from working > properly, in which

Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Alan W. Rateliff, II
On 16-Jul-01, Colin Faber said something totally profound about Re: Problems installing under solaris 2.5.1 that made me ponder... CF> You need to make sure that the gcc on your box is build on that box, CF> Using a package won't do it, most of them where compiled on greater or CF> lesser hard

Re: I am facing this error [ Urgent ]

2001-07-15 Thread Martin Cameron
Have you checked that you've got a musql server running. (ps ax|grep mysqld) On Fri, 13 Jul 2001 05:51, you wrote: > Thanks for your replies > but my problem is still there > this is the php code iam using for connecting to Database: > > $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); > > a

RE: Client Command Line interface "auto" compellation 3.23.39

2001-07-15 Thread Paul DuBois
>Yep, some things work others don't. > >if I type sh then I get 'show ' > >sel give 'select ' > >but I thought I was able to type >select * from tbl >and that this used to give me all a list of all the table names that >started with tbl (or if there was only one it would just auto complete it >of

Re: I am facing this error [ Urgent ]

2001-07-15 Thread Syed Sumair
Thanks for your replies but my problem is still there this is the php code iam using for connecting to Database: $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); and hosting infos are: Red hat linux mysql-3.23 php 4 > From the error message, I'd guess you are using RedHat distribution.

Running multiple MySQL servers on one machine

2001-07-15 Thread William Chi
Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Note also that these databases will both be replicated and there shall be multiple machines. Possibly some machi

about the "mkstemp64" in mysql3.23.39

2001-07-15 Thread gz_lian
hi, I have some question about the mysql3.23.39 in my linux686 system when I configure it neither "CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static " nor "./configure"

Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Colin Faber
You need to make sure that the gcc on your box is build on that box, Using a package won't do it, most of them where compiled on greater or lesser hardware versions than you might be running, This in turn causes the compiler it self to think that its running in cross-compile mode and mysql won

Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Martin Cameron
Shouldn't it be ./configure --prefix=/usr/local/mysql On Mon, 16 Jul 2001 12:44, you wrote: > I am trying to compile mysql by it is failing in the ./configure step. I am > running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the > following error > > ./configure -prefix=/usr/local/mys

Re: beowulfen and mysql

2001-07-15 Thread Gary Huntress
First, lets make sure we're all talking about the same thing. A general definition of data mining would be "the automated extraction of predictive information from large databases". Automated implies some sort of agent, and by its very nature the predictions are statistical (hence the large dat

empty mysql_install_db file in sol8 i386 distribution

2001-07-15 Thread Oliver Jones
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: oliver To: [EMAIL PROTECTED] Subject: empty mysql_install_db file in sol8 i386 distribution >Description: I'm running down t

RE: Client Command Line interface "auto" compellation 3.23.39

2001-07-15 Thread Noel Clarkson
Yep, some things work others don't. if I type sh then I get 'show ' sel give 'select ' but I thought I was able to type select * from tbl and that this used to give me all a list of all the table names that started with tbl (or if there was only one it would just auto complete it of course).

Re: mysql command for "which tables supported?"

2001-07-15 Thread Paul DuBois
At 4:51 PM -0700 7/15/01, Mike Wexler wrote: >I must be missing something. >Where does this tell me that this server supports "ISAM" and "MyISAM" >tables but that server supports "InnoDB", "BDB", "Isam" and "MyISAM" >tables. In that case, you want SHOW VARIABLES, which shows the table *types* sup

Problems installing under solaris 2.5.1

2001-07-15 Thread [EMAIL PROTECTED]
I am trying to compile mysql by it is failing in the ./configure step. I am running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the following error ./configure -prefix=/usr/local/mysql . . loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c ch

Re: MySQL Variables

2001-07-15 Thread Michael Collins
At 6:12 PM -0500 7/15/01, Paul DuBois wrote: >Sounds like that should do it. (O'Reilly also has a book "Using csh & tcsh" Actually, after having problems finding this file I started looking for a reference to buy and came across "Using csh & tcsh" and did recognize the author. This book has a

beowulfen and mysql

2001-07-15 Thread Joey Kelly
Howdy. My company needs to implement a data mining setup. I am building a cluster using dual athlons and perhaps firewire instead of 100baseTX. I need to find out as much as I can from those who have done mysql on beowulfen. Please contact me at [EMAIL PROTECTED] Thanks :) +++ Joey Kelly

beowulfen and mysql

2001-07-15 Thread Joey Kelly
Howdy. My company needs to implement a data mining setup. I am building a cluster using dual athlons and perhaps firewire instead of 100baseTX. I need to find out as much as I can from those who have done mysql on beowulfen. Please contact me at [EMAIL PROTECTED] Thanks :) +++ Joey Kelly

Re: mysql command for "which tables supported?"

2001-07-15 Thread Mike Wexler
I must be missing something. Where does this tell me that this server supports "ISAM" and "MyISAM" tables but that server supports "InnoDB", "BDB", "Isam" and "MyISAM" tables. Paul DuBois wrote: > > At 2:05 PM -0700 7/15/01, Ken Sommers wrote: > >Hello, > > Is there a command to see which tabl

Re: mysql.org

2001-07-15 Thread Robert John Hall
On Sat, Jul 14, 2001 at 07:59:14AM -0700, Michael Collins wrote: Thank you, Michael, for accidentally posting this. :) > At 3:10 AM -0400 7/14/01, Britt Johnston wrote: > >Well, what a mess. It is regretable that this legal issue > >needs to be aired so publically that was certainly not my > >p

Re: mysql command for "which tables supported?"

2001-07-15 Thread Paul DuBois
At 2:05 PM -0700 7/15/01, Ken Sommers wrote: >Hello, > Is there a command to see which tables are supported by mysql from the >mysql> >prompt? >when I am telneted into my remote server? Yes, it's in the MySQL Reference Manual under "SHOW TABLES". :-) http://www.mysql.com/doc/S/H/SHOW.html > >K

[ANN] MySQLConnect for 4D 1.0 Demo

2001-07-15 Thread spinel
FOR IMMEDIATE RELEASE Exenevex, SA ( http://www.exenevex.com ) announces release of MySQLConnect for 4D 1.0 demo version Paris, France - Monday, July 16th, 2001: Exenevex, SA, today announced the release of demo version of MySQLConnect for 4D 1.0 (MacOS & Windows). MySQLConnect for 4D is a 4th

Re: MySQL Variables

2001-07-15 Thread Paul DuBois
At 12:39 PM -0700 7/15/01, Michael Collins wrote: >At 11:09 AM -0700 7/15/01, Michael Collins wrote: >>At 1:47 PM -0500 7/14/01, Paul DuBois wrote: >>Any solution I've tried using the LassoMySQL/var/my.cnf or >>~/.my.cnf files affect both the special installation as well as >>the sta

RE: mysql command for "which tables supported?"

2001-07-15 Thread Carsten H. Pedersen
> Hello, > Is there a command to see which tables are supported by mysql from the > mysql> > prompt? > when I am telneted into my remote server? > mysql> SHOW VARIABLES; - look at lines starting with "have_" ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL

Re: Heap Tables

2001-07-15 Thread Alexander Skwar
So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 : > Hi, > > Definitely yes :) > But the table structure won't be lost. Thanks to all who replied! filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage:

RE: Heap Tables

2001-07-15 Thread Carsten H. Pedersen
> Hello > > When I store some data in a table of type Heap, this data will be lost > when the server is shutdown (and later restarted), won't it? Correct. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --

mysql command for "which tables supported?"

2001-07-15 Thread Ken Sommers
Hello, Is there a command to see which tables are supported by mysql from the mysql> prompt? when I am telneted into my remote server? Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Heap Tables

2001-07-15 Thread Alexander Skwar
Hello When I store some data in a table of type Heap, this data will be lost when the server is shutdown (and later restarted), won't it? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://ww

Replication Drama

2001-07-15 Thread Warren van der Merwe
Hi there I have a triangular replication setup, works like a dream In my haste I went and created a table in Site A's database, and then dialled into Site B and created the table. As yet I haven't done a slave start to start the replication process because I caught onto my vital mistake. i.e. Th

Re[2]: mysql.org

2001-07-15 Thread Mark A. Chalkley
On Saturday, July 14, 2001, 9:25:51 PM, you wrote: JN> GPL violation or not, part of my decisions are always based on JN> morals (hard to find these days). Anyone trying to capture an JN> audience using anothers name is un-ethical and un-moral. My JN> business decision will be made with this i

RE: mysql.org

2001-07-15 Thread Carsten H. Pedersen
> 1) While they do point out that they are not affliated, and > provide a link to MySQL AB, they do not state why this is > relevant, or why someone might WANT to go to MySQL AB. Hmmm.. The NuSphere people may not be saying very much on this list, but they're certainly listening in on what'

Re: MySQL Variables

2001-07-15 Thread Michael Collins
At 11:09 AM -0700 7/15/01, Michael Collins wrote: >At 1:47 PM -0500 7/14/01, Paul DuBois wrote: >Any solution I've tried using the LassoMySQL/var/my.cnf or >~/.my.cnf files affect both the special installation as well as >the standard MySQL installation. I find I will always get the

Re[4]: Mysql++ and Gcc 3.0 compile problems

2001-07-15 Thread Alexandre BAUMEISTER
>> Do someone see improvements compiling Mysql with Gcc 3.0 ? SM> What improvements would you like to see in the compiled library ?? In fact I just wanted to know if there is any advantage to use Gcc 3.0 for compiling Mysql. Regards, Alex. -

re: mysql.org

2001-07-15 Thread Thomas J Keller
Well, I have gone and looked more closely at mysql.org. I am forced to confess that I find several disheartening "features" at this site. I am unwilling at this juncture to typify these issues as deliberate or ill-intentioned, but I will say that NuSphere needs to make a concerted, immediate

Re[2]: Problem inserting array of rows

2001-07-15 Thread Werner Stuerenburg
> Now the problem is it only inserts one row into the table, when there should be > more than one row inserted. Of course it does, you have to enclose the insert statement into your for loop. -- Herzlich Werner Stuerenburg _ ISIS Ve

Re: MySQL Variables

2001-07-15 Thread Michael Collins
At 1:47 PM -0500 7/14/01, Paul DuBois wrote: Any solution I've tried using the LassoMySQL/var/my.cnf or ~/.my.cnf files affect both the special installation as well as the standard MySQL installation. I find I will always get the standard port. >>> >>>Settings in the [client] gr

Re: Somebody kindly get me off this list

2001-07-15 Thread Matthias Urlichs
At 15:17 -0700 2010-05-02, Angela Neff wrote: >I have tried numerous methods as instructed in the mySQL listerserv >e-mail to get off this list >but am still on it. Can somebody help me out? I got 779 e-mails today. Set your date correctly and try again..! -- Matthias Urlichs

RE: innobase > 4gb rows

2001-07-15 Thread Sander Pilon
> > Note that the new BLOB code is not well tested yet, though > I have not received any bug reports for it. It may be best to > experiment first with pieces of your table instead of doing > the whole, maybe several hours long, conversion at once. > Can you tell us a bit more about the BLOB

Re: mysql.org

2001-07-15 Thread Robert Alexander
Monty et al and fellow list people, I've been following this thread with interest for the last couple days, have read all the postings (unfortunate flames included), and my opinion has generally been: "well, there's been an unfortunate break down in communication between MySQL and NuSphere, I'

Re: innobase > 4gb rows

2001-07-15 Thread Heikki Tuuri
Hi! I am back from holiday! I guess using SELECT INTO OUTFILE (= mysqldump) and LOAD FROM INFILE is as fast as converting InnoDB->MyISAM->InnoDB. I assume Ryan has a file system with > 2 GB files? The outfile or the MyISAM table will be very big. If you do not have > 2 GB files then you have to

changing mysql prompt

2001-07-15 Thread Michael Widenius
Hi! Nissim> Hi , is there a way to change the default mysql prompt to have the current Nissim> GMT time embedded in the mysql command line prompt and look something Nissim> like this Nissim> (and also have the time increase every time the carriage return is pressed) Nissim> [GMT:193/12:13:45] M

Re: Parallel Databases

2001-07-15 Thread Michael Widenius
Hi! >> I'm writing in as to how I can contribute in the development in Parallel >> databasing. I understand MySQL currently supports replications which is a >> nice way of keeping live backups of a mysql server, however is hardly the >> "preferred" method when dealing with load-balancing and r

Re: Problem inserting array of rows

2001-07-15 Thread David
Hi, I was missing two single quotes in the $val line after $id[$i] and before songname : Here is the corrected code $vals .=", ('$id[$i]', '$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]')"; Now the problem is it only inserts one row into the table, when there s

Re:Replication and InnoDB

2001-07-15 Thread Heikki Tuuri
Hi! As far as I know, replication works with InnoDB and BDB, and some users have at least tested it with InnoDB. MySQL only writes complete transactions to the binlog and therefore ROLLBACK does not need to be implemented in replication. LOAD TABLE FROM MASTER does not currently work with InnoDB

Re: Slient install - Win32 Mysql

2001-07-15 Thread Gerald R. Jensen
MySQL doesn't create any Registry keys. The only registry entry that relates directly to MySQL (in addition to the one Monty's InstallShield sets so you can uninstall) is the one the Service Control Manager creates when you install the service. If you install MyODBC, you'll need to account for th

Re: mysql.org

2001-07-15 Thread Gerald R. Jensen
Just to clarify the U.S. trademark point raised here ... The fact that it is in the mail, in progress, or whatever is really immaterial. It is not at all unusual for the formal application for trademarks, service marks, patents, copyrights, etc. to come months or even years after the product's i

Re: mysql.org

2001-07-15 Thread Marten Mickos
Andy, a clarification below Andy Woolley wrote: > > I see one HUGE difference between these support sites and .net, > > in regards to .com: Every one but .net clearly state that > > this is a product of MySQL AB, tell people about and make > > very explicit links mysql.com. > The impression

Slient install - Win32 Mysql

2001-07-15 Thread Eyal Rif
Hi, I am trying to create a Mysql Install packages with other Programs (Such as apache). Does any one know what registry keys need to be updated or how can I perform a silent install of win32-mysql ? Thanks, - Before posting,

Re: How do you insert into two tables at once

2001-07-15 Thread Tonu Samuel
David wrote: > I have two tables under the one database. What is the best way to > INSERT data into both tables at once. Can I use one INSERT statement or > do I have to use two? Do those tables have exactly same tructure? If you then you do not have to insert into two table but use MERGE t

Re: Any workaround for no "union" operation?

2001-07-15 Thread John Meyer
At 02:13 PM 7/15/01 +0300, Sinisa Milivojevic wrote: >Multi-table updates should come in 4.0, while sub-selects will come in >4.1. Not to be a nag, but when will 4.x be here? > John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our pr

Re: Problem inserting array of rows

2001-07-15 Thread Dvořáček Michal
Hi, if you have 6 colums, you are inserting only 5 in table INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ') [1th ] [2nd] [3rd] [4th] [5th] i think that first apostrophe is shifted to left side should be: INSERT INTO songs VALUES (1, 'blah', ' **

Re: mysql.org

2001-07-15 Thread Andy Woolley
> I see one HUGE difference between these support sites and .net, > in regards to .com: Every one but .net clearly state that > this is a product of MySQL AB, tell people about and make > very explicit links mysql.com. The impression I get from the .org site, is that they are promoting a product

--default-character-set

2001-07-15 Thread pascal barbedor
Hi there is no UTF-8 possibility for --default-character-set mysqld starting option. How can I tell mysql to send to clients utf-8 if everything on the database is latin-1 ? if --default-character-set=UTF-8 would exists in shared/charsets, does it mean I have to recode all the content of

Problem inserting array of rows

2001-07-15 Thread David
I am trying to insert an array of rows or values from a PHP form into a MySQL database. There are six columns in the table songs: id, songname, rating, video, album_id, movie. Here is what I get when I submit the form Add songs for Record Array INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45',

Re: mysql.org

2001-07-15 Thread Marten Mickos
Guus, Thanks for your good suggestions. Some clarifications below. Guus Leeuw jr. wrote: > From: Dipl.-Inf. Guus Leeuw jr. > Date: Sun, 15 Jul 2001 03:21:32 +0200 > > -Original Message- > > From: Marten Mickos [mailto:[EMAIL PROTECTED]] > > Our interpretation is that even unde

Simple Array Question

2001-07-15 Thread Douglas Brantz
Simple question: Using multiple checkboxes and assigning the value from mysql field with. a loop showing all the data I need. I am created a form to delete selected users from database. So I loop through all the ids and this is the checkbox line. not exactly but close. print ""; in perl Now I n

Environment variables for mm.sql type 4 driver on WIndows 2000

2001-07-15 Thread The Majestic Moined Mogul
Could some one please tell me what the correct environment variable setting for the mm.mysql type 4 driver should beI can't seem to get it to work THank you

RE: mysql.org

2001-07-15 Thread Carsten H. Pedersen
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Justin Farnsworth > Sent: Sunday, July 15, 2001 4:56 AM > Hassan: > > I respectfully disagree with your suggestion that such a site > would spread confusion and give discredit to MySQL. > > I think it

Re: MySQL on OpenBSD 2.8

2001-07-15 Thread Sinisa Milivojevic
Brian E. Beck writes: > I guess I've lurked long enough. > > I am a relative newbie to MySQL (and to all things SQL, actually.) > > I am running MySQL 3.23.37 on my OpenBSD 2.8 server. (I currently support > 6 different, non-related databases on the server) > > Here is the problem... MySQL s

Re: mysql.org

2001-07-15 Thread B. van Ouwerkerk
Hi, Sorry.. can't keep my mouth shut.. A few comments on the legal matter: GPL has been spoken about more then enough here.. Trademark: If no license or agreement exists which allows nusphere to use MYSQL AB's trademark it's probably illegal. One could think of situations where it might be pe

Problem Running a Script File

2001-07-15 Thread Jeff Jeffries
Hi All, I am trying to run the following syntax on a Windows NT Box. mysql -h host -u user -pPassword < Scriptfile If this command is entered into a console window all is well (it works fine). This will also WORK if it is entered in a batch file and then run in the batch file. This command ne

How are NULL treated in stelects

2001-07-15 Thread JfkearnsSr
My dealing with other relational databases NULL is treat as an unknown. Therefore, this statement is will not provide complete informations. select * from table where column < 25. Column that are not populated or contain a NULL would not be selected. Jeff Kearns

Re: Any workaround for no "union" operation?

2001-07-15 Thread Kevin Smith
Is there no easy way to do this in the current version (3.29.39) without using a program that loops through to perform each update? Thanks, Kevin - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 15, 200

Re: Any workaround for no "union" operation?

2001-07-15 Thread Alexander Skwar
o sprach Sinisa Milivojevic am 2001-07-14 um 15:24:32 +0300: > Unions will soon come in 4.0. Yes, I know, bad question, but anyhow: How soon is 4.0 going to come? Tomorrow :), end of the month, end of the year? PS: database,sql,query,table Alexander Skwar -- How to quote: http://learn.to/quo

Re: Re[2]: Mysql++ and Gcc 3.0 compile problems

2001-07-15 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: > Do someone see improvements compiling Mysql with Gcc 3.0 ? > > Regards, > Alex. > Don't ask me. I do not have time to install 3.0 on my machine. What improvements would you like to see in the compiled library ?? -- Regards, __ ___ ___ __

Re: mysql.org

2001-07-15 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: > Michael, > > > It's years now that I use Mysql, post/read the mailing list, try to > help you solving bugs, testing new features (like InnoDB currently). > > Why ? Because I really like Mysql, GPL licence and the way you work ! > > What NuLsphere is doin

Re: Getting more than 256 connections with MySQL/Linux

2001-07-15 Thread Tonu Samuel
Alex Coke-Smyth wrote: > max_connections=300 > > basically anything over 256 ends up giving the error : > > Can't create a new thread (errno 11). If you are not out of available > memory, you can consult the manual for a possible OS-dependent bug > > after 256 connections are open. > > The

Re: what' about my current database if I reinstall mysql and my linux

2001-07-15 Thread Alexander Skwar
So sprach »Prabu Subroto« am 2001-07-15 um 01:00:17 -0700 : > Dear my beloved e-pals, Hello beloved Prabu! :) > engine...? Under which directory is my database On RedHat/Mandrake it's in /var/lib/mysql. But actually you might not need it. Have a look at mysqldump. Alexander Skwar -- How to

Re: Database Backups

2001-07-15 Thread Tonu Samuel
MikeBlezien wrote: > We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We > have about 30 customers who are currently using various dbs and was wondering if > someone could recommend or has setup some sort of automated back up system for > the db's. We use the mysqldu

Re: HELP ! Myisamchk doesn't seem to see error in my table :(

2001-07-15 Thread Tonu Samuel
Fournier Jocelyn [Presence-PC] wrote: > mysql> SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20; > >+--+-++-+-+

Re: encrition /security

2001-07-15 Thread Tonu Samuel
webmaster wrote: > I have a customer who needs to have a very secure site, more secure than > usual, he thinks that having a secure server is not enough so what kind > of security for his transactions can I offer him? we are not talking > about money transfers, his bussines is not about money

Re: Force password

2001-07-15 Thread Werner Stuerenburg
Maybe you need to restrict access through .htaccess or some other form of login-procedure. There are lots of packets out there realising user login. Sie schrieben am Montag, 16. Juli 2001, 01:26:50: > Hi guys > could someone tell me how I could force people to their enter password otherwise >d

Re: Any workaround for no "union" operation?

2001-07-15 Thread Sinisa Milivojevic
Kevin Smith writes: > Will the following be in version 4 as well? > > UPDATE table1 > SET cola = SELECT [colb] > FROM table2 > WHERE table1.id = table2.id > > And sub-selects as well? > > Thanks, > > Kevin Multi-table updates should come in 4.0, while sub-selects will come in 4.1. -- Regard

Re: what' about my current database if I reinstall mysql and my linux

2001-07-15 Thread Werner Stuerenburg
In my setting, it is /usr/local/mysql The data is at /usr/local/mysql/var Sie schrieben am Sonntag, 15. Juli 2001, 10:00:17: > Dear my beloved e-pals, > Would you like to be so kind to answer my question ? > Please.. > Where is located the database of my mysql database > engine...? Under w

Re: mysqlbug

2001-07-15 Thread Michael Ott
hallo With reference to root on 14.07 20:31: > Hello: > > When attempting to perform rpm installation I get: > > [root@...]# rpm -i MySQL-3.23.39-1.i386.rpm > error: MySQL-3.23.39-1.i386.rpm cannot be installed > first try this rpm -qa | grep mysql the original rpms have only lowercases wi

Re: problems untarring mysql under solaris

2001-07-15 Thread Colin Faber
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com "[EMAIL PROTECTED]" wrote: > > Hi all: > > I am running solaris 2.5.1 and I am having difficulties u

problems untarring mysql under solaris

2001-07-15 Thread [EMAIL PROTECTED]
Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. r

what' about my current database if I reinstall mysql and my linux

2001-07-15 Thread Prabu Subroto
Dear my beloved e-pals, Would you like to be so kind to answer my question ? Please.. Where is located the database of my mysql database engine...? Under which directory is my database located ? And which harddisk ? I want to reinstall my linux. I have more than one harddisk... I have to make