RE: Installer for 4.0.13

Mayuresh Kshirsagar wrote: > Where can I find the installer for MYSQL DB 4.0.13 for solaris/linux. > I couldn't find it on the site. Could you guide me please. Is there any reason why you don't want the latest build of version 4.0? If not, you can find them here: http:

Re: Need some clarification on MySql with BorlandC++ in windows...

I believe the products you are talking about, Borland C++ v3 and Turbo C++ v3, are for DOS. DOS programs typically only support 8 character file names with 3 character extensions. You should consider upgrading your compiler. If you only need a C++ compiler, and not a complete development envir

Re: Sub Query to long...

hi, don't listen to last email. since the two first rows are unique, you can't use my example. Just create an index as i said, and play your query : Select BrgId, Kode, Barang From Barang Where Barang in (Select Barang From Barang Group By Barang Having Count(*) > 1 ) Mathias Selon [EMAIL PRO

Need some clarification on MySql with BorlandC++ in windows...

Dear Friends, I'm having one problem. that is using MySQL C API Libraries with BorlandC++ compiler ver 3.1and as well as in TC ver 3.0. The problem i'd found is can't include the header files which r having the more than 8 char name length. I can't come up with the solution. pls anybody has a

updateString from OOo

Hallo, I have a MySQL DB 4.1 (or 5.04) and have connect it with JDBC 3.1.7 to OOo1.9.104 (or OOo1.1.4) on WinXP When I make and updatable ResultSet I can write Data to the DB with updateBoolean and updateDouble but when I try to write Data to an Varchar with updateString it dosn't work. Here m

Re: Sub Query to long...

I rerezad you and discovered that (BrgId, Kode) is UNIQUE. your query will return no rows :o) spending 54813 ms for nothing. Mathias Selon [EMAIL PROTECTED]: > Hi, > You may have the same table structure in MS, but not the same table definiton > : > constraints+indexes+stats ! > > try : > creat

Installer for 4.0.13

Where can I find the installer for MYSQL DB 4.0.13 for solaris/linux. I couldn't find it on the site. Could you guide me please. Thanks, Mayuresh. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sub Query to long...

Hi, You may have the same table structure in MS, but not the same table definiton : constraints+indexes+stats ! try : create index toto on Barang(BrgId, Kode, Barang); Select BrgId, Kode, Barang From Barang Group By Barang Having Count(*) > 1 ; Mathias Selon Hendro Suryawan <[EMAIL PROTECTED

Sub Query to long...

Hi, I have 8414 records in table name Barang, I run query like this : Select BrgId, Kode, Barang From Barang Where Barang in (Select Barang From Barang Group By Barang Having Count(*) > 1 ) and the answer took 54813 ms. I think is too long. I ran the same query against same table in MS SQL Ser

Re: Tiger - MySQL --- any news ???

On Mon, May 23, 2005 at 04:03:52PM -0500, Kevin Victor wrote: > I would like to know if there is any existing solution for running > MySQL on Tiger. I dont see a binary version for 10.4 yet, will it be > released any time soon?? The existing binaries for 10.3 should run fine on Tiger. Personally,

Re: Tiger - MySQL --- any news ???

i am running 4.1.9 binary on tiger without any trouble Your MySQL connection id is 1 to server version: 4.1.9-standard - hcir On May 23, 2005, at 1:03 PM, Kevin Victor wrote: I would like to know if there is any existing solution for running MySQL on Tiger. I dont see a binary version for 10.4

Re: Resetting Auto-increment

On Tue, 24 May 2005 [EMAIL PROTECTED] wrote: >Is there a better way to reset the auto_increment in a table, basically >there are several million rows in the database and the field that is >auto_increment is very large now and I don't want to exceed the limit of >the field description so I want to

Re: Query to select...

On Tue, 24 May 2005 [EMAIL PROTECTED] wrote: >Selon Dan Bolser <[EMAIL PROTECTED]>: > >> >> Hello, >> >> I have data like this >> >> PK GRP_COL >> 1A >> 2A >> 3A >> 4B >> 5B >> 6B >> 7C >> 8C >> 9C >> >> >> And I want to write a query to select data like this.

Resetting Auto-increment

Is there a better way to reset the auto_increment in a table, basically there are several million rows in the database and the field that is auto_increment is very large now and I don't want to exceed the limit of the field description so I want to renumber all the rows starting at 1 again. Wha

LOAD DATA and skip columns in text file...

LOAD DATA and skip columns in text file... What i have found out is that this is not possible in any existing version of mysql, correct? I found a message from Sinisa Milivojevic @ MySQL AB dated 06/29/2000 while searching on google. It said "We have entered this on our TODO list one month ag

Re: GCC 4.0, mysql and Opteron?

Kevin Burton wrote: > I'm curious what people here think of compiling mysql with gcc 4.0... > Especially on Opteron. > > I've heard that the way to go with Opteron is to use gcc-3.4 but that > its a little unstable. > > Of course it might be too early to find out if gcc 4.0 is better than > 3.4...

help needed to create index

creating an index is necessary for fulltext search. and when i say create fulltext index search_index on sometable(column1,column2) i get an error messg like Error: The used table type doesn't support FULLTEXT indexes Why doesn't InnoDb support FullText indexes? Is there a physical li

Re: classic outer join problem

Hi Hank, I think your problem is to find all the files under /uploads by a command like : cd /uploads ls -lR | grep ".doc" >files.txt then load the files.txt into a temporary table TEMPtable that you create for this issue (see http://dev.mysql.com/doc/mysql/en/load-data.html), after truncating it

Tiger - MySQL --- any news ???

I would like to know if there is any existing solution for running MySQL on Tiger. I dont see a binary version for 10.4 yet, will it be released any time soon?? thanks Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Re: complicated query | no Sub query

My profound apologies here is the table create structure. the biggest problem i think is that this table does not have any primary keys or atleast unique columns: (I think joins require unique columns) mysql> show create table isr2_aud_log\G *** 1. row ***

Create fulltext index

Hello, I created table a while back like so: CREATE TABLE CATEGORY ( cat_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, parent_id INT, visible varchar(1) NOT NULL DEFAULT 'Y', sort INT, name varchar(200) ) TYPE=InnoDB; I believe I created it as type InnoDB for a fo

Re: classic outer join problem

Hank <[EMAIL PROTECTED]> wrote on 05/24/2005 05:02:47 PM: > I have a table of school class assignments with the following fields - > the first four fields are the primary key: > > Year (int) > Term (enum, "Spring", "Fall","Winter") > ClassID (int) > SectionID (int) > Attachement (varchar 225) >

classic outer join problem

I have a table of school class assignments with the following fields - the first four fields are the primary key: Year (int) Term (enum, "Spring", "Fall","Winter") ClassID (int) SectionID (int) Attachement (varchar 225) The "attachment" field is a pointer to a file in the OS of an uploaded file,

Re: data length vs index length ??

Michael Gale <[EMAIL PROTECTED]> wrote on 05/24/2005 04:10:35 PM: > Hello, > > Currently I have a large mysql table (36 million rows) and according to > the mysql-admin the data length is 6.5GB and my index length is 8.8GB. > > I am new to mysql, but I would assume that my index should not cons

Re: data length vs index length ??

In the last episode (May 24), Michael Gale said: > Currently I have a large mysql table (36 million rows) and according > to the mysql-admin the data length is 6.5GB and my index length is > 8.8GB. > > I am new to mysql, but I would assume that my index should not > consume more space then my data

Re: data length vs index length ??

Hi, if you have a lot of indexes on your table, it's normal that they consume more than data. That's the general case in a lot of databases. You've just to monitor index usage and drop the unused ones, before they impact the insert/update/delete performance. Mathias Selon Michael Gale <[EMAIL P

Re: complicated query | no Sub query

Anoop kumar V <[EMAIL PROTECTED]> wrote on 05/24/2005 03:02:11 PM: > Thanks Peter - you gave me some ideas... > here is what I have so far (simplified for simplification..) > > select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1, isr2_aud_log t2 > where t1.id_secr_rqst=t2.id_secr_rqst > a

data length vs index length ??

Hello, Currently I have a large mysql table (36 million rows) and according to the mysql-admin the data length is 6.5GB and my index length is 8.8GB. I am new to mysql, but I would assume that my index should not consume more space then my data ? But in order to provide the data in a timely man

rpm install on RHEL4 x86-64 does not create MySQL grant tables

>Description: rpm install of MySQL-server-standard-4.1.12-0.rhel4.x86_64.rpm on RHEL4 does not create the MySQL grant tables. >How-To-Repeat: install with rpm -ivh MySQL-server-standard-4.1.12-0.rhel4.x86_64.rpm on x86-64 RHEL4 system. Post installation attempts to start mysqld but fails due to mi

Re: Connection problem

razat gupta wrote: But it gives an exception on the reach of 150 connections.It should allow us to create almost 500 connection. Use netstat on the server to find out how many connections are actually in use. You may find that your program is not properly closing down connnections, for inst

Re: unicode and C API

Patrice Serrand wrote: mysql_query (mysql, "INSERT INTO db_unicode.unicode_tbl VALUES (6, _utf8 'atüpedâ' COLLATE utf8_general_ci)"); I'm no Unicode expert, but I've never seen that _utf8 bit before. What is it? Or more accurately, what do you expect it to do? I ask because that stri

Re: DB design question

Shawn, I agree with you that the tables can have different info with regard to the requirements. But for storing only addresses for specific students, this 4 table design seems weirdish to me... I think it makes more sense to keep a student_id in the Addresses table... With regards, Martijn Ton

Re: DB design question

"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 05/24/2005 02:32:05 PM: > > > > > Something like this would make more sense to me and provide greater > flexibility; > > It doesn't to me... > > > student > > > > student_id > > name > > age > > > > address > > --- > >

4.0.23 - error 127 from table handler during many parallel inserts

We have been very successfully running MySQL in a production environment one way or another for the past 6 years. We have recently run into what I believe is a thread race condition while writing then reading from a MyISAM table. The server we are experiencing this problem on is a very s

Re: complicated query | no Sub query

Thanks Peter - you gave me some ideas... here is what I have so far (simplified for simplification..) select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1, isr2_aud_log t2 where t1.id_secr_rqst=t2.id_secr_rqst and t1.dt_aud_rec > t2.dt_aud_rec group by t1.id_secr_rqst but the problem is tha

RE: DB design question

You probably want to add type to both the address and phone tables. Then you can be selective in your reporting and still get 1 row per student in your result set. Just remember if your data has the possibility of not having the information for a student you want to use LEFT JOIN's vs INNER JOIN's

GCC 4.0, mysql and Opteron?

I'm curious what people here think of compiling mysql with gcc 4.0... Especially on Opteron. I've heard that the way to go with Opteron is to use gcc-3.4 but that its a little unstable. Of course it might be too early to find out if gcc 4.0 is better than 3.4... Kevin -- Use Rojo (RSS/Ato

Re: DB design question

> Something like this would make more sense to me and provide greater flexibility; It doesn't to me... > student > > student_id > name > age > > address > --- > address_id > street_name > city > state > zip What addresses are these? Random addresses where a studen

RE: DB design question

From: Mike Johnson [mailto:[EMAIL PROTECTED] > From: Koon Yue Lam [mailto:[EMAIL PROTECTED] > > > the problems is, when I want to query both student, address > > and phone num, the sql will be > > > > select * from student s, address a, phone_num n > > where s.student_id = a.sudent_id > > and

RE: DB design question

From: Koon Yue Lam [mailto:[EMAIL PROTECTED] > Hi, here is the case: > > one student may have more than one address, and one student > may have more than one phone number > > so the db would be: > > student > > student_id > name > age > > address > --- > address_

RE: DB design question

Koon Yue Lam, If you running your MySQL on Windows, you may try to use one of the reporting tools, like Crystal Report, to create your reports. Generally these tools allow to hide repetitive data in its reports Mikhail Berman -Original Message- From: Koon Yue Lam [mailto:[EMAIL PROTECTE

RE: DB design question

Something like this would make more sense to me and provide greater flexibility; student student_id name age address --- address_id street_name city state zip phone_num -- phone_num_id num extension type (cell, home, etc) primaryNumber (yes/no) stud

DB design question

Hi, here is the case: one student may have more than one address, and one student may have more than one phone number so the db would be: student student_id name age address --- address_id student_id street_name phone_num -- student_id num extensio

Re: Even if the `published` column is 0, it still shows the title...

Computer Programmer wrote: SELECT t2.`col1`, t3.`title`, t3.`col3`, t4.`published` FROM t1 LEFT JOIN t2 ON (t2.`catid`=t1.`id`) LEFT JOIN t3 ON (t3.`id`=t2.`sid`) CROSS JOIN `main_data` t4 ON (t4.`id`=t2.`sid`) WHERE t2.`catid`='7' AND t4.`published`=1 GROUP BY `sid` ORDER BY t3.`title`; What

Re: how can I get performance statistics

"qin lei" <[EMAIL PROTECTED]> wrote: I don't know how to implement this on the server side. Please, next time answer to the list as well. >Hi, >Thank you for your reply. >In my project, I need to know the prapagation time and execution time >respectively. So I can not measure the exec

Re: problem-Lost connection to MySQL server during query

Hello. Resolve a stack trace. See: http://dev.mysql.com/doc/mysql/en/using-stack-trace.html > Hi, > This is my first time to instll mysql. So I have not so much > experience. I am apprecia ted your help! > Now I check my mysqld.log file, there is something like: > > mysqld got si

Re: Query to select...

>I agree, especially with the additional information the OP provided about >his REAL table structure. A separate groups table makes better sense. > >Let this be an object lesson to others looking for assistance: If you want >timely and useful assistance, provide real and complete information

Re: Query to select...

Michael Stassen <[EMAIL PROTECTED]> wrote on 05/24/2005 10:26:14 AM: > [EMAIL PROTECTED] wrote: > > > Dan Bolser <[EMAIL PROTECTED]> wrote on 05/24/2005 06:08:32 AM: > > > >>Hello, > >> > >>I have data like this > >> > >>PK GRP_COL > >>1 A > >>2 A > >>3 A > >>4 B > >>5 B > >>6 B >

Re: Query to select...

Hi, I read "FK is a random (or otherwise)" But i prefer your help !! Selon Michael Stassen <[EMAIL PROTECTED]>: > > How on earth will that help? What does the ASCII (byte) code of GRP_COL > have to do with what Dan wants? > > [EMAIL PROTECTED] wrote: > > > Hi, > > try for axample, > > > > sele

Re: Query to select...

[EMAIL PROTECTED] wrote: Dan Bolser <[EMAIL PROTECTED]> wrote on 05/24/2005 06:08:32 AM: Hello, I have data like this PK GRP_COL 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C 9 C And I want to write a query to select data like this... PK FK GRP_COL 1 1 A 2 1 A 3 1 A 4

problem-Lost connection to MySQL server during query

Hi, I install Mysql 4.1.12-0 by rpm. When I try to create a table, it give me "Lost connection to MySQL server during query". My query is like: CREATE TABLE ArrayBatch ( id int(11) NOT NULL auto_increment, arrayType int(11) NOT NULL default '0', descr text NOT NULL, printStartDate date

Re: Problems with x86_64 mysql-standard-4.1.12 [SOLVED]

On Mon, May 23, 2005 at 11:52:50PM -0700, Kevin Burton wrote: > Pete Harlan wrote: > > >In addition to failing the tests, I deployed the server on Machine 1 > >for a while and it failed quickly, with a simple insert hanging up and > >"kill " being unable to kill it. (The thread's state was > >"Ki

Re: Query to select...

On Tue, 24 May 2005 [EMAIL PROTECTED] wrote: >Hi, >try for axample, > >select PK, ord(GRP_COL),COL from your_table; When I said my data was 'like' the below I should have been more specific. Here is some of my data (with reference to the simplified data (and question details) below); INPUT: <-

Re: 2 Joins in 1 Query

"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 05/24/2005 07:35:03 AM: > >From: [EMAIL PROTECTED] > >To: "shaun thornburgh" <[EMAIL PROTECTED]> > >CC: mysql@lists.mysql.com > >Subject: Re: 2 Joins in 1 Query > >Date: Mon, 23 May 2005 12:20:05 -0400 > > > >"shaun thornburgh" <[EMAIL PROTECTED]> w

Re: Query to select...

How on earth will that help? What does the ASCII (byte) code of GRP_COL have to do with what Dan wants? [EMAIL PROTECTED] wrote: Hi, try for axample, select PK, ord(GRP_COL),COL from your_table; Mathias Selon Dan Bolser <[EMAIL PROTECTED]>: Hello, I have data like this PK GRP_

Re: Query to select...

Dan Bolser <[EMAIL PROTECTED]> wrote on 05/24/2005 06:08:32 AM: > > Hello, > > I have data like this > > PK GRP_COL > 1 A > 2 A > 3 A > 4 B > 5 B > 6 B > 7 C > 8 C > 9 C > > > And I want to write a query to select data like this... > > PK FK GRP_COL > 1 1 A > 2

Re: Query to select...

Hi, try for axample, select PK, ord(GRP_COL),COL from your_table; Mathias Selon Dan Bolser <[EMAIL PROTECTED]>: > > Hello, > > I have data like this > > PKGRP_COL > 1 A > 2 A > 3 A > 4 B > 5 B > 6 B > 7 C > 8 C > 9 C > > > And I want to write a query to

Re: problem-Lost connection to MySQL server during query

Hello. Have you looked into error log? Server could die during the query execution. >Dear there, > >I met some problem when I try to use \. command to create several >tables from a file in >mysql. I got error as follows: >ERROR 2013 (HY000): Lost connection to MySQL server during qu

Re: MySQL give up on a query after a certain length of time

> Check if problem remains with official binaries. I will. My schedule won't allow it right now, but I will get to it soon. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problem with query

From: "Jon Miller" <[EMAIL PROTECTED]> To: Subject: Problem with query Date: Tue, 24 May 2005 19:40:32 +0800 Quite new to MySQl and queries in general and would like some help in the following query: select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate,

Re: 2 Joins in 1 Query

From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: 2 Joins in 1 Query Date: Mon, 23 May 2005 12:20:05 -0400 "shaun thornburgh" <[EMAIL PROTECTED]> wrote on 05/23/2005 10:18:29 AM: > Hi, > > The following query produces the number of bookings

Problem with query

Quite new to MySQl and queries in general and would like some help in the following query: select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate, prActive from tProject where prDate >=2005-05-09 It generates a listing that has years from 2001 to present. A

problem-Lost connection to MySQL server during query

Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY0

Re: MySQL give up on a query after a certain length of time

Hello. Check if problem remains with official binaries. Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: > > I use those from Debian: > http://packages.debian.org/testing/misc/mysql-server-4.1 > > Thanks, > Jacob > -- For technical support contracts, goto https://order.mysql.com/

Re: how can I get performance statistics

Hello. Usually the execution time is measured on the client side (you may implement it in your application). I don't know how to measure the number of I/O operations involved by a single query. There is only a global statistics reported by SHOW STATUS. There is a handy tool in MySQL - EXPLAI

Query to select...

Hello, I have data like this PK GRP_COL 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C 9 C And I want to write a query to select data like this... PK FK GRP_COL 1 1 A 2 1 A 3 1 A 4 4 B 5

unicode and C API

Hello, I have an InnoDB table running on MySQL 4.1.11 The MySQL server configuration use : default-character-set=utf8 I have a table unicode_tbl with 'default charset set utf8' and a field szWord varchar(50) character set utf8 collate utf8_general_ci. if I use the C API like this : mysql_

Re: SCRAMBLE(A,B) (was UDF:Request).

On Mon, 11 Apr 2005 [EMAIL PROTECTED] wrote: >Dan Bolser <[EMAIL PROTECTED]> wrote on 04/11/2005 11:50:31 AM: > >> On Mon, 11 Apr 2005, Dan Bolser wrote: >> >> > >> >Requirement: >> > >> >Given two columns of a table (Column1 and Column2) of length x, return >two >> >columns (Column1_Scram and

Connection problem

Hello Everyone, I am working on an architecture on which i am using common database mysql4 for two web servers(Tomcat 5.x). After moving to 150 number of connections using a java application, mysql gives an error (exception): Server Connection Failure during transaction.Attempt reconnect 3 times

how can I get performance statistics

I need know the execution time of a query. And how many times the I/O operation are involved for the query. How can I get this kind of infomation? Are there some ways to add these info into the logfile? Thank you. I am a rookie for Mysql and for this mial-list system. If I broke the rule of as

Re: db/mysql rookie request

Hi, You can use this template. The idea is the same. All your line commands for certain task can be embedded in a single script : http://webxadmin.free.fr/article/mysql-use-shell-script-to-dump-all-databases-t-54.php Mathias Selon "Jorgensen, Bill" <[EMAIL PROTECTED]>: > MySQL guys: > > > > I