data infile is messy especially if you installed MySql through
the source files. Better if you did through binaries but still not too good.
Unless you are going to use this load inside a program its probably better
to go ahead with mysqlimport
harish
On 5/31/06, sheeri kritzer [EMAIL
Hey guys...
Thanks a lot...
Guess I will stick with MySql then
harish
On 5/30/06, peter lovatt [EMAIL PROTECTED] wrote:
Hi
We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts
and updates on a P4 with 1GB of RAM. Performance is fine, and the table size
is 400MB
and
time for this is not really a factor. I also do not have any constraints on
disk space. Please let me know if I can just use MySql as it is or if I
need to make some changes
harish
) at checksetup.pl line
1460
Can't connect to the mysql database. Is the database installed and
up and running? Do you have the correct username and password selected in
localconfig?
Pleasae help me out to solve this problem
Regards
Harish Shetty
--
MySQL General Mailing List
For list archives: http
and A19=1. I am currently using Limit 1 in the select query.
Note: My data is not based on A0 data.
If the table runs into millions of rows, is it a good suggestion to use
Limit. Or Is there any alternative?
Thanks,
Harish
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi All,
This query worked for me.
SELECT a.address
FROM a
LEFT JOIN b ON a.id != b.iid AND b.message='y'
Thanks,
Harish
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 12:23 AM
To: Roger Baklund
Cc: mysql; Harish
Subject: Re
Hi All,
This query worked for me.
SELECT a.address
FROM a
LEFT JOIN b ON a.id != b.iid AND b.message='y'
Thanks,
Harish
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 12:23 AM
To: Roger Baklund
Cc: mysql; Harish
Subject: Re
Hi All,
Sorry, I got a autoreply from [EMAIL PROTECTED] I was not able
to understand the autoreply and thought that the mail bouced. Please ignore
my duplicate mail.
Thanks again,
Harish
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 6
million records (a table) and half a million (b table). And,
due to transactions the a table gets updated frequently resulting in
different number of records.
- Harish
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 6:48 PM
To: mysql
Cc
Hi,
I apprecaite anybody replying me with an equvalent query for this:
I am using mysql 4.0.21
select a.address from a where a.id not in (select b.iid from b where
b.message='y')
- Harish
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Dear Sirisha,
The command show table status from Database_Name will give you the
details pertaining to the type of the table(MyISAM/InnoDB) and also the
memory used.
Hope this helps you.
-Harish
-Original Message-
From: sirisha gnvg [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 25
mysql 570 May 17 2004 abc.MYD
-rw-rw1 mysqlmysql1024 Dec 25 10:42 abc.MYI
abc is the table name.
So, the command which can be used is myisamchk -dvv
/home/mysql-data/data/test/abc
- Harish
-Original Message-
From: sirisha gnvg [mailto:[EMAIL PROTECTED]
Sent
Hi Renee,
Check the version of your MySQL. The subqueries feature is available from
MySQL 4.1
Hope this helps you.
- Harish
-Original Message-
From: Renee Henderson [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 6:17 AM
To: mysql@lists.mysql.com
Subject: simple subquery
ASAP.
Best Regards...
-Harish
-Original Message-
From: Dan Rossi [SMTP:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 1:29 AM
To: Harish B M (RBIN/ECM2) *; [EMAIL PROTECTED]
Cc: Pemmaiah B D (RBIN/ECM2) *
Subject: RE: Error while starting mysqld
/var/lib/mysql/ i think
Harish B M (RBIN/ECM2) * would like to recall the message, Error while
starting mysqld .
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
...
Harish
-
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
-Original Message-
From: Harish Varandani-Software-Bangalore
Sent: Wednesday, July 03, 2002 12:26 PM
To: '[EMAIL PROTECTED]'
Subject: FW: Regarding cast functions
I would like to know regarding the cast and convert functions in
MySql4.0.1;.
Can
I would like to know regarding the cast and convert functions in
MySql4.0.1;.
Can nebody explain the usage(casting of strings to number/integer).
I was not able to use them properly
Regards
Harish Varandani
'(select max(aeDtimeTimeStamp) from
alarmescalation)'
Regards
Harish Varandani
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
..
what is the problem pls help me.
Kind regards
Harish Gundecha
Systems Administrator
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Versaware Technologies (India) Pvt. Ltd.
Phone : +91-20-6136028 Extn: 331
..
what is the problem pls help me.
Kind regards
Harish Gundecha
Systems Administrator
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Versaware Technologies (India) Pvt. Ltd.
Phone : +91-20-6136028 Extn: 331
http://www.mysql.com
Kind Regards
Harish Gundecha
Systems Administrator
Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Versaware Technologies (India) Pvt. Ltd.
Phone No. : +91-20-6136028 Extn: 331
-Original Message-
From: aditya shanker [mailto:[EMAIL PROTECTED]]
Sent: Monday
I have mysql installed on two linux boxes.
How can i access one system's mysql db from the other system
thanks
Harish
connect to mySQL database using win32::ODBC.
If yes, please give me code details on how to connect using this.
waiting for a positive response,
-harish
24 matches
Mail list logo