RE: can you "see" an index

[Don Read]

On 29-Jun-01 Tom Beidler wrote:
> Newbie question.
> 
> I recently altered a table by adding an index. I then DESCRIBEd it and it
> didn't show an index. Is this correct and if so, how do I know it's there?
> 

mysql> show keys from da_table


Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: Query Slowness

[Don Read]

On 29-Jun-01 [EMAIL PROTECTED] wrote:


eat this & die a horrible death: database,sql,query,table.
   ... damn robot POS (ghrrr).

> 
> 
> On 29-Jun-01 Kris Amy wrote:
>> yes i search on phone number. it's indexed(7) and the format of the phone
>> data is (XX)  .
>> 
>> is there anyway this could be optimized. I will eventually remove the
>> spaces
>> and the first 4 characters from the input data and reload it in
>> 
>> Kris Amy
> 
> Yes, if you know it'll always format '(01) 2345-6789',
> then store as it as a INT(10) UNSIGNED ZEROFILL. ( -> 0123456789)
> 
> An index on an INT is about as fast as it gets.
> 
> The redundant characters '() -' are eating key spsace without giving 
> you any benefit.
> 
>  ---
> 
> In the US (no 'merkin jokes, please) the norm is (012) 345-6789.
> I tend to code this as:
> 
> ph_areacode smallint(3) unsigned zerofill,
> ph_number   float(7,4) zerofill, 
> // int(7) unsigned will do slightly better  ...
> 
> key idx_ph (ph_number,ph_areacode)// search on number or ac+number
> 
> 
> and then have the application handle the formating.
> 
> Regards,
> -- 
> Don Read   [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to 
>steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

can you "see" an index

[Tom Beidler]

Newbie question.

I recently altered a table by adding an index. I then DESCRIBEd it and it
didn't show an index. Is this correct and if so, how do I know it's there?

Thank you,
Tom

>>.>>.>>>.>.>.
Tom Beidler
Orbit Tech Services
805.682.8972 (phone)
805.682.5833 (fax)
[EMAIL PROTECTED]
http://www.orbittechservices.com/
>>.>>.>>>.>.>.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL JDBC

[Kenneth Fleck]

Thank you, but I should have mentioned that I tried this before already.
So this is not the solution. What is really strange is that MySQL is
only mentioning the host IP in the first error message.
I used different versions of JDK and mm.mysql driver.
Any other ideas about that problem ?

Thomas Michael Koch wrote:
> 
> Hey there -
> 
> I think maybe you need to attach the port number as well.
> 
> In my applications I use the URL:
> jdbc:mysql://:3306/
> 
> Insert the correct hostname, databasename and your userId/password.
> 
> Hope it works.
> 
> Regards
> Thomas
> 
> -Original Message-
> From: flag [mailto:flag]On Behalf Of Kenneth Fleck
> Sent: 28. juni 2001 12:19
> To: mysql list
> Subject: MySQL JDBC
> 
> Hi !
> I have a problem accessing a MySQL DB from a java-app. On commandline I
> can get in without problems with
> 
> mysql  -u -p
> 
> but with the following connect String:
> 
>   jdbc:mysql://localhost/?user=&password=
> 
> I get strage result. First time execution error message (from
> SQLException caught) is:
> 
>   Invalid authorization specification: Keine Zugriffsberechtigung für
> Benutzer: '@127.0.0.1'. (Verwendetes Passwort: Ja)
> 
> after starting again, the message is :
> 
>   Invalid authorization specification: Keine Zugriffsberechtigung für
> Benutzer: '@'. (Verwendetes Passwort: Ja)
> 
> and it stays like that, the first will come again after not touching the
> system for a while.
> 
> Has anybody got an idea ?
> 
> ---
> Kenneth
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re:innobase bug w/ 3.23.29???

[ryc]

> Heikki> Hi!
> Heikki> I checked that in the COUNT(*) below InnoDB does
> Heikki> not fetch the whole row if it does the query through
> Heikki> a secondary index. It may sometimes have to
> Heikki> fetch it to determine if the row should be visible
> Heikki> in the current consistent read, the trx id is
> Heikki> stored in the whole row in the primary key index.
> Heikki> But Ryan said that queries were CPU-bound,
> Heikki> and fetching a million rows through a primary key
> Heikki> should at most take 10 s.
>
> Heikki> Regards,
>
> Heikki> Heikki
> Heikki> http://www.innodb.com
>
> This sounds like we would need a test case to solve this...
>
> Ryan, any change you could provide us with a script that would
> generate data for a testcase ?
>

I tried before with a small test case with no success. I will attempt again
with a larger dataset and hopefully it will pop-up.

ryan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: logs on nt4--Max Size

[Mike]

My Logs get pretty hefty with my PHP MySQL site, is there a Max log size or
something that will start another log file by date or when a certain size is
reached it's cleared. Had to ask

Cheers

-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 4:20 PM
To: Pete Kuczynski; [EMAIL PROTECTED]
Subject: Re: logs on nt4


Pete:

Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a
line like:
log=d:/mysql/mysql.log

If the line if commented out (# log=d:/mysql/mysql.log), then logging is
off. Remove the #, shutdown and restart the mysqld server.

Gerald Jensen


- Original Message -
From: "Pete Kuczynski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:45 PM
Subject: logs on nt4


> Hi,
> Where would I find the logs files from Mysql on a NT4 server? I have
> Nusphere Mysql installed with Apache/PHP and Mysql
>
> I monotor the Apache Error and Access logs, but should'nt there be logs
> generated by Mysql?
>
> I don't want to run out of disc space cause I neglected to clear them
> out.
>
> Thanks for any insight in advance!
>
> Pete
> --
> ___
> Pete Kuczynski
> Principal Field Engineer
> DHL Airways Inc.
> Infrastructure Technology & Services
> (773)-462-9758
> 24/7 Helpdesk 1-800-434-5767
>






> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Query Slowness

[David Robley]

On Fri, 29 Jun 2001 13:19, Kris Amy wrote:
> i have a database and a table:-
>
> mysql> describe phone;
> +---+--+--+-+-+---+
>
> | Field | Type | Null | Key | Default | Extra |
>
> +---+--+--+-+-+---+
>
> | name  | blob |  | | |   |
> | add1  | blob |  | | |   |
> | add2  | blob | YES  | | NULL|   |
> | phone | tinyblob |  | MUL | |   |
>
> +---+--+--+-+-+---+
> 4 rows in set (0.03 sec)
>
> mysql>
>
> The only problem is that it takes anywhere between 10seconds-1 minute
> to search the database. there is ~8.5 million records in it though.
>
> Anyone know howto speed this up?
>
> Kind Regards
> Kris Amy

Wouldn't you be better off to use Char or Varchar types for that sort of 
information?

-- 
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA  

   There is something to be said about me: "Wow!!"

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysterious loss of disk space

[Curtis Hogg]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I've searched through the archives, and while some things were slightly
similar, I couldn't find anything that matched well.

I'm using the Linux Debian packages for MySQL 3.23.39.

The problem I'm having is this: While the program i'm developing is
running, I am mysteriously losing space. I've limited it to MySQL because
the only writes to anything that my program makes, other to stderr,
involves MySQL calls. Most of the calls are SELECT statements though. At
any rate, while the program is running, except for new table adds, I'm
losing 32K every 30 seconds or so.

I didn't notice this in the beginning because i had over 600mb of space
remaining on the drive MySQL's writing to, but when my drive filled up for
the first time and I was only able to free up 90mb of space, my drive kept
filling back up every day of use.

The oddest thing was when I was forced to reboot by a totally seperate
issue. When my system got back up, and I checked my free space, all the
space was back.

While trying to figure out where the space was going, I attempted doing a
'du > file1' before run, and a 'du > file2' afterwards, and diffing the
two of them. There were no changes at all.

Can anybody help me with this problem or direct me to where I can receive
help for this (or point out where the blindingly obvious mistake i'm
making is)?

Thanks.

- -- Curtis Hogg [[EMAIL PROTECTED]]
- --

It is better to be bow-legged than no-legged.
- --
Email 1 - [EMAIL PROTECTED]
Email 2 - [EMAIL PROTECTED]
WWW - [in transit]

-BEGIN PGP SIGNATURE-
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBOzwHTbHXK8DxaQMZEQI+mACgvvCf1nRQc6aVJ+SNL2razGqeG7wAoJY3
09G2RozOtqP1YP5E2ALa0l6j
=BY9r
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Query Slowness

[Kris Amy]

yes i search on phone number. it's indexed(7) and the format of the phone
data is (XX)  .

is there anyway this could be optimized. I will eventually remove the spaces
and the first 4 characters from the input data and reload it in

Kris Amy

-Original Message-
From: Don Read <[EMAIL PROTECTED]>
To: Kris Amy <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, 29 June 2001 2:07
Subject: RE: Query Slowness


>
>On 29-Jun-01 Kris Amy wrote:
>> i have a database and a table:-
>>
>> mysql> describe phone;
>> +---+--+--+-+-+---+
>>| Field | Type | Null | Key | Default | Extra |
>> +---+--+--+-+-+---+
>>| name  | blob |  | | |   |
>>| add1  | blob |  | | |   |
>>| add2  | blob | YES  | | NULL|   |
>>| phone | tinyblob |  | MUL | |   |
>> +---+--+--+-+-+---+
>> 4 rows in set (0.03 sec)
>>
>> mysql>
>>
>> The only problem is that it takes anywhere between 10seconds-1 minute to
>> search the database. there is ~8.5 million records in it though.
>>
>> Anyone know howto speed this up?
>
>What do you search on, the phone number ? that what's indexed.
>Great for a reverse-directory, not so good for a name-> number query.
>
>Regards,
>--
>Don Read   [EMAIL PROTECTED]
>-- It's always darkest before the dawn. So if you are going to
>   steal the neighbor's newspaper, that's the time to do it.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Query Slowness

[Don Read]

On 29-Jun-01 Kris Amy wrote:
> i have a database and a table:-
> 
> mysql> describe phone;
> +---+--+--+-+-+---+
>| Field | Type | Null | Key | Default | Extra |
> +---+--+--+-+-+---+
>| name  | blob |  | | |   |
>| add1  | blob |  | | |   |
>| add2  | blob | YES  | | NULL|   |
>| phone | tinyblob |  | MUL | |   |
> +---+--+--+-+-+---+
> 4 rows in set (0.03 sec)
> 
> mysql>
> 
> The only problem is that it takes anywhere between 10seconds-1 minute to
> search the database. there is ~8.5 million records in it though.
> 
> Anyone know howto speed this up?

What do you search on, the phone number ? that what's indexed.
Great for a reverse-directory, not so good for a name-> number query.

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

creative work. SSZGO Multimedia design company

[SSZGO International]

[EMAIL PROTECTED]
WWW.SSZGO.COM

SSZGO International is back, introducing its new website WWW.SSZGO.COM v4
IT IS RANDOM...IT IS MODULAR... a new level in flash actionscripting...

ARE YOU IN NEED OF CREATIVE WEBWORK?

DONT MISS THE OPPORTUNITY : 
GREAT CUSTOM DESIGNS AT GREAT PRICES, 
HUGE DISCOUNTS AND SPECIAL DEALS IN NEXT 30 DAYS... 
CONTACT US NOW TO GET A QUOTE

:::
WEB SITE DESIGN
WEB SITE REDESIGN
WEB SITE MAINTENANCE
FLASH SITE DESIGN
FLASH ANIMATION
FLASH GAMES
MULTIMEDIA CDROMS
LOGO DESIGN
BANNER DESIGN
2D & 3D ANIMATION
DATABASE-WWW CONNECTION
BUSSINES CARD DESIGN
ACTIVE SERVER PAGES
ONLINE MARKETING
:::


to be removed from our   mailing list visit www.sszgo.com/unsubscribe.htm


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Query Slowness

[Kris Amy]

i have a database and a table:-

mysql> describe phone;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| name  | blob |  | | |   |
| add1  | blob |  | | |   |
| add2  | blob | YES  | | NULL|   |
| phone | tinyblob |  | MUL | |   |
+---+--+--+-+-+---+
4 rows in set (0.03 sec)

mysql>

The only problem is that it takes anywhere between 10seconds-1 minute to search the 
database. there is ~8.5 million records in it though.

Anyone know howto speed this up?

Kind Regards
Kris Amy

Re: Connecting to MySQL w/VB

[Jason Brunk]

just curious, how do you connect to mysql through ASP?  i have tried
connecting with "MyODBC", i installed myodbc and then i create the
connection string in asp like this

set conn=server.createobject("adodb.connection")
conn.open
"driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1"

i was just curious to see how you connect to mysql with asp

jason
asp developer working in mysql  :)
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Jason Brunk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 11:38 PM
Subject: Re: Connecting to MySQL w/VB


> - Original Message -
> From: "Jason Brunk" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 8:18 PM
> Subject: Re: Connecting to MySQL w/VB
>
>
> > i know i am definitly knew at this, but his permissions could be set
more
> or
> > less for read only.
>
> Yes, it's possible that the permissions are not set properly. However, I
was
> assuming that, since he had just started working with MySQL, he was using
> the root account, unmodified, which would give him complete access. It's
> been my experience that it is much easier to work with ASP & MySQL than VB
&
> MySQL because of the databound objects, and wouldn't be surprised if the
> problem that the original poster has does not apply to ASP.
>
> Good Luck,
>
> Dennis
> **
> Beridney Computer Services
> http://www.beridney.com
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL w/VB

[Dennis Salguero]

- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:18 PM
Subject: Re: Connecting to MySQL w/VB


> i know i am definitly knew at this, but his permissions could be set more
or
> less for read only.

Yes, it's possible that the permissions are not set properly. However, I was
assuming that, since he had just started working with MySQL, he was using
the root account, unmodified, which would give him complete access. It's
been my experience that it is much easier to work with ASP & MySQL than VB &
MySQL because of the databound objects, and wouldn't be surprised if the
problem that the original poster has does not apply to ASP.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL w/VB

[Jason Brunk]

i know i am definitly knew at this, but his permissions could be set more or
less for read only.

i am just spitting junk out, i am new, but i don't like sitting idle in a
group.  i have been watching this thread closely, because i do developement
on a large scale in ASP and VB.

so just ignore me if i am being an idiot.

Jason
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 11:03 PM
Subject: Re: Connecting to MySQL w/VB


> - Original Message -
> From: "Robert Skinner" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 7:44 PM
> Subject: Connecting to MySQL w/VB
>
>
> > I am trying to connect to MySQL using a connection string using VB6.
The
> > read part is great but I don't seem to be able to add records.  Can
anyone
> > steer me in the right direction?
>
> A bit more information might help us help you. If you the db reads work
> fine, then you at least have the connection made - that's already half-way
> there! I have done extensive work with MySQL and VB/VBScript, but if you
can
> execute a SELECT query (as your e-mail indicates) I don't see how you
would
> have problems executing an INSERT query (assuming the SQL statement is
> valid).
>
> What exactly seems to be the problem?
>
> Good Luck,
>
> Dennis
> **
> Beridney Computer Services
> http://www.beridney.com
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: cursor definition

[Paul DuBois]

At 7:08 PM + 6/28/01, Yamuna Vallipuram wrote:
>Hi...
>
>I am new to MySQL and trying to write some database queries.
>
>(Basically, I am developing a WEB application using Pearl script. 
>The data is stored in MySQL database. Pearl scripts access the 
>database via Pearl DBI)
>
>I could not find any info about cursor definitions in MySQL documentations.

That's likely because MySQL doesn't have cursors.

Can you just run a standard DBI fetch loop?


>
>How do I write the following Oracle code in MySQL.
>
>Cursor CurPerson is
>Select Arstall_Godkj_Stkomp
>From  Person
>Where Fodselsdato  = inFDato   And
>  Personnr = inPNr;;
>
>  Begin
> Open curPerson;
> Fetch CurPerson into refGodkjent;
> If curPerson%Found Then
>
>Thank you
>
>Yamuna


-- 
Paul DuBois, [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem in initializing mySQL on Windows Plateform

[Bhartendu Maheshwari]

Hello

I had installing mySQL as well myODBC, but when I run mysqld it has given an
error

C:\>mysqld
error: Found option without preceding group in config file: c:\my.cnf at
line: 1
Program aborted

Next time I had write a file my.cnf as 

innodb_data_file_path = ibdata1:400M;ibdata2:400M
innodb_data_home_dir = c:\mysql
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

Since my harddisk have only 900MB free space. So i choose
innodb_data_file_path to be 400MB each. Now when I again run mysqld, It has
given again error as

C:\>mysqld
Can't initialize InnoDB as 'innodb_data_file_path' is not set

Now Please tell me what to do?

Thank you

Re: Connecting to MySQL w/VB

[Dennis Salguero]

- Original Message -
From: "Robert Skinner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 7:44 PM
Subject: Connecting to MySQL w/VB


> I am trying to connect to MySQL using a connection string using VB6.  The
> read part is great but I don't seem to be able to add records.  Can anyone
> steer me in the right direction?

A bit more information might help us help you. If you the db reads work
fine, then you at least have the connection made - that's already half-way
there! I have done extensive work with MySQL and VB/VBScript, but if you can
execute a SELECT query (as your e-mail indicates) I don't see how you would
have problems executing an INSERT query (assuming the SQL statement is
valid).

What exactly seems to be the problem?

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[Ashley M. Kirchner]

All of the suggested methods for filtering mail from MySQL list is
great...for those using an actual mailer program.  For people sitting on
web based email services, they don't have that capability (except for
maybe sorting based on subject, receive date, or something like that),
and having subject tags helps a great deal.  It's great being able to
determine emails at first glance, instead of having to open them one by
one because you have no clue what list they belong to, or what they're
about.

Just my 2 cents worth.

--
H | Hi, I'm currently out of my mind.  Please leave a message.  BP!
  +
  Ashley M. Kirchner    .   303.442.6410 x130
  Director of Internet Operations / SysAdmin. 800.441.3873 x130
  Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6
  http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Increasing Packet Size

[Jez Brown]

How can I increase the packet size used in mySQL i.e. increase the value of 
'max_allowed_packet' to a larger number from a script.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Connecting to MySQL w/VB

[Robert Skinner]

I am trying to connect to MySQL using a connection string using VB6.  The
read part is great but I don't seem to be able to add records.  Can anyone
steer me in the right direction?

[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very difficult Query! Help plz!!

[Bob Hall]

>hi all together!
>
>i'm turning to your mailinglist as last chance to find s.o. helping 
>me with my problem.
>
>the situation is as follows:
>
>i got a table on a mysql-database, queriing it by php4. the table 
>consists of all planets of the planetarion.com-system. these 
>information consists of each 3 coordinates of a planet (x, y and z), 
>identifiing a planet clearly. theese 3 coords are written in a 
>int-field, each. other information are the name of the planet, the 
>rulers name, the score and the size of the planet. when the first 
>two coords (x and y) of 2 planet are equal, the planets belong to 
>the same galaxie. and now the point:

Sir, that means that all the planets of a given galaxy are located on 
a single line (vector). I've heard of disk galaxies, where all the 
objects have the same value (give or take a few million kilometers) 
on one coordinate. Having as few as three planets in just one solar 
system temporarily sharing values on two coordinates has unusual 
results, e.g. three wise men wandering the Middle East on Christmas 
Eve looking for hummus to dip their falafel in.

>i try queriing the database as follows:
>
>the user inserts some wished dates (the lowest score, the searched 
>planet may have, the highest, the highest number of roids and the 
>lowest..) and the number-interval in wich the _galaxy-score_ may be 
>included. (means x > galaxy-sore > y). the problem is, to query 
>that! the first query is very simple: "SELECT * FROM Planetarion 
>WHERE Score > $x AND Score < $y AND Size > $a AND Size < $B". how 
>how you get the galaxie-score for that?? the second query alone is 
>very simple, too: "SELECT SUM(Score) as Summe FROM $table WHERE X = 
>$x AND Y = $y GROUP BY X, Y".
>
>_But how to combine both queries???_
>
>i tried getting the first one and process for each elemnt of it the 
>second one... but then the resources of my server will get low, when 
>the first query results eg. 300 elements or more
>
>i tried asking the german newsgroup and other people i know, using 
>mysql. and you're my very last hope to solve this problem
>
>thank you very much for each help!!
>
>regards,
>dotcom

What you are trying to do isn't clear. As written, your queries can't 
be combined. An SQL statement that managed to combine those two 
statements would be comparable to a galaxy in which all the planets 
had the same values on two coordinates; interesting, but too weird to 
avoid falling apart.

However, if you are trying to group the results of the first query 
and sum the scores in each group, the following should work:

SELECT Sum(Score)
FROM Planetarion
WHERE Score > $x AND Score < $y AND Size > $a AND Size < $B
GROUP BY X, Y;

Bob Hall

 [EMAIL PROTECTED]
  Know thyself? Absurd direction!
 Command 'know' not recognized.
Æsj. Jeg søkte etter en list server og fant en epistemologisk skeptiker.
MySQL secret passwords: sql query database 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

bug on Sum() Function with Null Value

[PRS]

Dear Sir:


The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5.

I have a problem with below SQL Statement 

"Select Sum(Cost) as TotalCost from Item"

All the entries for Cost Field has the Value Null. The result of this Query
is TotalCost  = 0.
But is not it suppose to be Null instead of 0.

Because when i try
 
"Select Avg(Cost) as TotalCost from Item"
OR
"Select Max(Cost) as TotalCost from Item"

The result of this Average Query is TotalCost  = Null.

Regards
Jack Chan

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS IIS web logfiles

[Paul Fontenot]

I have a Perl script that I use to parse and insert all my Unix logfiles
into a MySQL server. I can post the script if you would like to have / view
/ steal of whatever.

-Paul

- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Charles Henderson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 5:04 PM
Subject: Re: MS IIS web logfiles


> - Original Message -
> From: "Charles Henderson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 4:33 PM
> Subject: MS IIS web logfiles
>
>
> > How can I get mySQL to create a table for a IIS web logfile (*.log) ?
The
> > file is very long (maybe 1 million records +) and there are 16 space
> > separated data fields (17 if you include a autocount as primary key).
I
> > know that MS Access has a GUI Wizard that walks you through the
conversion
> > of text files to an Access table.  Unfortunately, my data is much to
large
> > for MS Access (or a text reader).  I find no comparable facilitation
with
> > mySQL.  Any suggestions?
>
> Well, unfortunately that's one of the trade-offs between a "database" like
> Access and something more robust like MySQL. MySQL (and most other large
> database packages) do not always have these GUI tools to facilitate
> conversions and other operations.
>
> Therefore, perhaps the best long-term solution for your need is to create
a
> VB program (or the language of your choice) to take a delimited text file
> and put it into its own table in MySQL (or any other database really). As
> long as you can access the file and know the delimiter (both of which are
> possible with IIS log file), then this program should not be difficult to
> put together.
>
> Good Luck,
>
> Dennis
> **
> Beridney Computer Services
> http://www.beridney.com
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[Joshua J. Kugler]

I'm filtering on "List-ID" header contains "mysql.mysql.com"  Works great.

j- k-

On Thursday 28 June 2001 17:05, Sherzod Ruzmetov wrote:
> I do aggree with dave's point. Could we do that, please
>
> On Thu, 28 Jun 2001, Dave Halliday wrote:
> > Quick question - just signed up for this list and I was wondering if it
> > would be possible to put a "  [MySQL]  " tag in the subject line?
> >
> > There doesn't seem to be a standard identifier in the messages and
> > although I am filtering the entire header looking for instances of "
> > mysql " my reader ( Pegasus ) doesn't always catch it.
> >
> >
> > Most other lists I subscribe to either have the tag at the beginning
> > of the subject line or spoof the address to read the list origin.
> > Either way allows for flawless filtering.
> >
> >
> > Thanks!
> > Dave
> >
> >
> > 
> >
> > David G. Halliday
> > The Glosten Associates
> > 600 Mutual Life Building
> > 605 First Avenue
> > Seattle, WA 98104-2224
> > (206) 624-7850
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[David Robley]

On Fri, 29 Jun 2001 01:14, Dave Halliday wrote:
> Quick question - just signed up for this list and I was wondering if it
> would be possible to put a "  [MySQL]  " tag in the subject line?
>
> There doesn't seem to be a standard identifier in the messages and
> although I am filtering the entire header looking for instances of "
> mysql " my reader ( Pegasus ) doesn't always catch it.
>
>
> Most other lists I subscribe to either have the tag at the beginning
> of the subject line or spoof the address to read the list origin.
> Either way allows for flawless filtering.
>
>
> Thanks!
> Dave

You seem to be using Pegasus Mail. Set up your filter using a standard 
header match triggered by the text [EMAIL PROTECTED] in the To or Cc 
fields.

The same filter works just fine for me in KMail :-)

-- 
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA  

   Oxymoron: Somewhat Incompatible.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[Sherzod Ruzmetov]

I do aggree with dave's point. Could we do that, please

On Thu, 28 Jun 2001, Dave Halliday wrote:

> Quick question - just signed up for this list and I was wondering if it 
> would be possible to put a "  [MySQL]  " tag in the subject line?
> 
> There doesn't seem to be a standard identifier in the messages and 
> although I am filtering the entire header looking for instances of " 
> mysql " my reader ( Pegasus ) doesn't always catch it.
> 
> 
> Most other lists I subscribe to either have the tag at the beginning 
> of the subject line or spoof the address to read the list origin.  
> Either way allows for flawless filtering.
> 
> 
> Thanks!
> Dave
> 
> 
> 
> 
> David G. Halliday
> The Glosten Associates
> 600 Mutual Life Building
> 605 First Avenue
> Seattle, WA 98104-2224
> (206) 624-7850
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very difficult Query! Help plz!!

[Benjamin Pflugmann]

Hello.

On Thu, Jun 28, 2001 at 10:48:23PM +0200, [EMAIL PROTECTED] wrote:
[...]
> the user inserts some wished dates (the lowest score, the searched
> planet may have, the highest, the highest number of roids and the
> lowest..) and the number-interval in wich the _galaxy-score_ may be
> included. (means x > galaxy-sore > y). the problem is, to query
> that! the first query is very simple: "SELECT * FROM Planetarion
> WHERE Score > $x AND Score < $y AND Size > $a AND Size < $B". how
> how you get the galaxie-score for that?? the second query alone is
> very simple, too: "SELECT SUM(Score) as Summe FROM $table WHERE X =
> $x AND Y = $y GROUP BY X, Y".
>
> _But how to combine both queries???_

I think the following is what you are looking for.

SELECT   X, Y,
 SUM(Score) AS Summe
 SUM(Size) AS Groesse
FROM Planetarion
GROUP BY X, Y
HAVING   Summe > $sizemin AND Summe < $sizemax AND
 Groesse > $groessemin AND Groesse < $groessemax

> i tried getting the first one and process for each elemnt of it the
> second one... but then the resources of my server will get low, when
> the first query results eg. 300 elements or more

The above query is also quite resource intensive, simply because it
has to visit all rows to calculate the SUMs, before it can apply the
HAVING clause.

Another approach is, if it is feasable in your situation, to create a
summary table with the result of the calculation (of course, that
makes only sense if there are times, where the data doesn't change),
and then only query the summary table (which will be pretty fast in
comparison):

INSERT INTO TABLE plan_sum (http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS IIS web logfiles

[Dennis Salguero]

- Original Message -
From: "Charles Henderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:33 PM
Subject: MS IIS web logfiles


> How can I get mySQL to create a table for a IIS web logfile (*.log) ?  The
> file is very long (maybe 1 million records +) and there are 16 space
> separated data fields (17 if you include a autocount as primary key).   I
> know that MS Access has a GUI Wizard that walks you through the conversion
> of text files to an Access table.  Unfortunately, my data is much to large
> for MS Access (or a text reader).  I find no comparable facilitation with
> mySQL.  Any suggestions?

Well, unfortunately that's one of the trade-offs between a "database" like
Access and something more robust like MySQL. MySQL (and most other large
database packages) do not always have these GUI tools to facilitate
conversions and other operations.

Therefore, perhaps the best long-term solution for your need is to create a
VB program (or the language of your choice) to take a delimited text file
and put it into its own table in MySQL (or any other database really). As
long as you can access the file and know the delimiter (both of which are
possible with IIS log file), then this program should not be difficult to
put together.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Help - Create Views

[Benjamin Pflugmann]

Hello.

Views are not supported (yet). I tried to search for VIEWS in the
online manual and it came up with the following section as first link:
http://www.mysql.com/doc/M/i/Missing_Views.html

Bye,

Benjamin.


On Fri, Jun 29, 2001 at 02:44:44AM +1000, [EMAIL PROTECTED] wrote:
> Hello,
> 
> I am just learning Mysql and was reading a general SQL book.  The book talks
> about creating views for joins (CREATE VIEW ...)that you regularly use.  I
> can not find out if Mysql supports this and if it does, how do I perform
> this.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MS IIS web logfiles

[Charles Henderson]

Hi,  8 -)

I'm a newbe to mySQL.  So, please excuse me if I ask a question whose answer
appears obvious to you.

How can I get mySQL to create a table for a IIS web logfile (*.log) ?  The
file is very long (maybe 1 million records +) and there are 16 space
separated data fields (17 if you include a autocount as primary key).   I
know that MS Access has a GUI Wizard that walks you through the conversion
of text files to an Access table.  Unfortunately, my data is much to large
for MS Access (or a text reader).  I find no comparable facilitation with
mySQL.  Any suggestions?


Regards,

Charles H. Henderson
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: tar.gz.asc ????

[Duncan Hill]

On Thu, 28 Jun 2001, wkd wrote:

>
>   Does any body know how to open a x.tar.gz.asc file?
>   I know what a tar file and gz but i can't find anything on how to
> open a tar.gz.asc file.

.tar.gz.asc is an ascii file containing the signature of the .tar.gz in
question - either generated by md5sum or pgp normally.  Mysql and other
places use them so you can varify the integrity of the file.

-- 

Sapere aude
My mind not only wanders, it sometimes leaves completely.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Update based on subselect

[Hannes Niedner]

I have seen the smart way to insert data into tables based on a select
statement posted recently on this list. Is this also possible for an update
query?

I want to do something like:

UPDATE TABLE foo
SET foo.field1 = SELECT bar.field1
FROM bar
WHERE foo.field2 = bar.field2;

Thanks in advance

hannes


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: libmysql.dll - documentation pls..

[Joshua J. Kugler]

NOTE: I replied off-list

First note: I like the e-mail address.  Really great.

Secondly: The best VB/DLL documentation you could find MIGHT be a project 
that has done what you want.  If you download the source classes for the 
MyVbQl VB API  it will tell you a lot 
about interfacing with the DLL.  Also: I would assume that reading the 
documentation to the C API would be a good place to start as well, as that 
details the interface to the libmysql.dll (on windows) and libmysql.so (on 
*nix systems).

Third:  You've seen a few?  I've only managed to find one.  At least only one 
free one.  What are the others you've found?

Fourth: When you write it, could you be careful to write it so it could be 
used in MS Access as well?  I don't know many specifics, but I do know Access 
97 doesn't support Enum's.  Access 2000 does, so if you want to do that, I'll 
just convince my boss to upgrade.  We're due anyway.

Fifth: I don't have extensinve experience with VB, but have done quite a bit 
of Access programming, and would like to help with this if I could.

So, let me know what you turn up.  I'll look as well.

j- k-

On Thursday 28 June 2001 13:52, Dan wrote:
> All,
>
> I want to use the libmysql.dll in Visual Basic, I have seen a few dll's
> floating around that do the wrapping for you but I want to do this myself.
>
> Can someone point me in the direction of an example or some documentation.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: logs on nt4

[Gerald Jensen]

Pete:

Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a
line like:
log=d:/mysql/mysql.log

If the line if commented out (# log=d:/mysql/mysql.log), then logging is
off. Remove the #, shutdown and restart the mysqld server.

Gerald Jensen


- Original Message -
From: "Pete Kuczynski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:45 PM
Subject: logs on nt4


> Hi,
> Where would I find the logs files from Mysql on a NT4 server? I have
> Nusphere Mysql installed with Apache/PHP and Mysql
>
> I monotor the Apache Error and Access logs, but should'nt there be logs
> generated by Mysql?
>
> I don't want to run out of disc space cause I neglected to clear them
> out.
>
> Thanks for any insight in advance!
>
> Pete
> --
> ___
> Pete Kuczynski
> Principal Field Engineer
> DHL Airways Inc.
> Infrastructure Technology & Services
> (773)-462-9758
> 24/7 Helpdesk 1-800-434-5767
>






> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

tar.gz.asc ????

[wkd]

  Does any body know how to open a x.tar.gz.asc file?
  I know what a tar file and gz but i can't find anything on how to open a tar.gz.asc 
file.  

libmysql.dll - documentation pls..

[Dan]

All,

I want to use the libmysql.dll in Visual Basic, I have seen a few dll's floating 
around that do the wrapping for you but I want to do this myself.

Can someone point me in the direction of an example or some documentation.

logs on nt4

[Pete Kuczynski]

Hi,
Where would I find the logs files from Mysql on a NT4 server? I have
Nusphere Mysql installed with Apache/PHP and Mysql

I monotor the Apache Error and Access logs, but should'nt there be logs
generated by Mysql?

I don't want to run out of disc space cause I neglected to clear them
out.

Thanks for any insight in advance!

Pete
-- 
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql_connect() blocking problem

[David Lan]

Hi All,

My unix client process got blocked at the reconnect attempt when the
Linux box running MySQL server went down. I don't know how to set
timeout value on the mysql_connect() call. Anyone know a good way to
stop the function from blocking forever without killing the process ?

I am using mysql-3.23 client API talking to a 3.23 server.

Thanks,

David


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SELECT using > and limit not optimized.

[root]

>Description:

I am trying to get the next record given a key (numeric or string),
What is the best way to do this.  I am currently using:

SELECT * from wk004.slsf01 where ___RecNo > 3000 limit 1;

table   typepossible_keys   key key_len ref rowsExtra
slsf01  range   PRIMARY PRIMARY 4   NULL349 where used

The explain result for this command show's rows accessed as 349,
there are 3349 records in the file. If I use:

SELECT * from wk004.slsf01 where ___RecNo > 0 limit 1;

explain shows 3349 rows.

table   typepossible_keys   key key_len ref rowsExtra
slsf01  range   PRIMARY PRIMARY 4   NULL3349where used

To me this indicates that the more records in the file the slower
this statement will be.  Timing results with 3000 vs 10 records 
verify this.

Why is rows not 1 in this case?
Is there a different SELECT command I should be using?

___RecNo is an AUTO-INCREMENT BIGINT field, and is the only member of the
   PRIMARY key, sorted ASCENDING. 

   The problem occurs on any index I use (string or INT), single or multiple
   keys.

   Occurs on Linux and SCO Unix.

>How-To-Repeat:
EXPLAIN SELECT * from wk004.slsf01 where ___RecNo > 3000 limit 1;
EXPLAIN SELECT * from wk004.slsf01 where ___RecNo > 0 limit 1;
>Fix:

>Submitter-Id:  jwythe
>Originator:jww
>Organization: Silk Systems Inc.
>MySQL support: none
>Synopsis:  SELECT using > and limit not optimized.
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: support
>Release:   mysql-3.23.37 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for pc-sco3.2v5.0.4 on 
>i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.37
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 11 min 1 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 5  Flush tables: 1  Open tables: 0 
Queries per second avg: 0.002
>Environment:
Touch Intel PII-300Mhz, Redhat 6.2 Linux/SCO Openserver 5, same
System: SCO_SV sysdev 3.2 2 i386


Some paths:  /bin/make /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-sco3.2v5.0.5/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=' '  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root sys   36 May 19  1998 /lib/libc.a -> 
/opt/K/SCO/unixds/5.1.0Ha/lib/libc.a
lrwxrwxrwx   1 root sys   37 May 19  1998 /lib/libc.so -> 
/opt/K/SCO/unixds/5.1.0Ha/lib/libc.so
lrwxrwxrwx   1 root sys   40 May 19  1998 /usr/lib/libc.a -> 
/opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.a
lrwxrwxrwx   1 root sys   41 May 19  1998 /usr/lib/libc.so -> 
/opt/K/SCO/unixds/5.1.0Ha/usr/lib/libc.so
lrwxrwxrwx   1 root root  41 May 13  1998 /usr/lib/libc.so.1 -> 
/opt/K/SCO/Unix/5.0.4Eb/usr/lib/libc.so.1
Configure command: ./configure  --with-low-memory


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Very difficult Query! Help plz!!

[DotCom]

hi all together!

i'm turning to your mailinglist as last chance to find s.o. helping me with my problem.

the situation is as follows:

i got a table on a mysql-database, queriing it by php4. the table consists of all 
planets of the planetarion.com-system. these information consists of each 3 
coordinates of a planet (x, y and z), identifiing a planet clearly. theese 3 coords 
are written in a int-field, each. other information are the name of the planet, the 
rulers name, the score and the size of the planet. when the first two coords (x and y) 
of 2 planet are equal, the planets belong to the same galaxie. and now the point:

i try queriing the database as follows:

the user inserts some wished dates (the lowest score, the searched planet may have, 
the highest, the highest number of roids and the lowest..) and the number-interval in 
wich the _galaxy-score_ may be included. (means x > galaxy-sore > y). the problem is, 
to query that! the first query is very simple: "SELECT * FROM Planetarion WHERE Score 
> $x AND Score < $y AND Size > $a AND Size < $B". how how you get the galaxie-score 
for that?? the second query alone is very simple, too: "SELECT SUM(Score) as Summe 
FROM $table WHERE X = $x AND Y = $y GROUP BY X, Y". 

_But how to combine both queries???_

i tried getting the first one and process for each elemnt of it the second one... but 
then the resources of my server will get low, when the first query results eg. 300 
elements or more

i tried asking the german newsgroup and other people i know, using mysql. and you're 
my very last hope to solve this problem

thank you very much for each help!!

regards,
dotcom

Re: Date format problem

[MikeBlezien]

On Thu, 28 Jun 2001 21:49:57 +0200, "Sebastiaan J.A. Kamp" <[EMAIL PROTECTED]>
wrote:

if your using perl, heres a real simple way to format your date:

my $date = "28/06/2001";
my($mn,$day,$yr) = split '/',$date;
my $db_date = join('-',$yr,$mn,$day);

# Your output should now be $db_date = 2001-06-28

Hope this helps ;)


>>What programming language are you using?
>>
>>
>>Hi guys, does anyone help me with this simple thing ??
>>
>>I have a date format problem, I need a spanish format please read the
>>following lines:
>>
>>Receive from input "28/06/2001"
>>Want to change it to "2001-06-28" to write the Database
>>Use to do it "DATE_FORMAT (inputdate, %Y-%m-%d)"
>>
>>It doesn't work fine
>>
>>Thanks a lot for your time

Mike(mickalo)Blezien

Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
















-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Newbie problem with winmysqladmin

[Bomber Steel]

How did you get MySQL up and running on your PC?

I am trying to get MySQL running on my PC and I cannot find out how to even
start it. Is there an installation manual in the files? Is there a manual on
how to use MySQL in the files?

Bomber Steel

-Original Message-
From: Michael Tam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 1:28 PM
To: mysql
Subject: Newbie problem with winmysqladmin

Hi All,

I am new to MySQL and have a problem using winmysqladmin.  MySQL is
working fine, which I can access the database from my Java apps.  However,
when I tried to use winmysqladmin to obtain my db and table info,
winmysqladmin never connects with MySQL and I can't obtain the info.

In addition, beside winmysqladmin, what other gui program will allow me
to obtain those info?

If anybody can give me a direction to where I should look into, that
would be great and appreciated.

Thank you.

Best regards,
Michael Tam


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie problem with winmysqladmin

[Miguel Angel Solórzano]

At 12:28 28/06/2001 -0700, Michael Tam wrote:
Hi,
WinMySQLAdmin only shows for you the db and table info,
when is able to do a connection using an user name and
his password which are edited at first start and when
the my.ini file exist.
So, if you are not using my.ini file, then the tool doesn't
make the connection or when you are removed the data above
mentioned or changed the data.

Regard,
Miguel

>Hi All,
>
> I am new to MySQL and have a problem using winmysqladmin.  MySQL is 
> working fine, which I can access the database from my Java 
> apps.  However, when I tried to use winmysqladmin to obtain my db and 
> table info, winmysqladmin never connects with MySQL and I can't obtain 
> the info.
>
> In addition, beside winmysqladmin, what other gui program will allow 
> me to obtain those info?
>
> If anybody can give me a direction to where I should look into, that 
> would be great and appreciated.
>
> Thank you.
>
>Best regards,
>Michael Tam

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie problem with winmysqladmin

[Sinisa Milivojevic]

Michael Tam writes:
> Hi All,
> 
> I am new to MySQL and have a problem using winmysqladmin.  MySQL is working 
>fine, which I can access the database from my Java apps.  However, when I tried to 
>use winmysqladmin to obtain my db and table info, winmysqladmin never connects with 
>MySQL and I can't obtain the info.  
> 
> In addition, beside winmysqladmin, what other gui program will allow me to 
>obtain those info?
> 
> If anybody can give me a direction to where I should look into, that would be 
>great and appreciated.
> 
> Thank you.
> 
> Best regards,
> Michael Tam


Hi!

Try our mysqlgui. There is a link for it on our front page.

Follow instructions in README for installations.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Replication updating two slave databases

[guys]

>Description:
Using replication and redirection.  Master database named 'ftc'.  Slave database named 
'ftcprod'.  Using replicate-rewrite-db
to direct the updates to the slave ftcprod.  my.cnf is:

 [cgi]# more /etc/my.cnf
 [mysqld]
 server-id=111757
 replicate-do-db=ftc
 replicate-rewrite-db=ftc->ftcprod

Also have a database named 'ftc' on the slave.  Use the slave version of ftc for 
development and testing.

Updates on the master are being applied to both ftc and ftcprod on the slave system.

>How-To-Repeat:

Perpetual.  Updates on master are echoed.

>Fix:

>Submitter-Id:  
>Originator:Guy Smith
>Organization:  FundTheCause
>MySQL support: none
>Synopsis:  
>Severity:  serious
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.32 (Source distribution)

>Environment:
System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown
Architecture: i586

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root   13 Oct  4  1996 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x   1 root root  4101324 Feb 29  2000 /lib/libc-2.1.3.so
-rw-r--r--   1 root root 20272704 Feb 29  2000 /usr/lib/libc.a
-rw-r--r--   1 root root  178 Feb 29  2000 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql-3.23.32 
--with-mysqld-user=mysql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: HELP: C API: mysql_query INSERT not working...

[Sinisa Milivojevic]

James Gosnell writes:
> 
> I'm not getting any errors at all and the program runs just fine, except
> that it's not inserting! :) selects work and everything else. Am I
> missing a function or structure? Thanks...
> 
> James Gosnell
> [EMAIL PROTECTED]#include 
> #include 
> #include 
> 

You should escape qotes for constat strings.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Date format problem

[Sebastiaan J.A. Kamp]

What programming language are you using?


Hi guys, does anyone help me with this simple thing ??

I have a date format problem, I need a spanish format please read the
following lines:

Receive from input "28/06/2001"
Want to change it to "2001-06-28" to write the Database
Use to do it "DATE_FORMAT (inputdate, %Y-%m-%d)"

It doesn't work fine

Thanks a lot for your time



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Trouble with mysql

[Michael Widenius]

Hi!

> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:

Peter> Hello Michael,
Peter> Thursday, June 28, 2001, 1:52:09 PM, you wrote:

Peter> I started to often get the followings in a log file:

Peter> 010628 13:49:28  Aborted connection 627619 to db: 'counter' user: 'titan' host: 
`pan.local' (Got an error reading communication packets)
Peter> 010628 13:49:35  read_key: Got error 134 when reading table 
'./counter/counterlayers'
Peter> 010628 13:49:35  read_key: Got error 134 when reading table 
'./counter/counterlayers'

Peter> All the times for the same table.  The strange thing is - I do ONLY
Peter> selects and updates for this table, therefor I got the followings then
Peter> I'm trying to check and repair it.

mysql> check table counter.counterlayers;
Peter> 
+---+---+--+---+
Peter> | Table | Op| Msg_type | Msg_text   
   |
Peter> 
+---+---+--+---+
Peter> | counter.counterlayers | check | error| Record-count is not ok; is 166853  
 Should be: 166912 |
Peter> | counter.counterlayers | check | warning  | Found 59 deleted blocks   
Should be: 0|
Peter> | counter.counterlayers | check | error| Corrupt
   |
Peter> 
+---+---+--+---+
Peter> 3 rows in set (0.49 sec)

mysql> repair  table counter.counterlayers;   
Peter> 
+---++--+--+
Peter> | Table | Op | Msg_type | Msg_text  
   |
Peter> 
+---++--+--+
Peter> | counter.counterlayers | repair | warning  | Number of rows changed from 
166912 to 166853 |
Peter> | counter.counterlayers | repair | status   | OK
   |
Peter> 
+---++--+--+
Peter> 2 rows in set (1.94 sec)

Peter> As you see 59 rows are deleted therefore noone did it.

Any change you can start mysqld with --log-bin, so that you can verify
this if this happens again?

Regards,
Monty

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: setting up MySql database

[massey]

http://www.mysql.com/manual.php (the manual) Your New Friend

-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 6/28/01 13:21
SUBJECT: setting up MySql database

Hello everyone,
I am a beginner, can you please put me through setting up
MySql database downloaded from the site http://www.mysql.com .  
I could have downloaded the wrong thing.
Thanks.
Dots.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie problem with winmysqladmin

[Michael Tam]

Hi All,

I am new to MySQL and have a problem using winmysqladmin.  MySQL is working fine, 
which I can access the database from my Java apps.  However, when I tried to use 
winmysqladmin to obtain my db and table info, winmysqladmin never connects with MySQL 
and I can't obtain the info.  

In addition, beside winmysqladmin, what other gui program will allow me to obtain 
those info?

If anybody can give me a direction to where I should look into, that would be 
great and appreciated.

Thank you.

Best regards,
Michael Tam

Re: Re:innobase bug w/ 3.23.29???

[Michael Widenius]

Hi!

> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:

Heikki> Hi!
Heikki> I checked that in the COUNT(*) below InnoDB does
Heikki> not fetch the whole row if it does the query through
Heikki> a secondary index. It may sometimes have to
Heikki> fetch it to determine if the row should be visible
Heikki> in the current consistent read, the trx id is
Heikki> stored in the whole row in the primary key index.
Heikki> But Ryan said that queries were CPU-bound,
Heikki> and fetching a million rows through a primary key
Heikki> should at most take 10 s.

Heikki> Regards,

Heikki> Heikki
Heikki> http://www.innodb.com

This sounds like we would need a test case to solve this...

Ryan, any change you could provide us with a script that would
generate data for a testcase ?

Regards,
Monty

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Date format problem

[MikeBlezien]

On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla <[EMAIL PROTECTED]>
wrote:

You would need to reformat the input date first, within your middleware, like
Perl or PHP. Then you would be able to enter it into your db.

 
>>Hi guys, does anyone help me with this simple thing ??
>>
>>I have a date format problem, I need a spanish format please read the following 
>lines:
>>
>>Receive from input "28/06/2001"
>>Want to change it to "2001-06-28" to write the Database
>>Use to do it "DATE_FORMAT (inputdate, %Y-%m-%d)"
>>
>>It doesn't work fine
>>
>>Thanks a lot for your time
>>
>>
>>Lic. Alejandro Ralla
>>Districomp S.A
>>Magallanes 1688
>>Montevideo 11200
>>Uruguay
>>
>>(5982)400-1115 int 119
>>[EMAIL PROTECTED]
>>
>>www.districomp.com

Mike(mickalo)Blezien

Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
















-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

cursor definition

[Yamuna Vallipuram]

Hi...

I am new to MySQL and trying to write some database queries.

(Basically, I am developing a WEB application using Pearl script. The data 
is stored in MySQL database. Pearl scripts access the database via Pearl 
DBI)

I could not find any info about cursor definitions in MySQL documentations.

How do I write the following Oracle code in MySQL.

Cursor CurPerson is
Select Arstall_Godkj_Stkomp
From  Person
Where Fodselsdato  = inFDato   And
  Personnr = inPNr;;

  Begin
 Open curPerson;
 Fetch CurPerson into refGodkjent;
 If curPerson%Found Then

Thank you

Yamuna
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Inserting values into table

[Gerald Clark]

Jon Haworth wrote:

> Hi list,
> 
> Sorry if this appears twice, our mail server is playing up at the moment.
> 
> We've got an sql file that was created using mysqldump on an NT box. The
> info in this file needs to be imported into MySQL on a Linux box. When I run
> 
>/usr/local/mysql/bin/mysql < /home/jon/dump.sql

/usr/local/mysql/bin/mysql foo < /home/jon/dump.sql

You might be loading into table foo of a different database than you think.


> 
> I get "Error 1062 at line 50: duplicate entry '1' for key 1".
> 
> 
> The guilty area of the sql file looks like this:
> 

alternately add here:

use foo;



> CREATE TABLE foo (
>   ID int(10) unsigned NOT NULL auto_increment,
>   Tag varchar(50) NOT NULL default '',
>   Category varchar(50) NOT NULL default '',
>   PRIMARY KEY (ID)
> ) TYPE=MyISAM;
> 
> INSERT INTO foo VALUES (1,'some text','some more text'); /* line 50! */
> INSERT INTO foo VALUES (2,'some text','some more text'); 
> INSERT INTO foo VALUES (3,'some text','some more text'); 
> etc
> 
> 
> The /usr/local/mysql/data/foo directory is empty, all I've done is enter
> "create database foo" into the mysql console.
> 
> Aaargh! What am I missing? This sql file was created by MySQL and I haven't
> altered it apart from putting a "USE MyDatabase" line at the top.
> 
> Any ideas?
> 
> 
> Cheers
> Jon
> 
> 
> 
> 
> 
> 
> ___
>  Get 100% private, FREE email for life from Excite UK
>  Visit http://inbox.excite.co.uk/ 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Frequent server side crash on FreeBSD

[Katy Agnor]

I am running mysql version 3.22.32 on freebsd version 4.2   I am running a
high traffic BBS on an Apache web server (PERL) that connects to the
database server through DBI.  MySQL is crashing every two minutes or so.

- My file descriptors and max files are set high, per process and for the
system.
- It looks like there is a lot of system memory free.
- It doesn't look like there is any complex query.

We ran a few traces.  There's no particular pattern.  I also noticed a lot
of errnum: 35 errors.

What can we do to shoot this problem?  What traces would be helpful?

-ka

--
Katy Agnor
aka LonghornGirlie
[EMAIL PROTECTED]
(512) 762-5883 (voice)
(512) 474-7881 (fax)
http://www.hornfans.com

Hook 'em Horns!


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

setting up MySql database

[mit00oa]

Hello everyone,
I am a beginner, can you please put me through setting up
MySql database downloaded from the site http://www.mysql.com .  
I could have downloaded the wrong thing.
Thanks.
Dots.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[Dave Halliday]

I will give this a shot - thanks!!!

Dave



> > 
> > There doesn't seem to be a standard identifier in the messages and
> > although I am filtering the entire header looking for instances of "
> > mysql " my reader ( Pegasus ) doesn't always catch it.
> [snipped to conserve bandwidth]
> 
> Type of rule:
> Regular expression match
> 
> Text to match:
> List-ID: 
> 
> In headers only.
> 
> That should do the trick, at least it does for me.
> 
> -jan





David G. Halliday
The Glosten Associates
600 Mutual Life Building
605 First Avenue
Seattle, WA 98104-2224
(206) 624-7850

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MYSQL errmsg.sys

[Miguel Angel Solórzano]

At 18:18 28/06/2001 +0200, PABLOSKY® wrote:
Hi,

Thanks for the bug report.
Sorry for the inconvenience with the partial translation of
the errmsg.sys file. I will the translation and send you the
new errmsg.sys as fast as possible.


Regards,
Miguel

>Dear friends,
>
> I'd like to know how to compile my own 'errmsg.txt'  to 'errmsg.sys'. 
> I know that there is an utility called 'comp_err'  but i dind'nt find it 
> in the Windows distribution of MYSQL.
> The matter is that the error message file for spanish language in the 
> last distribution isn't completely translated, that is, it's wrong 
> translated. If anyone know about the correct spanish 'errmsg.sys' or know 
> how to compile the text file from Windows, or has the 'comp_err' utility 
> please answer me or send me it.
>
> Thanks in advance.
>
> Luis Martin-Caro
> SPAIN

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Date format problem

[Alejandro Ralla]

Hi guys, does anyone help me with this simple thing ??

I have a date format problem, I need a spanish format please read the following lines:

Receive from input "28/06/2001"
Want to change it to "2001-06-28" to write the Database
Use to do it "DATE_FORMAT (inputdate, %Y-%m-%d)"

It doesn't work fine

Thanks a lot for your time


Lic. Alejandro Ralla
Districomp S.A
Magallanes 1688
Montevideo 11200
Uruguay

(5982)400-1115 int 119
[EMAIL PROTECTED]

www.districomp.com

RE: message traffic

[William M. Quarles]

Why are you complaining, Don Read?  I think the guy is making a worthy 
suggestion, and since you are so "flawless", good job getting the lsit name 
wrong.

--On Thursday, June 28, 2001 12:53 -0500 Don Read <[EMAIL PROTECTED]> wrote:

>
> On 28-Jun-01 Dave Halliday wrote:
>> Quick question - just signed up for this list and I was wondering if it
>> would be possible to put a "  [MySQL]  " tag in the subject line?
>>
>
> You just signed up & want everybody to accomodate your broken mailer.
>
>> There doesn't seem to be a standard identifier in the messages and
>> although I am filtering the entire header looking for instances of "
>> mysql " my reader ( Pegasus ) doesn't always catch it.
>>
>
> filter on the List-ID: mysql.mysql.com
>
>>
>> Most other lists I subscribe to either have the tag at the beginning
>> of the subject line or spoof the address to read the list origin.
>> Either way allows for flawless filtering.
>>
>
> I'm on 10 other lists & only one (PHP) does that kind of nonsense.
>
>> Before posting, please check:
>  ..
>>http://lists.mysql.com/   (the list archive)
>
> --
> Don Read   [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to
>steal the neighbor's newspaper, that's the time to do it.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-- 
William M. Quarles
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Applet problem

[gtaylor]

Hi,

We have been running MySQL for a while accessing it with the MM driver
and in applications everything works well.  I'm a newbie in trying to
build an applet, and when I try to access the driver to make a connection,
I get a "notinited" error in the browser.  In the Apache error_log
is a message that (applet directory)/org "file does not exist".  After
putting a symbolic link to the directory where the MM driver "org" directory
is, Apache can find the driver.  If the driver path is in Apache's 
CLASSPATH directive, why can't it find it like an Application can?

Thanks for any help.

George

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete a

[Don Read]

On 28-Jun-01 Jawad Khan wrote:
> Hope you can find the problem in the following SQL command:
> 
> delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
> limit 1 ;
> 

That is a sub-select, currently unsupported in MySQL.

try :
 delete from alarms order by raiseTime limit 1;

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: More questions about Fulltext searching.

[Matthew Brealey]

 --- Stoyan <[EMAIL PROTECTED]> wrote: > hi,
> 
> why don't you try to use this:
> 
> SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%';

That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles')
and match author against('dickens')) takes 1.3 seconds. Fulltext searching
is MUCH more efficient.

=



Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Integrity checks

[ryc]

When you delete a row from a table that may be referenced in another
table... you must delete all references to it from the other tables. This is
done in the same way in which you deleted the first row...

ryan

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> As long as MySQL doesn't manage the foreign keys, how do you manage
> the deletion of a record if it is referenced in another table's
> record?
> I am working in ASP, but I will be intersted by solution in any
> programming language.
>
> Thanks,
>
> Nicolas.
>
> passpharse : database,mysql
>
> -BEGIN PGP SIGNATURE-
> Version: PGP 7.0.4
>
> iQA/AwUBOzrqB4iKIkRfAqJVEQKt1ACglEJufod2+1A6jHOWh+pDUqLhUJ0AoNTC
> 3UMqv+qnk9VUCtJkLznjH7w5
> =tmED
> -END PGP SIGNATURE-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Unique select

[Don Read]

On 28-Jun-01 Matt \"TrollBoy\" Wiseman wrote:
> I'm attempting to do a select via PHP where I want to get a list of unique
> records for example if my table is as follows
> +-+--+
>| bluefish|  blah|
> +-+--+
>| bluefish|  blah|
> +-+--+
>| redfish |  blah|
> +-+--+
>| greenfish   |  blah|
> +-+--+
>| redfish |  blah|
> +-+--+
> 

select distinct ...

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re:innobase bug w/ 3.23.29???

[ryc]

> ryc> 
> Heikki> Well, mystery solved :). Except that why MySQL uses hours to
> Heikki> sieve away the extraneous rows in the first query.
> >>
> >> To be able to answer the question why:
> >>
> >> SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0
> >>
> >> Is slow, I would need to get an EXPLAIN for this query.
>
> mysql> explain select count(*) from messages where clean=0 and
> ryc> parentmsgid=0;
>
> ryc>
+--+---+---+-+-+--+-
> ryc> +-+
> ryc> | table| type  | possible_keys | key | key_len | ref  |
rows
> ryc> | Extra   |
> ryc>
+--+---+---+-+-+--+-
> ryc> +-+
> ryc> | messages | index | parentmsgid   | parentmsgid |   5 | NULL |
7207120
> ryc> | where used; Using index |
> ryc>
+--+---+---+-+-+--+-
> ryc> +-+
>
> How many rows satisfies the query?  Is it about 7207120 rows ?
>
> Heikki, could it be that InnoDB will read the original row through the
> primary key even if MySQL has marked that it would be happy if InnoDB
> only returned the found keys from the secondary index ?
>

A total of 5 rows match this query.

ryan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: message traffic

[Don Read]

On 28-Jun-01 Dave Halliday wrote:
> Quick question - just signed up for this list and I was wondering if it 
> would be possible to put a "  [MySQL]  " tag in the subject line?
> 

You just signed up & want everybody to accomodate your broken mailer.

> There doesn't seem to be a standard identifier in the messages and 
> although I am filtering the entire header looking for instances of " 
> mysql " my reader ( Pegasus ) doesn't always catch it.
> 

filter on the List-ID: mysql.mysql.com

> 
> Most other lists I subscribe to either have the tag at the beginning 
> of the subject line or spoof the address to read the list origin.  
> Either way allows for flawless filtering.
> 

I'm on 10 other lists & only one (PHP) does that kind of nonsense.

> Before posting, please check:
 ..
>http://lists.mysql.com/   (the list archive)

-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)

[Jawad Khan]

server version 3.23.35

>  -Original Message-
> From: Khan, Jawad [COLE:6S34:EXCH]  
> Sent: Thursday, June 28, 2001 1:13 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
> as shown
> 
> Hope you can find the problem in the following SQL command:
> 
> delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
> limit 1 ;
> 
> raiseTime is of type BIGINT.

RE: Must use '#' in fieldnames

[Brian Kaney]

Here's a messy hack that would let you use your column names like
'a35#70' to select and insert.

Set up a table like this:

col1a35#70
col2a35#71
col3a35#72
...

Then make a routine in your middleware that select * from this
table and returns the results in a named array or hash array
(i.e. in perl: $col{'a35#70'} returns 'col1').

Now you can reference the legal column names using your funny
column names in any sql statement using this hash:

select $col{'a35#70'} from data_table
and/or
insert into data_table ( $col{'a35#70'} ) values (  )


Brian



-Original Message-
From: Roger Karnouk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 11:53 AM
To: Dirk Ostertag; [EMAIL PROTECTED]
Subject: RE: Must use '#' in fieldnames


if you just need to call your field a35#70
for retrieval purposes

why don't you call it something else and alias it in your select
statements.

select col1 as 'a35#70' from test;

if this doesn't help perhaps explain why you absolutely need your
field
named a35#70.

it will make it easier to find you a work around.

Roger

-Original Message-
From: Dirk Ostertag [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:09 AM
To: [EMAIL PROTECTED]
Subject: Must use '#' in fieldnames


Hello everybody,

I have to create a table on a MySQL-Server with fieldnames like
a35#70.
if I ty it that way

create table test (
a35#70 char (70));

on the mysql - prompt, the creation fails. Even brackets like in
MsSQL
or '`' doesn't help.
Can anybody tell me what to do?

thank
Dirk



-

Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail
<[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php

-

Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail
<[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: message traffic

[Jan Muszynski]

On 28 Jun 2001, at 8:44, Dave Halliday wrote:

> Quick question - just signed up for this list and I was wondering if it 
> would be possible to put a "  [MySQL]  " tag in the subject line?

Please - no, those take up to much room and remove from the Subject area. I *hate* 
those tags, they're useless. There's always *something* to filter on.

> 
> There doesn't seem to be a standard identifier in the messages and 
> although I am filtering the entire header looking for instances of " 
> mysql " my reader ( Pegasus ) doesn't always catch it.
[snipped to conserve bandwidth]

Type of rule:
Regular expression match

Text to match:
List-ID: 

In headers only.

That should do the trick, at least it does for me.

-jan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Unique select

[Matt \"TrollBoy\" Wiseman]

I'm attempting to do a select via PHP where I want to get a list of unique
records for example if my table is as follows
+-+--+
| bluefish|  blah|
+-+--+
| bluefish|  blah|
+-+--+
| redfish |  blah|
+-+--+
| greenfish   |  blah|
+-+--+
| redfish |  blah|
+-+--+

I want it to return only "bluefish,redfish,greenfish" when I make a query on
the first field.  Does anyone know how this is possible?

Matt "TrollBoy" Wiseman
Webmaster: Shoggoth.net
Site Designer: phpslash.org
The oldest and strongest emotion of mankind is fear,
and the oldest and strongest kind of fear is fear of the unknown.
-H.P. Lovecraft
-
Please do not resell my e-mail address
to anyone or send me unsolicited e-mail
-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as sho wn

[Jawad Khan]

Hope you can find the problem in the following SQL command:

delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;

raiseTime is of type BIGINT.

MYSQL errmsg.sys

[PABLOSKY®]

Dear friends,

I'd like to know how to compile my own 'errmsg.txt'  to 'errmsg.sys'. I know that 
there is an utility called 'comp_err'  but i dind'nt find it in the Windows 
distribution of MYSQL.
The matter is that the error message file for spanish language in the last 
distribution isn't completely translated, that is, it's wrong translated. If anyone 
know about the correct spanish 'errmsg.sys' or know how to compile the text file from 
Windows, or has the 'comp_err' utility please answer me or send me it.

Thanks in advance.

Luis Martin-Caro
SPAIN

Help - Create Views

[Simon]

Hello,

I am just learning Mysql and was reading a general SQL book.  The book talks
about creating views for joins (CREATE VIEW ...)that you regularly use.  I
can not find out if Mysql supports this and if it does, how do I perform
this.

Thank you in advance,

Bob


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Data disappearing problem

[Michael Hebert]

Hi,

I'm having a very annoying and elusive problem. You probably won't be able 
to help me, but any guess or pointer would be appreciated nonetheless.

The main table in the db contains some 50 fields, mostly of type varchar 
and tinyint. This table is updated through php.

Now the problem is: sometimes some of the data for a specific record goes 
missing after I access a page. I cannot reproduce the problem. Only certain 
fields are affected, and these fields vary every time the problem occurs. 
These fields are somewhat reset, but I say 'somewhat' because they don't 
necessarily go to the default value specified in MySQL. The UPDATE queries 
on the page that *seem* to be where the problem occurs are all valid and 
well-formed, and some of the fields that get reset are not even in those 
queries at all.

This has been specifically occuring on a machine using Win98/Netscape4 to 
access the page.

The server is running Cobalt Linux release 6.0 (Shinkansen-Decaf)
Kernel 2.2.16C24_III on an i586, MySQL-3.23.36-1, php-4.0.3pl1-C1r4, 
apache-1.3.12-1C9

I know this is not very much information, and it's not helpful that I can't 
reproduce it... Anything leaps to mind as something I could check or look 
for?, any wild guess, anything would be appreciated.

Could MySQL be doing it? What else could it be?

Thanks.

Michael Hebert
D.Black Communications


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: restoring one table from a mysqldump --all

[Don Read]

On 28-Jun-01 Dave Brown wrote:
> Is there an easy way to restore just one table from a mysqldump of all the
> tables?
> 

If the (empty) table already exists:
grep " INTO table VALUES " backup.dmp | mysql dbname

If it doesn't then use awk to create it:
awk '/^CREATE TABLE table/,/^);/' backup.dmp | mysql dbname

then the grep above.

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Inserting values into table

[Jon Haworth]

Hi list,

Sorry if this appears twice, our mail server is playing up at the moment.

We've got an sql file that was created using mysqldump on an NT box. The
info in this file needs to be imported into MySQL on a Linux box. When I run

   /usr/local/mysql/bin/mysql < /home/jon/dump.sql

I get "Error 1062 at line 50: duplicate entry '1' for key 1".


The guilty area of the sql file looks like this:

CREATE TABLE foo (
ID int(10) unsigned NOT NULL auto_increment,
Tag varchar(50) NOT NULL default '',
Category varchar(50) NOT NULL default '',
PRIMARY KEY (ID)
) TYPE=MyISAM;

INSERT INTO foo VALUES (1,'some text','some more text'); /* line 50! */
INSERT INTO foo VALUES (2,'some text','some more text'); 
INSERT INTO foo VALUES (3,'some text','some more text'); 
...etc


The /usr/local/mysql/data/foo directory is empty, all I've done is enter
"create database foo" into the mysql console.

Aaargh! What am I missing? This sql file was created by MySQL and I haven't
altered it apart from putting a "USE MyDatabase" line at the top.

Any ideas?


Cheers
Jon






___
 Get 100% private, FREE email for life from Excite UK
 Visit http://inbox.excite.co.uk/ 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

cannot open shared libraries

[Vien Huynhle]

I get this error on my mysql client

(filter): error in loading shared libraries
libmysqlclient.so.10: cannot open shared object file: No such file or directory

Vien Huynhle
Clearsail Communications

RE: Must use '#' in fieldnames

[Roger Karnouk]

if you just need to call your field a35#70
for retrieval purposes

why don't you call it something else and alias it in your select statements.

select col1 as 'a35#70' from test;

if this doesn't help perhaps explain why you absolutely need your field
named a35#70.

it will make it easier to find you a work around.

Roger

-Original Message-
From: Dirk Ostertag [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:09 AM
To: [EMAIL PROTECTED]
Subject: Must use '#' in fieldnames


Hello everybody,

I have to create a table on a MySQL-Server with fieldnames like a35#70.
if I ty it that way

create table test (
a35#70 char (70));

on the mysql - prompt, the creation fails. Even brackets like in MsSQL
or '`' doesn't help.
Can anybody tell me what to do?

thank
Dirk



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

message traffic

[Dave Halliday]

Quick question - just signed up for this list and I was wondering if it 
would be possible to put a "  [MySQL]  " tag in the subject line?

There doesn't seem to be a standard identifier in the messages and 
although I am filtering the entire header looking for instances of " 
mysql " my reader ( Pegasus ) doesn't always catch it.


Most other lists I subscribe to either have the tag at the beginning 
of the subject line or spoof the address to read the list origin.  
Either way allows for flawless filtering.


Thanks!
Dave




David G. Halliday
The Glosten Associates
600 Mutual Life Building
605 First Avenue
Seattle, WA 98104-2224
(206) 624-7850

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

restoring one table from a mysqldump --all

[Dave Brown]

Is there an easy way to restore just one table from a mysqldump of all the
tables?

Dave

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: thoughts on raw file systems

[Ilya Martynov]

WW> Can you use a raw partition with MySQL much like you can with Oracle or
WW> Sybase?

Probably tables with InnoDB type can work on raw devices.

-- 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80  E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/)  |
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Creating Table with a Default Datetime field

[Paul DuBois]

At 11:57 AM +0200 6/28/01, Kaneda K wrote:
>At 10:38 27/06/2001 -0700, you wrote:
>>Sorry, for quoting the manual but this might be just another example where
>>it could have the answer right away:
>>Hannes
>>
>>http://www.mysql.com/doc/D/A/DATETIME.html
>
>On my own mysql version :
>  Date TIMESTAMP default "now()",
>Works correctly, the date is MMDDHHmmss format, but the values 
>are set automattically and correctly, so, could it be your mysql 
>version ?

It works as you seem to expect, but not for the reason you think.
If you try SHOW COLUMNS FROM tbl_name, I expect you'll find that MySQL
ignored your default value specification and set it to NULL.

In any case "now()" is a string, not a function call.  What you've
really attempted to do is set the default value to a literal string,
not a function that evaluates to the current date and time.


>
>
>--
>System Info :
>Red Hat Linux release 6.2 (Zoot)
> Kernel 2.2.14-5.0 on an i686
>Mysql Ver 11.12 Distrib 3.23.32
>java version "1.3.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0)
> Java HotSpot(TM) Client VM (build 1.3.0, mixed mode)
>JDBC Driver : mm.mysql-2.0.4-bin.jar
>Tomcat 3.2 beta 3


-- 
Paul DuBois, [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Request for posting of Solaris package of MySQL 3.23 distributions

[bjbyerly]

I would greatly appreciate your posting of a Solaris package
of the MySQL 3.23 distributions in order to simplify installations
on a Solaris platform.  Please cc me directly in your response
if this would be possible.

many thanks for your help,
Bryan

Bryan J. Byerly
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Must use '#' in fieldnames

[dostert]

Because our company works with a standard - tabledefinition in
many enviroments like db2, mssql ... So I got no choice but to use
those crazy fieldnames.
And because the fieldnames work fine on the other db-systems we
use, I hoped there is a trick that lets even MySQL work with these
names.


Mit freundlichem Gruß

D. Ostertag

_
B&N Software AG
Telefon: 0551/693390
eMail: [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Imagenes en mysql

[Nicole Lallande]

Carlos - si - las imagenes se pueden almanecer en mysql - el typo de
campo es 'blob'.

Nicole


[EMAIL PROTECTED] wrote:
> 
> Hola,
> para un desarrollo en java con acceso a una base de
> datos en MySQL, necesitaria saber si alguien ha
> implementado imagenes con MySQL? . ¿Se pueden almacenar
> imagenes en esta base de datos, cómo debe ser el tipo
> de campo?
> 
> Gracias,
> 
> Carlos Miglioli
> Gobierno de Mendoza ARG.
> [EMAIL PROTECTED]
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 

Nicole Lallande
[EMAIL PROTECTED]
760.753.6766


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Must use '#' in fieldnames

[Werner Stuerenburg]

> create table test (
> a35#70 char (70));


Looks like the reason is # is the remark sign like // in php

Why don't you call the columns any name? Then you write

INSERT INTO table
(col1, col2)
VALUES ('a35#70', 'id')

or whatever.


-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: thoughts on raw file systems

[Wyly Wade]

why not... it improves speed and removes the overhead and limitations of
the FS.

-Original Message-
From: David Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 9:20 AM
To: Wyly Wade
Subject: RE: thoughts on raw file systems


I certainly hope not :)

-Original Message-
From: Wyly Wade [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 8:07 PM
To: [EMAIL PROTECTED]
Subject: thoughts on raw file systems


Can you use a raw partition with MySQL much like you can with Oracle or
Sybase?
 
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suit 104
Tampa Fl, 33606
813-253-2267

 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Innodb and timestamps

[Heikki Tuuri]

Hi!

Thank you for the bug report. 3 lines of code had been omitted
from mysql/sql/ha_innobase.cc and that causes the timestamp
not to be updated in a row update.

If you compile yourself you can use the patch below.
Add the lines marked with '+' to function ha_innobase::update_row.

Best regards,

Heikki
http://www.innodb.com

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: donna.mysql.fi
# Root: /home/heikki/mysqlf

--- 1.34/sql/ha_innobase.cc Thu Jun  7 00:10:57 2001
+++ 1.35/sql/ha_innobase.cc Thu Jun 28 17:19:34 2001
@@ -1523,6 +1523,10 @@
 
DBUG_ENTER("ha_innobase::update_row");
 
+if (table->time_stamp) {
+update_timestamp(new_row + table->time_stamp - 1);
+   }
+
if (last_query_id != user_thd->query_id) {
prebuilt->sql_stat_start = TRUE;
 last_query_id = user_thd->query_id;


At 02:55 PM 6/28/01 +0300, you wrote:
>Content-Type: message/rfc822
>Content-Description: forwarded message
>Content-Transfer-Encoding: 7bit
>
>Subject: Innodb and timestamps
>From: Noel Clarkson <[EMAIL PROTECTED]>
>To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Date: Thu, 28 Jun 2001 12:10:12 +1000
>Organization: UCA
>
>Hi there,
>
>I'm using MaxSQL 3.23.39 and have set up an innodb table but when I run an 
>update statement the timestamp field does not update automatically.  Is 
>anyone else experiencing this, or is it an expected behaviour of innodb 
>tables?  I couldn't find anything in the manual saying that this was 
>different for innodb tables.  Below is an example of what I did and the 
>results.
>
>running on Red Hat linux 6.1.
>
>cheers,
>
>noel
>
>mysql> create table tbl_test(name varchar(10), lastedit timestamp) 
>type=innodb;
>Query OK, 0 rows affected (0.04 sec)
>
>mysql> describe tbl_test;
>+--+---+--+-+-+---+
>| Field| Type  | Null | Key | Default | Extra |
>+--+---+--+-+-+---+
>| name | varchar(10)   | YES  | | NULL|   |
>| lastedit | timestamp(14) | YES  | | NULL|   |
>+--+---+--+-+-+---+
>2 rows in set (0.01 sec)
>
>mysql> insert into tbl_test(name) values('bob');
>Query OK, 1 row affected (0.00 sec)
>
>mysql> insert into tbl_test(name) values('ted');
>Query OK, 1 row affected (0.00 sec)
>
>mysql> select * from tbl_test;
>+--++
>| name | lastedit   |
>+--++
>| bob  | 20010613171610 |
>| ted  | 20010613171618 |
>+--++
>2 rows in set (0.00 sec)
>
>mysql> update tbl_test set name='fred' where name='ted';
>Query OK, 1 row affected (0.00 sec)
>Rows matched: 1  Changed: 1  Warnings: 0
>
>mysql> commit;
>Query OK, 0 rows affected (0.03 sec)
>
>mysql> select * from tbl_test;
>+--++
>| name | lastedit   |
>+--++
>| bob  | 20010613171610 |
>| fred | 20010613171618 |
>+--++
>2 rows in set (0.00 sec)
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>Content-Type: text/plain; charset=us-ascii
>Content-Description: message body and .signature
>Content-Transfer-Encoding: 7bit
>
>
>Something for you.
>
>-- 
>Regards,
>   __  ___ ___   __
>  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
>/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
>   <___/   www.mysql.com
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

HELP: C API: mysql_query INSERT not working...

[James Gosnell]

I'm not getting any errors at all and the program runs just fine, except
that it's not inserting! :) selects work and everything else. Am I
missing a function or structure? Thanks...

James Gosnell
[EMAIL PROTECTED]

#include 
#include 
#include 




int main (void) {

MYSQL *connection, mysql;


if (!mysql_init(&mysql)) {

printf("Error initializing MySQL client\n");
exit(1);
}

if (!(connection = mysql_real_connect(&mysql, "localhost", "root", "fender", "", 
0, "/tmp/mysql.sock", 0)))
printf(mysql_error(&mysql));

if (mysql_stat(connection)) printf("%s\n", mysql_stat(&mysql));

if ((mysql_query(connection, "insert into customer
(last_name,first_name,middle_name,address,city,state,zip,home_phone) VALUES
('Gosnell','James','Matthew','1008 Rhoads Hall','Terre
Haute','IN','47809','812-237-7094')")))
   mysql_error(connection);


mysql_close(connection);

exit(1);

}



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Got timeout reading communication packets

[Seth Northrop]

Hi!

> How do you know that row  is truncated  ??
>

Filesizes for one.  With just this single query the database is ca. 65K,
the update log with just this query in it is ~600k.

> If you have binary data in the blob field, when you retreive a result
> set, you will get it back in the binary, unescaped form.
>

I can't imagine there is any binary data in there.  See the php script in
the previous email.. it just increments a counter and stores in a sring.
It also reacts the same way with a text field.  Also, it's truncating
right in the middle of one of the incremented numbers...

 12770   12771   12772   12773   1 |

> Query the lengths returned to make sure that data is truncated.
>

mysql> select length(data) from measurement_extended_data;
+--+
| length(data) |
+--+
|65535 |
+--+
1 row in set (0.05 sec)

[internal mysql]# wc /tmp/update.002
4  100046  589227 /tmp/update.002

> If you are sure, send me CREATE TABLE statement and INSERT instead of
> REPLACE statement, so that I can test it.
>

# here's the create statement.. the only thing really abnormal
# is the size of the primary key (compound)

CREATE TABLE measurement_extended_data (
  content_typeID tinyint(3) unsigned NOT NULL default '0',
  contentID int(10) unsigned NOT NULL default '0',
  arrayID smallint(5) unsigned NOT NULL default '0',
  positionID mediumint(8) unsigned NOT NULL default '0',
  testID smallint(5) unsigned NOT NULL default '0',
  iteration smallint(5) unsigned NOT NULL default '0',
  test_locationID smallint(5) unsigned NOT NULL default '0',
  date_added int(10) unsigned NOT NULL default '0',
  added_by mediumint(8) unsigned NOT NULL default '0',
  data text NOT NULL,
  PRIMARY KEY
(content_typeID,contentID,arrayID,positionID,testID,iteration),
  KEY test_locationID (test_locationID),
  KEY testID (testID)
) TYPE=MyISAM;

Update log attached in seperate email.

Take care,
seth

---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910 Freedom Circle, Suite 103
Santa Clara, CA 95054
voice:  408-970-8881 x147
fax:408-970-8840
http://www.reflectivity.com/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Must use '#' in fieldnames

[Dirk Ostertag]

Hello everybody,

I have to create a table on a MySQL-Server with fieldnames like a35#70.
if I ty it that way

create table test (
a35#70 char (70));

on the mysql - prompt, the creation fails. Even brackets like in MsSQL
or '`' doesn't help.
Can anybody tell me what to do?

thank
Dirk



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Imagenes en mysql

[carlosm]

Hola,
para un desarrollo en java con acceso a una base de 
datos en MySQL, necesitaria saber si alguien ha 
implementado imagenes con MySQL? . ¿Se pueden almacenar 
imagenes en esta base de datos, cómo debe ser el tipo 
de campo?

Gracias,

Carlos Miglioli
Gobierno de Mendoza ARG.
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem in Using two web servers

[Gerald Clark]

This is really quite basic.
Server B must be running with PHP and mysql support.
It connects to mysqld on server A, which must have granted the proper 
privileges to server B

Maneet Puri wrote:

> Dear Sir,
> 
> I am trying to connect to the MYSQL server running on web server say A, thru my 
>scripts which are hosted on web server say B.
> 
> I am not able to connect to the mysql server. I am using PHP for connecting to the 
>MYSQL server running on web server A.
> 
> Please let me know how can I connect to the MYSQL server thru my scripts which are 
>not on the server on which MYSQL server is running.
> 
> Waiting for your reply.
> 
> Regards,
> 
> Maneet


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select query for duplicate records

[Pete Kuczynski]

That makes sense, sound like I'm redoing in PHP what the UNIQUE column
already does.
So all I need to do is modify my PHP trap using mysql_affected_rows() =
0, retun a error messagu to the used indicating a rcord already exists.
Will try it, THX!
Pete

Paul DuBois wrote:
> 
> At 5:46 PM -0500 6/27/01, Pete Kuczynski wrote:
> >Thanks Paul!
> >ps works great!
> >I modified the database with a UNIQUE column like you recommended
> >earlier, this will now help in the PHP script to trap the duplicate
> >entry and advise the user of the dup.
> 
> But if hostname now has a UNIQUE index on it, it won't even be possible
> for your table to have duplicate hostname values, other than NULL.
> 
> Probably all you need to do is just go ahead and try to insert the record,
> and if mysql_affected_rows() is 0, it was a duplicate and was rejected.
> 
> >
> > > // check for duplicate row
> > $query = "SELECT hostname, COUNT(*) AS count FROM asset
> >   GROUP BY hostname HAVING count > 1
> > $result = mysql_query($query);
> > // check if row is returned, if yes error, if no insert
> > if (mysql_num_rows($result) != 0) {
> > echo "error";
> > } else {
> > // DO INSERT
> > }
> > ?>
> >
> >Pete
> 
> --
> Paul DuBois, [EMAIL PROTECTED]

-- 
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re:innobase bug w/ 3.23.29???

[Heikki Tuuri]

Hi!

I checked that in the COUNT(*) below InnoDB does
not fetch the whole row if it does the query through
a secondary index. It may sometimes have to
fetch it to determine if the row should be visible
in the current consistent read, the trx id is
stored in the whole row in the primary key index.
But Ryan said that queries were CPU-bound,
and fetching a million rows through a primary key
should at most take 10 s.

Regards,

Heikki
http://www.innodb.com

-Original Message-
From: Michael Widenius <[EMAIL PROTECTED]>
To: ryc <[EMAIL PROTECTED]>; Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, June 28, 2001 1:26 PM
Subject: Re: Re:innobase bug w/ 3.23.29???


>
>Hi!
>
>> "ryc" == ryc  <[EMAIL PROTECTED]> writes:
>
>ryc> 
>Heikki> Well, mystery solved :). Except that why MySQL uses hours to
>Heikki> sieve away the extraneous rows in the first query.
>>>
>>> To be able to answer the question why:
>>>
>>> SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0
>>>
>>> Is slow, I would need to get an EXPLAIN for this query.
>
>mysql> explain select count(*) from messages where clean=0 and
>ryc> parentmsgid=0;
>
>ryc>
+--+---+---+-+-+--+-
>ryc> +-+
>ryc> | table| type  | possible_keys | key | key_len | ref  |
rows
>ryc> | Extra   |
>ryc>
+--+---+---+-+-+--+-
>ryc> +-+
>ryc> | messages | index | parentmsgid   | parentmsgid |   5 | NULL |
7207120
>ryc> | where used; Using index |
>ryc>
+--+---+---+-+-+--+-
>ryc> +-+
>
>How many rows satisfies the query?  Is it about 7207120 rows ?
>
>Heikki, could it be that InnoDB will read the original row through the
>primary key even if MySQL has marked that it would be happy if InnoDB
>only returned the found keys from the secondary index ?
>
>Regards,
>Monty


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: host.ISM

[Gerald Clark]

Make sure mysql owns all the directories and files in its database 
directory.

If you have never seen host.ISM on your .22 server, then you never looked.

It sounds like you also ran mysql_install_db and overwrote your 
privilege tables. That is why they are now .MYD and .MYI.

You also probably ran it without the --user=mysql option, so root owns
the directories and files.

Skot wrote:

> Werner Stuerenburg wrote:
> 
>>> I just updated MySQL 2.22 to 2.23 and when I went to restart the server,
>>> I got this error message in the /var/lib/mysql/err.log file:
>>> 010627 11:19:22  /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno:
>>> -1)
>>> mysqld ended on  Wed Jun 27 11:19:22 PDT 2001
>> 
>> See http://www.mysql.com/doc/R/e/Repair.html
> 
> 
> I can't use any SQL commands, I can't even connect to mysql database
> without a running server, and the server won't start because it's
> looking for 'host.ISM' file, which I have never seen on my server.  I
> only have host.MYD and host.MYI files there, no .ISM anythings.
> 
> Thanks.
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re[4]: Duplicate entry

[Werner Stuerenburg]

> Doing a SELECT and then an INSERT without LOCK TABLE doesn't seem very
> robust to me.

I agree. (Blush)

> Why don't you simply try to INSERT and if it fails due
> to a duplicate sid generate another session ID?

Good idea. (Again: blush) Thanks.

-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Error during compilation.

[Gerald Clark]

You also need to link in libz, so make it "-lmysqlclient -lz"

mysql novice wrote:

> Hi all,
> 
> I don't know how many times this question has come up
> in discussion, but I am new to the group, so please
> forgive. More over, I am very new to SQL itself.
> 
> I have a small program, that connects to a database,
> and tries to retrieve a part of a table. The program
> is as follows:
> 
> /*
>  * program: connect.c
>  * connect to a test database, and try retrieving some
>  * data.
>  */
> 
> #include 
> #include 
> #include 
> 
> MYSQL mysql;
> MYSQL_RES *res;
> MYSQL_ROW row;
> 
> void exiterr(int exitcode)
> {
> fprintf( stderr, "%s\n", mysql_error(&mysql)
> );
> exit( exitcode );
> }
> 
> int main()
> {
> uint i=0;
> 
> if
> (!(mysql_connect(&mysql,"localhost","usr1","mysql"))) 
> exiterr(1);
> fprintf(stderr,"Connected to database!\n");
> 
> if (mysql_select_db(&mysql,"test"))
> exiterr(2);
> fprintf(stderr,"Connected to test
> database!\n");
> 
> if (mysql_query(&mysql,"SELECT telno,extn FROM
> epabx"))
> exiterr(3);
> 
> if (!(res = mysql_store_result(&mysql)))
> exiterr(4);
> 
> while((row = mysql_fetch_row(res))) 
> {
> for (i=0 ; i < mysql_num_fields(res);
> i++) 
> printf("%s\n",row[i]);
> }
> 
> mysql_free_result(res);
> mysql_close(&mysql);
> 
> }
> 
> I compiled the program using a command that I found in
> one of the documents:
> 
> $  gcc -I/usr/local/mysql/include
> -L/usr/local/mysql/lib connect.c -lmysqlclient -o
> connect
> 
> The following error comes:
> /usr/local/mysql/lib/libmysqlclient.a(my_compress.o):
> In function `my_uncompress':
> my_compress.o(.text+0x9a): undefined reference to
> `uncompress'
> /usr/local/mysql/lib/libmysqlclient.a(my_compress.o):
> In function `my_compress_alloc':
> my_compress.o(.text+0x12a): undefined reference to
> `compress'
> collect2: ld returned 1 exit status
> 
> Am I missing anything? Need I download anything? If
> so, where can I get this?
> Please help me.
> Thanks in advance!
> 
> regds,
> Praveen.
> 
> 
> =
> 
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php