RE: laptops

thanks guys for the info! The idea of an iMac really interests me but I need something so I can do some work on our apps here at work and they are windows based and I would also like to start learning c#. Eddie -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursd

winSQLadmin stopped on Beta

To: <[EMAIL PROTECTED]> Sent: Friday, September 13, 2002 8:13 AM Subject: winadmin stopped on Beta > Hello everyone - I saw that the beta version of 4 was available and so I > uninstalled my alpha (I only footal with the database at present on my own > computer) > and put on the beta. > > > It s

Re: Hans Needs Help :D

The solution that works best with all broken rpm dependiences is to use --force --nodeps (verify with the man page). HTH, Max spam filter pass: sql,query - Before posting, please check: http://www.mysql.com/manual.php

optimizer bug in selecting fields that don´t belong to the index used by mysql

Description: Hello, I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables. I have the following table: CREATE TABLE clientes ( Cod varchar(6) NOT NULL default '', Nom varchar(40) NOT NULL default '', Nif varchar(10) NOT NULL default '',

Dependencies with MySQL-bench.rpm package

Hi. I install MySQL-3.23.52 in SuSE 8.0 with rpms packages. I could install all packages except MySQL-bench-3.23.52-1.i386.rpm. It needs MySQL-DBI-perl-bin I donwloaded Mysql-DBI-perl-bin-1.1825-1.i386.rpm (it also needs perl-DBI), but it isn'nt MySQL-DBI-perl-bin and after install it I couldn

Problem with accesing the database

Hello. I have got a problem. I'm programming in Visual Basic and when connecting to database a got this error message: RUN-TIME ERROR '-2147467259(80004005)': [TCX][MY ODBC] Can't connect ty MYSQL SERVER on 'localhost'(10055) It happens in this function: pop.ConnectionString = "Driver=My

BBC article: Intellectual Property

MySQL/Open source campaigners and 'evangelists' may be interested in BBC coverage of a report by the Commission on Intellectual Property Rights (CIPR): http://news.bbc.co.uk/1/hi/sci/tech/2253270.stm. It talks of medical, agricultural, industrial, and IT/educational disadvantages placed in front o

RE: simple query question

See http://www.innodb.com Regards, Iikka ps. The MySQL manual also offers some rough guidelines on where InnoDB excels. On Fri, 13 Sep 2002, Meidling, Keith, CTR, OSD-C3I wrote: > I've seen a lot about 'InnoDB'. What is it? > > -Original Message- > From: Weaver, Walt [mailto:[EMAIL PRO

Compiling for HP-UX

Hi to all, I´m trying to compile the MySQL sources for HP-UX, but I get this error on the first file to compile: In file included from /usr/include/sys/user.h:52, from /usr/include/sys/stream.h:53, from rlwinsize.h:45, from rltty.h:45,

RE: simple query question

I've seen a lot about 'InnoDB'. What is it? -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 4:09 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: simple query question I'd use the InnoDB table type and establish a primary key

mysql@lists.mysql.com

as far as I know you have to start safe_mysqld as root! Thomas On Fri, 13 Sep 2002 12:29:30 +0200 hans schneidhofer <[EMAIL PROTECTED]> wrote: > hi, > have a simple question of about starting mysql : > staring with a book of mysql I should start mysql as the loggedin-user, which > is my case "

mysql@lists.mysql.com

hi, have a simple question of about starting mysql : staring with a book of mysql I should start mysql as the loggedin-user, which is my case "papabaer" as follows : safe_mysqld & but trying that, I get : [papabaer@hanna papabaer]$ safe_mysqld Starting mysqld daemon with databases from /var/li

Unsure of SQL Syntax

I am working with a MySQL database and I am hoping someone can help me out with this. CREATE TABLE CLASS ( CID int(22) NOT NULL auto_increment, LOC int(11) default NULL, CLI int(8) NOT NULL default '0', TYPE tinyint(4) NOT NULL default '0', STATUS char(3) NOT NULL default '', U

Re: About the 4.1 release

Hi! - Original Message - From: "Iikka Meriläinen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, September 13, 2002 10:37 AM Subject: About the 4.1 release > Hello, > > When will the 4.1 source tree be made accessible by the public? My guess is October 31, 2002.

Re: winadmin stopped on Beta

At 08:13 13/9/2002 +0100, Adrian Greeman wrote: Hi, Sorry to inform you that I got a library corruption in my working machine where I built that tool and makes not to work well on Win9x machine. This will fixed in the next release, however you can use the tool shipped in your old version. Regard

RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

Urial: Why are you so phobic about running MySQL as a service? I can think of no reason to not run it as a service if the operating system will permit you to do so. Since you can configure the service to either run automatically or be controlled manually, it would seem as though you have the b

winadmin stopped on Beta

Hello everyone - I saw that the beta version of 4 was available and so I uninstalled my alpha (I only footal with the database at present on my own computer) and put on the beta. It starts fine and I have loaded my dumped database into it MySQLFront and PHP My Admin seem to connect to it and i

Re: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

I generally read responses to my requests for help with care ... and gratitude! So I did read Paul's post. To my knowledge it doesn't answer my (subsequent) question: > Is there some other way to have the MySQL server running on a > standalone Win > system other than as a service? Which way is ap

deleting master-detail table

dear all, hi, i have a question that bother me in last few days and would you help me to solve it, please. i have a master-detail table: hinvoice and dinvoice. the table structure of those two table shown as below : create table hinvoice ( nof varchar(7) not null, noso varchar(7), tg

Re: Q: How to determine size(s) of db files?

Hello. On Fri 2002-09-13 at 02:42:16 -0400, [EMAIL PROTECTED] wrote: > Benjamin Pflugmann wrote: [...] > > SHOW TABLE STATUS [FROM yourdatabase] [LIKE pattern] > > > > in order to see a overview of the tables including their resp. data > > and index file sizes. [...] > That seems to do it. But

Re: Re: Rapid-fire connections causing MySQL grief

Hi. On Wed 2002-09-11 at 15:10:22 -0400, [EMAIL PROTECTED] wrote: > > > On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote: > > > Version: MySQL.3.22.32-log > > > > > > Does this problem ring a bell with anyone? > > > I'm seeing two undesired behaviors, both, *I think* > > > seem to b

RE: deleting data from mater-detail table

I think you should use this statement. I did not try it. DELETE FROM hinvoice h USING dinvoice d WHERE h.nof=d.nof AND h.tgl < '2002-09-01'; Regards Stephan -Original Message- From: MySQL [mailto:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 9:25 AM

REWARD for help

I will buy a book of the helpers choice from Amazon.com (within reason up to $50ish) for help solving my problem: I need to do something kinda odd that I'm hoping to get help with...except for any suggestions of changing my base table structure. (Although if there was someway to make additiona

About the 4.1 release

Hello, When will the 4.1 source tree be made accessible by the public? How about the first official 4.1 release? Any estimates? Best regards, Iikka sql query ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland

deleting data from mater-detail table

dear all, hi, i have a question that bother me in last few days and would you help me to solve it, please. i have a master-detail table: hinvoice and dinvoice. the table structure of those two table shown as below : create table hinvoice ( nof varchar(7) not null, noso varchar(7), tg