Re: mysql.org

Too bad it's not your list to make that decision, but Monteys Ruben mysql - the database written and owned by MYSQL AB > On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: > > > > > Since these issues are between two private companies, please take > > > your discussions off this li

FW: MySQL JDBC

-Original Message- From: shane [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 10:49 AM To: [EMAIL PROTECTED] Subject: RE: MySQL JDBC yes. thks actually all i did was to do a: GRANT ALL ON DB.* TO "user"@"localhost" IDENTIFIED BY "pwd" -Original Message- From: Venu A

Re: Left Join very sloooowwww..

Hi Benjamin, Just a quick gif picture of the explain of the other query I made.. (It's quite late now and I will read your email tomorrow again..) > Could you post an EXPLAIN for it? I am curious to see it. > > > SELECT cpo.brandname, > >Sum((cpo.quantity)*(cpo.price)) AS omzet

Re: Left Join very sloooowwww..

Hi Don. On Sat, Jul 21, 2001 at 03:28:45PM -0500, [EMAIL PROTECTED] wrote: [...] > > There is one exception, though, there are compound keys, which will be > > of use. So, > > > > INDEX(id), INDEX(id) > > > > makes no sense, but > > > > IDNEX(id), INDEX(id,ordernr) > > > > may make sense.

Re: Upgrade MySQL

? - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "MikeBlezien" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 12:31 AM Subject: Re: Upgrade MySQL > On Sat, Jul 21, 2001 at 04:21:35PM -0500, MikeBlezien wrote: > > > > I have one other questi

Re: Upgrade MySQL

On Sat, Jul 21, 2001 at 04:21:35PM -0500, MikeBlezien wrote: > > I have one other question, does it make a difference where you put > the tar.gz file on the server before you untar it for the install?? > Does this have a bearing on the installation, when you using the > binary install?? It doesn

Win2k

I am using Win2k Advanced Server and Professional. Both systems have a problem with the current version of MySQL GUI when you successfully type in the correct password, of erroring and exiting. If you type in the incorrect password, it lets you into the application and just shows the access d

Re: Upgrade MySQL

I have one other question, does it make a difference where you put the tar.gz file on the server before you untar it for the install?? Does this have a bearing on the installation, when you using the binary install?? >On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wro

Re: mysql.org

On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote: > MySQL AB and NuSphere had a meeting over the phone, we exchanged > information and opinions and NuSphere will propose times for the > next meeting. > > Britt... Britt, thanks for the update. The neutral tone and lack of substanti

Re: mysql.org

On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote: > MySQL AB and NuSphere had a meeting over the phone, we exchanged > information and opinions and NuSphere will propose times for the > next meeting. > > Britt... Britt, thanks for the update. The neutral tone and lack of result ma

Re: Left Join very sloooowwww..

On 21-Jul-2001 Benjamin Pflugmann wrote: > Hi David! > > > Filesize and insertion/update speed are the main reasons. Another is > to only use what you really need, i.e. creating indexes which you are > not sure about using at all, should be avoided. > >> I use PHPmyAdmin a lot to place inde

Re: Another Newbie Question

Bob Rea schrieb am Samstag, 21. Juli 2001, 19:14:34: > On Friday 20 July 2001 10:46 pm, you wrote: >> You may want to understand what distinct and avg means. The >> combination doesn't make sense. > I took the example in question out of a book that I am using to teach > myself SQL. So I don't

RE: Using InnoDb table type - Urgent help required

Thanks a lot for your help Christian. I tried running the server from the DOS prompt and it complained about the innodb_log_arch_dir variable. It is running fine now. Rashmi -Original Message- From: Christian Jaeger [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 11:32 AM To: [

Re: Left Join very sloooowwww..

Hi David! On Sat, Jul 21, 2001 at 04:08:51PM +0200, [EMAIL PROTECTED] wrote: [...] > > SELECT * FROM orders, productorders WHERE productorders.orderid = orders.id > > SELECT * FROM orders JOIN productorders WHERE productorders.orderid = orders.id > > Yes, I see, this is basically the apples/pear

syntax problem

Hi I have compiled a report using Mascon only to find I can't export it to any other software I have! Great report but not much good to me as it is :-( (I'm not well versed in php yet, otherwise this might be an issue) However, I did get the sql query script and thought I could run it in Masc

Redhat rpm of latest mysql server?

All, It looks to me like the latest rpm available from Redhat is 3.23.36 (mysql-server-3.23.36-1). I have it installed on my RedHat 7.1 system but it appears to have a replication bug of some sort. This bug is reportedly fixed in later versions. A rpm with a more recent version is available fro

Re: Using InnoDb table type - Urgent help required

At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote: >innodb_data_file_path=ibdata1:200M >innodb_data_home_dir=f:/mysql/innodb/ibdata >innodb_log_group_home_dir=f:/mysql/innodb/iblogs > >The directories specified in the above variables exist. >However when I try to run the service I get the error "C

HELP How do I get SQL server 7.0+ mysql interface

Please help 1. I have a table called as bookmaster in sql server 7.0 (NT) with vb as the frontend situated locally ( DELHI ). Any updations ( insert mostly ) on this table should have a corresponding change incorporated in mysql (Linux) which is in US. This is required since we do not want to

AW: How to create table in msql DB through cgi script

What about installing and using phpMyAdmin?? http://phpmyadmin.sourceforge.net/ > -Ursprungliche Nachricht- > Von: Joseph Maxwell [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 21. Juli 2001 12:58 > An: [EMAIL PROTECTED] > Betreff: How to create table in msql DB through cgi script > >

Re: Is last_insert_id reliable?

Thanks to you and all the others who helped me out with this. I *am* using MyISAM tables, and everything is working the way I want it to. This is every bit as fast as the last_insert_id, with the added benefit that it is accurate no matter which thread I hit 8-). Yes, I am using pconnects, and my

FBSD ver 2.2.8 mysql

Im running FBSD ver 2.2.8 and need to know what version of mysql installs ans runs best on this platform. At this time upgrading in not an option. Thanks - Before posting, please check: http://www.mysql.com/manual.php (th

Re: Left Join very sloooowwww..

Hi Benjamin > > Then I got my hands on examples which used a left join examples.. I > > have never tried a normal join (sigh..), but thinking of it, what is > > the difference between an left join and a normal join..?? > With a "normal join" (I don't know the technical term), I mean > something l

Re: mysql.org

John Birrell wrote: > > On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: > > > > > Since these issues are between two private companies, please take > > > your discussions off this list. It is none of our business. By > > > all means, tell us the result. > > > > This discussion most

best version

Im running FBSD ver 2.2.8 and need to know what version of mysql installs ans runs best on this platform. At this time upgrading in not an option. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the

Re: mysql.org

On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: > > > Since these issues are between two private companies, please take > > your discussions off this list. It is none of our business. By > > all means, tell us the result. > > This discussion most certainly is our business. No it'

Re: mysql.org

> Since these issues are between two private companies, please take > your discussions off this list. It is none of our business. By > all means, tell us the result. This discussion most certainly is our business. I would appeal to both MySQL AB and NuShphere to keep discussions as public as i

Re: How to create table in msql DB through cgi script

You need to prepare and execute all of the SQL statements. You're just assigning SQL strings to a variable and printing them out -- you need to actually execute them. Only the last statement, "select * from test_1," is actually being run. Read through the perl DBI manual:

RE: Problem installing/compiling 3.23.39 on solaris 8

Hello, concerning problem with installing/compiling mysql 3.23.39 on solaris 8 using gcc 3.0 Solution: compile with gcc 2.95.3 I would still like to use gcc 3.0 thou :-) peter gad - Before posting, please check: http://w

Re: Transaction for MySQL

On Sat, Jul 21, 2001 at 03:46:58AM -0700, Michael Tam wrote: > Hi Jeremy, > > In question 2), what I meant is not uninstall MySql from Windows 2000 > but the service of it by calling "mysqld-nt --remove". That will take off > the service of the mysql-nt from being the default mysql daemon a

How to create table in msql DB through cgi script

Hello, I have a database set up on my web site at my ISP server. Connection to the DB can only be made from the localhost. So I have to do everything through CGI. They have the perl DBI and php3 that I can use to access the database. They provided a script to access the DBI which I modified to c

Re: gemini tables in mysql

Jeremy Zawodny writes: > On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote: > Does this mean they'll re-appear in the manual as well? > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-593

Re: Transaction for MySQL

Hi Jeremy, Thank you for your valuable info. However, may be you can fill me with some more detail here In question 2), what I meant is not uninstall MySql from Windows 2000 but the service of it by calling "mysqld-nt --remove". That will take off the service of the mysql-nt f

Re: Compiling Mysql++-1.7.9 on Linux with GCC 3.0

Matteo Limonta writes: > Hi boys, > > I have a problem when I make mysql++-1.7.9 API with gcc 3.0. > Can somebody help me, where is the problem ? > Is mysql++-1.7.9 compatible with the last ANSI/ISO C++ rules ? > > > Matteo Limonta > > > Yes, MySQL++ is compatible with latest ANSI/ISO C++ r

Re: will new databases be reflected in database replication.

On Fri, Jul 20, 2001 at 12:23:11PM +0800, Russell Teo Wee Liang wrote: > Hi all, > > I am running mysql 3.23.33 on a Sun Ultra-250 and is running slave > databases on 2 other machines. Everything was running fine until > someone created a new database and it wasn't updated in the slave > databas

Re: Transaction for MySQL

On Wed, Jul 18, 2001 at 02:06:03PM -0700, Michael Tam wrote: > Hi all, > > I am new using MySQL. I found out that the default table type used > in the binary isn't support transaction and would like to make > MySQL uses another table type which supports transaction. The > following are my q

Re: gemini tables in mysql

On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote: > > Yes, in 3.23.41 source tarball only. > > We will not put Gemini tables in our binaries due to several reasons > of which stability is just one. Does this mean they'll re-appear in the manual as well? -- Jeremy D. Zawodny,

Re: Replication & Load InFile

On Wed, Jul 18, 2001 at 07:38:10PM +0200, Warren van der Merwe wrote: > Hi > > If you use the load infile to insert images into a blob field, and > then the path does not exist when the replication takes place, will > there be an error, or is it clever enough to get the blob data from > the db?

RE: About safe_mysqld - another problem

you may find that the permissions for the mysql tables are set to root... I had to chown mysql:mysql the tables in /data/mysql/* before I could start mysqld check the permissions -Original Message- From: Ajay Nagarkar [mailto:[EMAIL PROTECTED]] Sent: 21 July 2001 08:05 To: [EMAIL PRO

How do I do this?

>Hi, > >I am trying the below sql statment: >mysql> select c.city, t.periodo, t.vitofferta from travel t, city c where >t.cityid=c.id and t.periodo>"2001-07-20" and >month(t.periodo)=month("2001-07-20") and >YEAR(t.periodo)=YEAR("2001-07-20") and rand() limit 7; > >The result: >+---+--

Re: Questions about extremely large database support

Hi! On Jul 20, Jeremy Zawodny wrote: > On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote: > > > > Our two most important requirements for the database engine are > > speed and scalability. We will be inserting probably 5,000,000 > > records per day into our database > > Sounds doable-

MySQL 3.23.40 released

Hi! New version of MySQL is available, here is the changelog: Changes in release 3.23.40 -- * Fixed problem with --low-priority-updates and INSERT's. * Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the maste