pecially 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 PROTECTED]> wrote:
You ne
/5.0/en/mysqlimport.html
Its similar but a lot easier to use.
However its a program so embedding it in code is not efficient..
hope this helps
harish
On 5/30/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
What's the error you are getting? What MySQL version are you using?
On 5/26
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 s
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
h socket '/tmp/mysql.sock' (111) 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
--
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.
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
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
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
S
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
S
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 unsubscrib
lmysql 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:[E
Dear Sirisha,
The command "show table status from " 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 2
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
ame.
Request you reply 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 whil
all to let me know what had gone wrong and how can I start the
mysqld daemon.
> Best Regards...
> Harish
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
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/
> -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
>
>
> 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
>
> Re
'(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)
0 rows..
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
0 rows..
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:
I have mysql installed on two linux boxes.
How can i access one system's mysql db from the other system
thanks
Harish
uggession to connect to mySQL
without using DBI. Can I 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
25 matches
Mail list logo
