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]
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 :
create
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
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
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
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
Mayuresh Kshirsagar mailto:[EMAIL PROTECTED] 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:
Asha wrote:
Is there a physical
limitation in the InnoDb table structure as to why it can't
support FullText indexes?
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html
Peter Normann
--
MySQL General Mailing List
For
I downloaded the binary files and upziped them to /home/myname/mysql.(I use
red hat linux) when I use command mysqld --console to run the server. The
following message are showed on the screen:
[EMAIL PROTECTED] bin]$ ./mysqld --console
050525 17:36:11 Warning: Can't create test file
Hi Mathias,
Thanks for your suggestion, but i run this query to find multiple
records with the same name in field barang (double records). And the
results i found 94 rows at 54813 ms. I try your idea and the result is
the same. So i think mysql not optimized for this kind sub query.
Do you
An earlier versions of 4.1.12 rmps had some problems, I saw this in some
messages in list. But this could be caused by other reasons. SELinux for
example. Are you able to create grant tables running mysql_install_db
manually?
Laser, Mary [EMAIL PROTECTED] wrote:
Description:
rpm
Hi Peter,
Its the requirement for the project to use 4.0.13. I visites the page you
mentioned. but the only build available there which i can see is 4.0.24. Am
I missing something?
Regards,
Mayuresh
- Original Message -
From: Peter Normann [EMAIL PROTECTED]
To: 'Mayuresh Kshirsagar'
Mayuresh Kshirsagar mailto:[EMAIL PROTECTED] wrote:
Its the requirement for the project to use 4.0.13. I visites the page
you mentioned. but the only build available there which i can see is
4.0.24. Am I missing something?
Well, without having read the changelogs I can't imagine anything
Mayuresh Kshirsagar wrote:
Hi Peter,
Its the requirement for the project to use 4.0.13. I visites the page you
mentioned. but the only build available there which i can see is 4.0.24. Am
I missing something?
Regards,
Mayuresh
- Original Message -
From: Peter Normann [EMAIL PROTECTED]
In article [EMAIL PROTECTED],
Jessica Svensson [EMAIL PROTECTED] writes:
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
I have a pretty simple table with a list of payments, not much more
than:
paymentID | amount | paymentDate
1 | 123| 2005-01-10
2 | 77 | 2005-01-13
3 | 45 | 2005-02-16
4 | 13 | 2005-02-17
I can get totals per month using a query like:
SELECT
On Wed, 25 May 2005, Russell Horn wrote:
I have a pretty simple table with a list of payments, not much more
than:
paymentID | amount | paymentDate
1| 123| 2005-01-10
2| 77 | 2005-01-13
3| 45 | 2005-02-16
4| 13 | 2005-02-17
I can get totals per
You may be able to use the WITH ROLLUP option of GROUP BY to get
something of what you are looking for. Can't think of anything off the
top of my head to get exactly what you are looking for.
On May 25, 2005, at 8:02 AM, Russell Horn wrote:
I have a pretty simple table with a list of
Hello,
I posted last night but did not receive an answer. I am trying to create a
fulltext index, but my table was created as an InnoDB type.
There is quite a bit of data there (1000+ records) and I need to change to a
MyISAM table for the indexing for fulltext search.
How can I convert the
Scott Purcell wrote:
Hello,
I posted last night but did not receive an answer. I am trying to create a
fulltext index, but my table was created as an InnoDB type.
There is quite a bit of data there (1000+ records) and I need to change to a
MyISAM table for the indexing for fulltext search.
- Original Message -
From: Russell Horn [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, May 25, 2005 8:02 AM
Subject: Cumulative Totals
I have a pretty simple table with a list of payments, not much more
than:
paymentID | amount | paymentDate
1 | 123| 2005-01-10
hi,
At 14:54 25.05.2005, Scott Purcell wrote:
Hello,
I posted last night but did not receive an answer. I am trying to create a
fulltext index, but my table was created as an InnoDB type.
There is quite a bit of data there (1000+ records) and I need to change to
a MyISAM table for the
I can do this programatically, and will alter the table. But there are three
tables that have foreign key references to the table I will be altering.
They look like this.
CREATE TABLE ITEM_CAT_REL (
id INT,
cat_id INT NOT NULL,
key(id),
FOREIGN KEY (id) references ITEM(id) on
- Original Message -
From: Rafal Kedziorski [EMAIL PROTECTED]
To: Scott Purcell [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, May 25, 2005 6:06 AM
Subject: Re: InnoDB to MyISAM
http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html
He's converting InnoDB to
You should be able to pull the ID of the parent table in when you do the
INSERT ... SELECT to pull the data in, in which case, the IDs in the foreign
key fields would still be valid.
I'd convert them all to MyISAM rather than doing half and half.
- Original Message -
From: Scott
Hendro Suryawan [EMAIL PROTECTED] wrote on 05/25/2005 06:23:52 PM:
Hi Mathias,
Thanks for your suggestion, but i run this query to find multiple
records with the same name in field barang (double records). And the
results i found 94 rows at 54813 ms. I try your idea and the result is
the
http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html
He's converting InnoDB to MyISAM.
I would recommend something like this:
CREATE TABLE newtable LIKE oldtable;
ALTER TABLE newtable ENGINE=MyISAM;
ALTER TABLE newtable DISABLE KEYS;
INSERT INTO newtable SELECT * FROM
Hi
A client of ours has experienced some rather serious hardware failures
resulting in disk errors and therefore corrupted InnoDB files.
We could not get mysql to restart unless the innodb_force_recovery was set to
5. In this situation we encountered failure when attempting to read from
Scott Purcell [EMAIL PROTECTED] wrote on 05/25/2005 09:22:32 AM:
I can do this programatically, and will alter the table. But there
are three tables that have foreign key references to the table I
will be altering.
They look like this.
CREATE TABLE ITEM_CAT_REL (
id INT,
On May 25, 2005, at 9:34 AM, David Brewster wrote:
A client of ours has experienced some rather serious hardware
failures resulting in disk errors and therefore corrupted InnoDB
files.
We could not get mysql to restart unless the innodb_force_recovery
was set to 5. In this situation we
Hi
Here is the log dump :-
Thanks
David
050525 13:24:10 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306
050525 13:24:11 InnoDB: Assertion failure in thread 114696 in file
fsp0fsp.c line 3034
InnoDB: We
My mysql won't start with /etc/init.d/mysql start or service mysql start
No errors in the mysql log, but these errors in /var/log/messages:
May 25 11:12:21 wind kernel: audit(1117033941.355:0): avc: denied {
append } for pid=2546 exe=/usr/sbin/mysqld-max
On May 25, 2005, at 10:06 AM, David Brewster wrote:
Here is the log dump :-
Thanks
David
050525 13:24:10 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306
050525 13:24:11 InnoDB: Assertion failure in thread
Hi
Thanks for the help.
Even though an rpm -qV -a on the machine listed no likely candidates for
corruption, a complete uninstall and reinstall of mysql and mysql-max
packages seems to have have fixed whatever the problem was (running off
the backed up data).
David
-Original Message-
MySQL 4.0.14 Win98 platform.
what could cause the following error by typing
mysqld --console.
regards
050525 16:50:13 InnoDB: Database was not shut down
normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1
Dear there,
After install mysql 4.1.12 by using rpm, I have some problems to restart server
after shutting down it. When I use mysqld_safe try to restart, it give me
error as follws:
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file
Hello.
MySQL could be installed under unprivileged user in location
owned by that user. You should correctly specify the parameters
in the configuration file or in command line. I usually launch
mysqld using mysqld_safe with --defaults-file command line option.
Here's an example of such
Hello.
Disable or change policies of SELinux.
Anne Ramey [EMAIL PROTECTED] wrote:
My mysql won't start with /etc/init.d/mysql start or service mysql start
No errors in the mysql log, but these errors in /var/log/messages:
May 25 11:12:21 wind kernel: audit(1117033941.355:0): avc:
While updating a record in a database, I inadvertantly forgot a
where statement; so instead of changing just one record, I changed
all 900 records in the database.
I've been trying to figure out how to fix this. My latest backup
(through mysqldump) was about fifteen days ago. I'm fine with
That just complicates things alot since i get around 200 files, 6 times a
day via an automated process and every textfile looks different from the
other. To just have different load data would make it much easier.
I have read alot of questions about just this and many people is asking for
matt g [EMAIL PROTECTED] wrote on 05/25/2005 12:45:22 PM:
While updating a record in a database, I inadvertantly forgot a
where statement; so instead of changing just one record, I changed
all 900 records in the database.
I've been trying to figure out how to fix this. My latest backup
Hello All,
I am very new to the MySQL environment.
I have built latest stable MySQL 4.1.12 in Hp-Unix
11.23 IPF platform with OpenSSL support.
Following are my configuration options I have used to
build,
./configure --prefix=/opt/iexpress/mysql
Hi,
aren't you looking for somthing like that :
mysql select sum(amount),DATE_FORMAT( `paymentDate` , '%Y-%m' ) c FROM
`payments` GROUP BY c with rollup;
+-+-+
| sum(amount) | c |
+-+-+
| 200 | 2005-01 |
| 58 | 2005-02 |
|
On Wed, 25 May 2005 11:09:06 -0700 (PDT)
Kathir Velu [EMAIL PROTECTED] wrote:
openssl_1 and rpl_openssl are skipped eventhough i
have compiled with OpenSSL.
So I have rerun these tests alone as,
./mysql-test-run --with-openssl openssl_1 rpl_openssl
Now openssl_1 test passed but
One more note for anyone else who runs into this problem: before
running the source command, I dropped the database, recreated it, and
then ran the mysqldump file into the empty database.
Matt
On 5/25/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
You can try doing the same steps, but
Hello,
I am running 4.0.15 for Win95/98 and am working through the docs.
I created a text type field with a 'fulltext' index. As I am experimenting, I
have run into a couple of questions:
First off, I was having trouble getting results. So I added the word foobar
to one of the descriptions:
Thank you *SO* much, Shawn. Doing it manually did the trick.
I'm sure you know how frustrating this can be. I really, really
appreciate your help. Whew!
best,
Matt
On 5/25/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
You can try doing the same steps, but break it down so that you do
Scott -
Check this excerpt out (
http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
Documentation. I hope it helps!
--bemansell
...
Every correct word in the collection and in the query is weighted according
to its significance in the collection or query. This way, a
The folowing is out of the current MySQL manual. It looks like you could
create an intermediate table with the fields you are interested in the front
and garbage fields on the end. Then build a specific LOAD DATA INFILE with
correct mapping for each file type [assuming you can tell this in your
Brian Mansell [EMAIL PROTECTED] wrote on 05/25/2005 03:09:03 PM:
Scott -
Check this excerpt out (
http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
Documentation. I hope it helps!
--bemansell
...
Every correct word in the collection and in the query is
Thanks Sean fo the info.
I see where it states the server is configured for 4 character indexing. I
would like to try and set it to 3 and do not understand what an options file is:
The documentation states the following:
*
The minimum and maximum length of words to be indexed is
Scott Purcell [EMAIL PROTECTED] wrote on 05/25/2005 03:35:54 PM:
Thanks Sean fo the info.
I see where it states the server is configured for 4 character
indexing. I would like to try and set it to 3 and do not understand
what an options file is:
The documentation states the following:
For purposes of comparison, is data of type Year treated the same as
integers? I think this is the case because a year is represented using
either 2 or 4 digits, but I am not absolutely certain. Any help would be
appreciated. Thank you.
- Asad
--
MySQL General Mailing List
For list archives:
Hi again,
if your looking for raising sub-totals, i found you thos form :
mysql select 'TOTAL',
- sum(if(DATE_FORMAT( `paymentDate` , '%Y-%m' )='2005-01',amount,0)) as
'2005-01',
- sum(if(DATE_FORMAT( `paymentDate` , '%Y-%m' )='2005-02',amount,0)) as
'2005-02'
- from payments
-
Have you seen this page of the manual?
http://dev.mysql.com/doc/mysql/en/year.html
Rhino
- Original Message -
From: Asad Habib [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, May 25, 2005 3:55 PM
Subject: Year Data Type
For purposes of comparison, is data of type Year
Hi,
Sometimes when querying mySQL 4.1.11 on Linux machine I get the error
Lost connection to MySQL server during query. Here are the symptoms
1. When running the query from the server it returns OK
2. When running the query from another machine using the mySQL
query browser it
Greetings
We're in a peculiar situation that needs resolution.
Situation:
System XYZ RH AS 2.1
RH mysql client -- mysqlclient9-3.23.22-8
RH php -- php-4.1.2-2.2 php-mysql-4.1.2-2.2
System ABC RH AS 3.0
RH mysql server -- 4.1.10-standard
The mysql client on XYZ can not talk to mysql
On May 25, 2005, at 5:12 PM, Farid Hamjavar wrote:
Situation:
System XYZ RH AS 2.1
RH mysql client -- mysqlclient9-3.23.22-8
RH php -- php-4.1.2-2.2 php-mysql-4.1.2-2.2
System ABC RH AS 3.0
RH mysql server -- 4.1.10-standard
The mysql client on XYZ can not talk to mysql server on
I have a problem where I need to use a subquery in combination with a Left
Join. The SQL statement below works fine until I introduce the subquery
portion. Specifically,
WHERE testplans.plantriggers_ID_FK IN (SELECT plantriggers.ID FROM
plantriggers WHERE
Apologize for not including the error:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'SELECT
plantriggers.ID FROM plantriggers WHERE (((plantrigger
I'm running MySQL 4.0.2-standard
-Original
In the last episode (May 25), Bartis, Robert M (Bob) said:
Apologize for not including the error:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'SELECT
plantriggers.ID FROM plantriggers WHERE
That might explain it:-) The really said part is I remember running into the
same issue some months back and completely forgot.
Thanks
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 6:54 PM
To: Bartis, Robert M (Bob)
Cc: 'mysql'
Subject: Re:
Hi,
On May 25, 2005, at 1:28 PM, Jessica Svensson wrote:
That just complicates things alot since i get around 200 files, 6
times a day via an automated process and every textfile looks
different from the other. To just have different load data would make
it much easier.
I have read alot of
Wow!! Thanks!
I will upgrade right away... but i can't find any information in the url you
supplied about how to specify what fields from the external file to read...
will be quite hard to figure out on my own i guess?
Thanks again!
From: Harrison Fisk [EMAIL PROTECTED]
To: Jessica Svensson
Hi,
On May 25, 2005, at 7:38 PM, Jessica Svensson wrote:
Wow!! Thanks!
I will upgrade right away... but i can't find any information in the
url you supplied about how to specify what fields from the external
file to read...
It will read all of them, but you can just specify a variable for
[EMAIL PROTECTED] wrote:
My suggestion: Don't use a subquery, use a temp table (
http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html)
CREATE TEMPORARY TABLE tmpDupes (KEY (`Barang`))
SELECT `Barang`
FROM Barang
GROUP BY Barang
HAVING count(1) 1;
Select b.`BrgId`, b.`Kode`, b.`Barang`
I cant tell you how much i love you right now :)
This works flawless!! Thanks a million times!
From: Harrison Fisk [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: LOAD DATA and skip columns in text file...
Date: Wed, 25 May 2005 20:05:40 -0400
Am I correct in assuming that MySQL requires string literals in stored
procedures for the following clauses:
REGEXP, LIMIT and LOAD DATA INFILE?
For example, I cannot seem to pass in the {pattern} as a parameter to
my SPROC, and then query for ...WHERE field REGEXP pattern
I'm having the same
At 19:18 -0700 5/25/05, Scott Klarenbach wrote:
Am I correct in assuming that MySQL requires string literals in stored
procedures for the following clauses:
LIMIT requires integer constants, not strings.
The filename for LOAD DATA INFILE should be a literal string, as you surmise.
Don't know
Hi:
Let's say I want to store the following information.
Unique ID - INT(10) autoincrement
First Name - VARCHAR (25)
Last Name - VARCHAR (25)
Age - INT(3)
Date - DATETIME
Activity - VARCHAR(100)
Data - TEXT
I would be basing my queries on all columns _except_ the Data column. I.e. I
would be
What does MySQL do internally when you perform a LEFT JOIN?
Let's say you have two tables:
Table A has 1,000,000 rows
Table B has 5,000 rows
When you perform the following LEFT JOIN:
Select A.*, B.*
FROM A, B
WHERE
A.lastname = 'doe' AND A.id http://A.id = B.id http://B.id
What does MySQL do
Thanks a lot.
- Original Message -
From: Peter Normann [EMAIL PROTECTED]
To: 'Mayuresh Kshirsagar' [EMAIL PROTECTED]; 'MYSQL
Mailing list' mysql@lists.mysql.com
Sent: Wednesday, May 25, 2005 4:36 PM
Subject: RE: Installer for 4.0.13
Mayuresh Kshirsagar mailto:[EMAIL PROTECTED] wrote:
key relationships?
MyISAM can't FK's.
Yes it can, they're just not enforced.
LOL - that's just like saying that MyISAM supports transactions
if you only do transactions that are a single statement...
In other words: useles.
Somehow I use these useles foreign keys to create relational
73 matches
Mail list logo