Re: Help me

2010-07-21 Thread Mark Goodge
On 21/07/2010 16:33, Karthik Pr wrote: I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); [snip] The query is mysql> select * fro

Help me

2010-07-21 Thread Karthik Pr
I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); The table is as follows, ++-+-+ | id | name|

RE: help me out for this scenario

2010-02-11 Thread Jerry Schwartz
>-Original Message- >From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] >Sent: Thursday, February 11, 2010 12:52 AM >To: mysql@lists.mysql.com >Subject: help me out for this scenario > >I have a table like as follws > > > >Emp_id, first_login , se

help me out for this scenario

2010-02-10 Thread MuraliKrishna
Whats the query if first loin and second login were from two different tables.

help me out for this scenario

2010-02-10 Thread MuraliKrishna
8 >From this I need a table like Month, First_total(count(emp_id)), second_total(count(emp_id)) In first and second login the employee id will be consider only one time.. Please help me for this. thanks in advance

Re: help me out for this problem...

2010-02-05 Thread RaMeSh
t; > Regards, > m > > -Original Message- > From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] > Sent: Friday, February 05, 2010 12:04 PM > To: mysql@lists.mysql.com > Subject: help me out for this problem... > > > > Here I have to update year column with

RE: help me out for this problem...

2010-02-05 Thread misiaQ
-> end -> where id between 1 and 6; Good luck! Regards, m -Original Message- From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] Sent: Friday, February 05, 2010 12:04 PM To: mysql@lists.mysql.com Subject: help me out for this problem... Here I have to update

help me out for this problem...

2010-02-05 Thread MuraliKrishna
Here I have to update year column with reference to the row id mysql> update table1 -> set year=case when id=1 then 2000 -> when id=2 then 2001 -> when id=3 then 2000 -> when id=4 then 2001 -> when id=5 then 2000 -> when id=6 then 2001 -> else 2003

Re: help me regarding how to use cursor and handler

2010-02-05 Thread Johan De Meersman
those.. > if any body familiar with those.. please help me.. > > thnaks in advance > by > Muralikrishna > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel

help me regarding how to use cursor and handler

2010-02-04 Thread muralikrishna g
hi.. i like to know really what is a cursor and a handler and those functionality and purpose... i have tried much over net... but i didnt find proper material and examples for those.. if any body familiar with those.. please help me.. thnaks in advance by Muralikrishna

RE: 50M records each year, help me choosing the stretegy

2009-11-02 Thread Daevid Vincent
Sudhir, please remove the || from your name in your email: "|| Sudhir Nimavat ||" We have about 1 BILLION rows of data here and we do a few tricks which may or may not be of interest to you. For starters, setup replication and write to a master and have at least 2 slaves. This makes backups MUCH

Re: Fw: 50M records each year, help me choosing the stretegy

2009-11-02 Thread Walter Heck - OlinData.com
ow write operation. > > Thanks > SN > > > > > > > > Personally I'm always ready to learn, although I do not always like being > taught > > > > > - Forwarded Message > From: "sudhir543-nima...@yahoo.com" > To: Jay Ess > Sent

Fw: 50M records each year, help me choosing the stretegy

2009-11-02 Thread || Sudhir Nimavat ||
learn, although I do not always like being taught - Forwarded Message From: "sudhir543-nima...@yahoo.com" To: Jay Ess Sent: Mon, 2 November, 2009 3:34:52 PM Subject: Re: 50M records each year, help me choosing the stretegy Its a very simple table that will store messages

Re: 50M records each year, help me choosing the stretegy

2009-11-02 Thread Jay Ess
sudhir543-nima...@yahoo.com wrote: I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. 50M records is not th

50M records each year, help me choosing the stretegy

2009-11-02 Thread sudhir543-nimavat
I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. Thanks SN Sudhir NimavatSenior software engineer

RE: Please help me.

2009-03-19 Thread Muthukumar Selvarasu
; mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: RE: Please help me. Velentin, http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Note the section for the droping of foreign keys used the contraint name, not the key name. Try this

RE: Please help me.

2009-03-18 Thread Gary Smith
column after that. From: Valentin Ionescu [colibry...@yahoo.com] Sent: Wednesday, March 18, 2009 11:27 AM To: mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: Please help me. Hi! My name is Valentin and I am writing to

Please help me.

2009-03-18 Thread Valentin Ionescu
ried to do like:   alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key  Journal_ex_ID or alter table documents_ex drop  key  Journal_ex_ID    I receive the same error 150 and I don't know what to do.   Please help me.  Best regards. -- MySQL

Re: Is there a GROUP function that can help me with this?

2008-08-22 Thread Peter Brawley
David, >My goal is to create a report, that lists the Top 100 most expensive BookNames, for every CategoryId in this table. I think you can map the example under "Within-group quotas (Top N per group)" at http://www.artfulsoftware.com/infotree/queries.php to your requirement. PB David Per

Is there a GROUP function that can help me with this?

2008-08-22 Thread David Perron
Hi MySQL Users- I have a query problem I have been working on for quite some time and I am really at a loss to find a native function(s) to handle my task. I have this table: CREATE TABLE BookCategoryMetrics ( BookName VARCHAR(255), CategoryId VARCHAR(128), RatingSum DOUBLE, Cost DOUBLE, PRIMARY

Re: can some please help me -- REPLICATION

2008-08-11 Thread Moon's Father
bmisq01.bmi.com', master_user > = 'repl', master_password = 'repl'; > ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found > (Errcode: 2) > mysql> > > > > -Original Message- > From: David Giragosian [mailto:[EMAIL PRO

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
t; -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your s

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On

Re: can some please help me -- REPLICATION

2008-08-10 Thread David Giragosian
On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your slave. If it hasn't run for over a > month then there's not a lot of point in trying to start it up. Even if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands t

Re: can some please help me -- REPLICATION

2008-08-10 Thread Jim Lyons
you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that ha

can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not

Re: Can some one help me write it shorter?

2008-04-07 Thread Baron Schwartz
INTERVAL -1 month))UNION ALL > SELECT(STR_TO_DATE(CONCAT(year(curdate()),'/',month(curdate()),'/1'), > '%Y/%m/%d')) > > > ** In one query (as row)*** > > Anyway it's look like I will have to live it that way > >

Re: Can some one help me write it shorter?

2008-04-06 Thread Moon's Father
You can use temporary table if you want short statement. On Mon, Apr 7, 2008 at 9:24 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi, > > On Thu, Apr 3, 2008 at 3:25 AM, nataliew > <[EMAIL PROTECTED]> wrote: > > > > I need querylike this that make a row of numbers (in one execute) > > > > SE

Re: Can some one help me write it shorter?

2008-04-06 Thread Baron Schwartz
Hi, On Thu, Apr 3, 2008 at 3:25 AM, nataliew <[EMAIL PROTECTED]> wrote: > > I need querylike this that make a row of numbers (in one execute) > > SELECT a from ( > SELECT -1 a UNION ALL > SELECT -2 UNION ALL > SELECT -3 UNION ALL > SELECT -4 UNION ALL > SELECT -5 UNION ALL > SELECT -6 UNIO

Can some one help me write it shorter?

2008-04-03 Thread nataliew
: http://www.nabble.com/Can-some-one-help-me-write-it-shorter--tp16467090p16467090.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help me format this statement

2008-03-11 Thread wim . delvaux
On Wednesday 12 March 2008 00:14:46 Brian Dunning wrote: > I am an idiot. table_a and table_b have exactly the same structure. > How do I say this in SQL: > > INSERT (all records from table_a) into table_b where table_a.customer > = '12' > > Just trying to eventually duplicate the whole table, one

Re: Help me format this statement

2008-03-11 Thread Brian Dunning
Thanks to everyone who replied. So simple I couldn't see it. :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help me format this statement

2008-03-11 Thread Brian Dunning
I am an idiot. table_a and table_b have exactly the same structure. How do I say this in SQL: INSERT (all records from table_a) into table_b where table_a.customer = '12' Just trying to eventually duplicate the whole table, one customer's set of records at a time. Thanks. -- MySQL Gener

an't connect to local MySQL -- Help me!

2007-04-26 Thread Brown, Charles
I am getting this message from mysql. We had our binlog directory full. What is the resolution? Error 2002 (HY000) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This message is intended only for the use of the Addressee and

Re: help me optimize this sql

2007-03-06 Thread Jay Pipes
SELECT * FROM table_one t1 INNER JOIN table_two t2 ON t1.column_one = t2.column_one LEFT JOIN table_three t3 ON t3.column_two = t1.column_three AND t3.column_four = t1.column_five WHERE column_six LIKE '%dsc%' AND column_seven LIKE '%aaa%'; There is no need for a derived table. Also, using LIKE '

help me optimize this sql

2007-03-06 Thread wangxu
sql: select * from table_one inner join table_two on table_two.column_one = table_one.column_one left join (SELECT * from table_three) table_four on table_four.column_two = table_one.column_three and table_fo

Re: help me optimize this "ALL"

2007-03-05 Thread wangxu
thank you - Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 06, 2007 4:29 AM Subject: Re: help me optimize this "ALL" > No, because you have no WHERE condition. >

Re: help me optimize this "ALL"

2007-03-05 Thread Jay Pipes
No, because you have no WHERE condition. wangxu wrote: > sql: > > SELECT * > FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = > table_one.column_two >INNER JOIN table_one table_one2 ON table_one2.column_one = > table_one.column_three

help me optimize this "ALL"

2007-03-05 Thread wangxu
sql: SELECT * FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = table_one.column_two INNER JOIN table_one table_one2 ON table_one2.column_one = table_one.column_three explain: *** 1. row **

RE: Help me to understand multiple locking the same tables (lock; lock; unlock)

2007-01-10 Thread Jerry Schwartz
From: Denis Solovyov [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 10, 2007 2:29 PM > To: mysql@lists.mysql.com > Subject: Help me to understand multiple locking the same > tables (lock; lock; unlock) > > Dear friends, > > Please help me to understand several LOCKi

Help me to understand multiple locking the same tables (lock; lock; unlock)

2007-01-10 Thread Denis Solovyov
Dear friends, Please help me to understand several LOCKing the same tables without unlocking them between "LOCKs". Imagine the following code: LOCK TABLES t1 READ, t2 READ; -- some hard select queries which need that other threads do not update tables LOCK TABLES t1 WRITE

Re: please help me.

2006-06-02 Thread Daniel da Veiga
On 6/2/06, yuan edit <[EMAIL PROTECTED]> wrote: my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? You notices most of those files are .asc and .md5 used to verify the integrity of the archive after

please help me.

2006-06-02 Thread yuan edit
my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

2006-02-15 Thread Ady Wicaksono
Hi Dan I have an application that doing huge insert over web (HTTP) handled by PHP, when i use MySQL 4. Multiple thread doing insert to table is not really a problem. But NOT in MySQL 5. You may test it self, imagine you have 1000 concurrent HTTP connection that hit your PHP script. Each PHP scri

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

2006-02-15 Thread Ady Wicaksono
hich also backs up > MyISAM > tables > http://www.innodb.com/order.php > > > - Original Message - > From: "Dan Trainor" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Wednesday, February 15, 2006 9:08 PM > Subject: Re: Clien

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

2006-02-15 Thread Heikki Tuuri
- From: "Dan Trainor" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, February 15, 2006 9:08 PM Subject: Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868 Ady Wicaksono wrote: Dear Mr. Heikki and Team, Cur

Re: Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

2006-02-15 Thread Dan Trainor
Ady Wicaksono wrote: Dear Mr. Heikki and Team, Currently we hit by this bug http://bugs.mysql.com/bug.php?id=15868 It got worse on MySQL5 rather than MySQL4, since i failed to downgrade MySQL. Please give me idea to minimize the impact My client is very dissapointed with this issue Thank you

Client is starting to sue, Help me on this bug http://bugs.mysql.com/bug.php?id=15868

2006-02-15 Thread Ady Wicaksono
Dear Mr. Heikki and Team, Currently we hit by this bug http://bugs.mysql.com/bug.php?id=15868 It got worse on MySQL5 rather than MySQL4, since i failed to downgrade MySQL. Please give me idea to minimize the impact My client is very dissapointed with this issue Thank you very much -- MySQL

Re: help me please

2005-10-18 Thread Gleb Paharenko
Hello. The start point for you in such kind of problems should be researching the output of the following statement: SHOW VARIABLES LIKE '%char%'; Please, run it from different environments (PHP, MySQL Query Browser), and send results to the list. Include the CREATE statement for you

help me please

2005-10-17 Thread Aleksejs Pavlans
Hellou! I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use php to viewed data with latvian symbols in IE, then latvian symbols(aui.) is converted to ? symbols. Please Help! Ar cienu,

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-23 Thread Michael Stassen
John thegimper wrote: This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search, G

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-22 Thread John thegimper
efaults to AND instead of OR. > > Almost every search engine i have tried, google etc. works like this. > > "black horse cat dog" only show results with all words present. > > > > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' &

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-22 Thread John thegimper
7; > > I really appreciate your help!! > > >From: Sergei Golubchik <[EMAIL PROTECTED]> > >To: Jessica Svensson <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Please help me: Boolean fulltext searches, AND instead of > OR > >Date: Wed,

Kindly help me in generating optimal report in Nessus through MYSQL

2005-07-30 Thread Arumugam K
hi I have a requirement in generating a report in Nessus, Can you kindly help me on this.I am using nessus in my office.I generated a report through nessusWX in windows HTML format.In the report a column named description having description,solution and warning indicated as *** for each

Re: Help me....i strucke down...

2005-07-28 Thread Gleb Paharenko
s mail i attached the mysql client pgm and as > well as the error msg which i'm getting. > > Pls, help me in this. > > Thanks and Regards, > Ashok. > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail h

Re: Help me for God!!

2005-06-29 Thread Gleb Paharenko
Hello. Very often similar error occurs when you didn't remove service from previous MySQL installation. See: http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html Carlos J Souza <[EMAIL PROTECTED]> wrote: > Dear Friends, > =A0 > Iam trying to install MySQL 4.1.x in Windo

Re: Help me for God!!

2005-06-29 Thread Ashok Kumar
Hi Carlos, My suggestion for this problem is, just uninstall the MySQL Server and manually delete all the corresponding files, restart the system once (not a must, but it's a advisable), then u install the MySQL, hope now it'll definitely work. This is happening because of mis-configuration b/w t

Re: Help me for God!!

2005-06-29 Thread JamesDR
Carlos J Souza wrote: The error as follows: when installation is try to finish, the install try a start de new service "MYSQL 4" and does not success I try the install and reinstall many times and nothing. Regards On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote: Carlos J Souza wrote:

Re: Help me for God!!

2005-06-29 Thread JamesDR
Carlos J Souza wrote: Dear Friends, Iam trying to install MySQL 4.1.x in Windows 2003 Server, and on error occurs when installation try a start de service. The service does not start and installation don't finish. I Try install and reinstall many times and all fail My WIndows is a 2003

Help me for God!!

2005-06-29 Thread Carlos J Souza
Dear Friends,   Iam trying to install MySQL 4.1.x in Windows 2003  Server, and on error occurs when installation try a  start de service. The service does not start and  installation don't finish.   I Try install and reinstall many times and all fail   My WIndows is a 2003 Server SP1    I Need a he

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread leegold
> > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' > > I really appreciate your help!! > > >From: Sergei Golubchik <[EMAIL PROTECTED]> > >To: Jessica Svensson <[EMAIL PROTECTED]> > >CC: mysql@list

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
t dog" only show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' I really appreciate your help!! From: Sergei Golubchik <[EMAIL PROTECTED]> To: Jessica Svensson <[EMAIL PROTECTED]> CC: mysql@lists.mys

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Sergei Golubchik
Hi! On Mar 23, Jessica Svensson wrote: > Is there any way i can get results with AND instead of OR? > Trying to search for "black cat" should only return records that contains > both black and cat. > > I'm using the following code to get my result: > > SELECT * FROM `searchtbl` WHERE MATCH (tex

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Brent Baisley
fault = 'AND' But it does not work, everything would be sooo much easier if this was possible. "black cat" is only an example and the real query comes from user input. So it can be anything like +cat -dog +"big nose" -horse white black -red so parsing the input is n

Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
ow that i could put a + infront of every word but thats not what i want since the query comes from a searchbox and i dont want to write som code to manipulate the indata so ite shows correctly i just want to change the default word separator from OR to AND. Maybe it´s ft_boolean_syntax that sho

Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
t;black cat" is only an example and the real query comes from user input. So it can be anything like +cat -dog +"big nose" -horse white black -red so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR. Now i´m running 4.1.10

Re: err-report help me

2005-02-03 Thread Gleb Paharenko
,the report err is > "D:\Program Files\mysql\bin>mysql > ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)= > " > > please help me > > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 > =C0=F1=A3=A1 > =09=09=0

err-report help me

2005-02-02 Thread 张海军
mysql,您好! when click mysql.exe on $home\bin ,the report err is "D:\Program Files\mysql\bin>mysql ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) " please help me 致 礼! zhanghjun [EMAIL

Re: Help me optimize this query

2004-12-16 Thread Goutham S Mohan
>Thanks for your inputs Eric. >I tried this but it couldn't give me any insight abt >how can optimize this >for space saving of temp tables. >Maybe I am not expert enough to interpret this output, >so here it is - >- Manish Seeing the explain log, it looks to me like you donot have any index def

Re: Re: Help me optimize this query

2004-12-13 Thread Goutham S Mohan
>Thanks for your inputs Eric. >I tried this but it couldn't give me any insight abt >how can optimize this >for space saving of temp tables. >Maybe I am not expert enough to interpret this output, >so here it is - >- Manish Seeing the explain log, it looks to me like you donot have any index def

Re: help me pls

2004-12-08 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wu_Yang_SKZ, JPcommon wrote: > java.sql.SQLException: Communication failure during handshake. Is there a > server running on localhost:3306? > at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275) > at org.gjt.mm.mysql.Connection.(Connection.

help me pls

2004-12-07 Thread Wu_Yang_SKZ, JPcommon
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275) at org.gjt.mm.mysql.Connection.(Connection.java:230) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) a

Re: Help me optimize this query

2004-12-07 Thread Manish
(0.00 sec) Any inputs??? TIA, - Manish - Original Message - Sent: Saturday, December 04, 2004 10:26 AM Subject: Re: Help me optimize this query > If you change the update to a select you can use explain to see it's > execution path just like you would with a normal sel

Re: Help me optimize this query

2004-12-03 Thread Eric Bergen
If you change the update to a select you can use explain to see it's execution path just like you would with a normal select. The rows returned are the rows that would be matched by the update query. Example: explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%'; Optimize the q

Help me optimize this query

2004-11-30 Thread Manish
I am trying to execute this query and it is failing with Table is full error (I know I can make temp tables big). update t1, t2 set t1.XXX=1 where t1.YYY=t2. and t2. like '%X%'; My t1 has 10,00,000+ records and t2 has about 70,000 recorsds. I would like to know how can I optimize this quer

Re: Fwd: Help me, please! Problems with relationship between tables!!!

2004-11-04 Thread SGreen
I prefer to explicitly declare my INNER JOINs (not to imply them by using commas to make a list of tables). That way I avoid accidentally creating any Cartesian products of any tables by leaving out a WHERE condition. Missing ON conditions are much easier to spot (IMHO). http://dev.mysql.com/do

Re: Fwd: Help me, please! Problems with relationship between tables!!!

2004-11-04 Thread Spenser
The attachment describing your tables didn't come through. However, here's roughly how your SELECT statement might look: SELECT Order.id_order, Employee.name_employee, ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order FROM Order, Employee, ItemsOrder, Unit WHERE Order.id_order=ItemsO

Fwd: Help me, please! Problems with relationship between tables!!!

2004-11-04 Thread Priscilla Labanca
Hi, I need to make relationishp between 4 tables in my system. I just don´t know how to make. Somebody could help me, please? The tables are: Order, Employee, ItensOrder and Unit. My objective: to program a report of Order that appears in the screen the fields ( id_order, name_employee

Re: please help me!

2004-10-01 Thread mos
At 11:15 AM 10/1/2004, you wrote: Content-Type: text/plain; charset="UTF-8" Content-Language: en Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on “INSTALL-BINA

please help me!

2004-10-01 Thread Abdul3140
Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on âINSTALL-BINARYâ in âmysql.docsâ 2. Got the message as âWindows cannot open this fiel: File: INSTALL-BINARYâ To open

Re: HELP ME WITH THIS

2004-09-04 Thread Karma Dorji
EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 03, 2004 6:48 PM Subject: Re: HELP ME WITH THIS > Hi, > The only way I can think of is to join the table to itself. It should look > something like this: > > select unix_timestamp(concat(s.date,'

Re: HELP ME WITH THIS

2004-09-03 Thread Dobromir Velev
rji [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 03, 2004 5:06 AM > > To: [EMAIL PROTECTED] > > Subject: HELP ME WITH THIS > > > > Hello can anyone help me with this, > > > > i have a table, like the one below, > > i

Re: HELP ME WITH THIS

2004-09-03 Thread Roger Baklund
* Karma Dorji > i have a table, like the one below, > i need to find the time difference between the Start and Stop from a > particular CallingStationId to particular CalledStationId. > > ++--++---+ > -- > +---+

RE: HELP ME WITH THIS

2004-09-03 Thread Peter J Milanese
nal Message- > From: Karma Dorji [mailto:[EMAIL PROTECTED] > Sent: Friday, September 03, 2004 5:06 AM > To: [EMAIL PROTECTED] > Subject: HELP ME WITH THIS > > Hello can anyone help me with this, > > i have a table, like the one below, > i need to find the time differe

HELP ME WITH THIS

2004-09-03 Thread Karma Dorji
Hello can anyone help me with this, i have a table, like the one below, i need to find the time difference between the Start and Stop from a particular CallingStationId to particular CalledStationId

Help me for my problem please

2004-08-23 Thread aidil
Hi All, Here's my table structure Table 1: STM (Store Master) STR_CODE Desc part_number Table 2 : MRC(Master Received) Ref_No Rec_date Table 3 : DRC (Detail Recived) Ref_no PO_No STR_CODE

Re: can you help me optimizing this query?

2004-07-12 Thread SGreen
uot; <[EMAIL PROTECTED]> | | cc: | | Fax to:

Re: can you help me optimizing this query?

2004-07-12 Thread SGreen
| | Fax to: | | Subject: can you help me

Re: can you help me optimizing this query?

2004-07-12 Thread Giulio
I've found a solution so I'm answering to myself, for who can be interested and for asking if I've done something that could affect on some way my DB performances. I've added an index to both the columns that I use for the ON clause of my left join query, and now it runs at the speed of thought

Re: can you help me optimizing this query?

2004-07-12 Thread David Scott
your genre list wont change that often? should be ok. -- Dave - Original Message - From: "Giulio" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, July 12, 2004 1:50 PM Subject: can you help me optimizing this query? > Hi all, >

can you help me optimizing this query?

2004-07-12 Thread Giulio
Hi all, I have an audio tracks info table, let's call it Tracks; every Track can have one or more ' Character' ( it is not a genre, it is something like 'Italian' or 'International' or '80's' or 'evergreen' ) so a track can be 'International' and 'Evergreen', or 'Italian' and '70's') I have th

RE: Replication is currupted ...Please help me...

2004-06-09 Thread Mechain Marc
May be a full off the filesystem where the relay logbin file is ? Marc. -Message d'origine- De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoye?: mercredi 9 juin 2004 09:46 A?: [EMAIL PROTECTED] Objet?: Replication is currupted ...Please help me... Hi all. My company has

Replication is currupted ...Please help me...

2004-06-09 Thread 이세호
Hi all. My company has three Mysql DB servers. one is master, the other are slaves. master's version is 3.23.54-log. two slaves's version is 4.0.17 and Os of all servers is linux 7.3 2 days ago, another slave's replication was currupted unexpactedly, but the other slave was ok. I don't

RE: Is there any good soul out there who can help me with mysql 4 .0.17 replication.

2004-06-02 Thread Victor Pendleton
-Original Message- From: Ravi T To: [EMAIL PROTECTED] Sent: 6/2/04 11:49 AM Subject: Is there any good soul out there who can help me with mysql 4.0.17 replication. Hi, I am new to mysql and having some trouble with replication. Simple stuff like, 1. How to restart the stopped

Is there any good soul out there who can help me with mysql 4.0.17 replication.

2004-06-02 Thread Ravi T
Hi, I am new to mysql and having some trouble with replication. Simple stuff like, 1. How to restart the stopped resplication, 2. How to check if the replication is working, 3. How to bring the slave into master status when master crashes, 4. How to restore master and re-enable replicatio

help me pls!

2004-05-21 Thread Pham Hoang Giang
Any functions like "filter" ADO function in PHP? Thanks!

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Scott Haneda
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote: > I wouldn't upgrade until you know where the bottleneck is (CPU, disk, > network, or RAM). Since you are using "professional" software, I > wouldn't try to change the queries. Have you made changes to your > my.cnf file? Since you

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote: > I wouldn't upgrade until you know where the bottleneck is (CPU, disk, > network, or RAM). Since you are using "professional" software, I > wouldn't try to change the queries. Have you made changes to your > my.cnf file? Since you h

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Brent Baisley
I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using "professional" software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have enough ram to hold all the data, ram is probably not your bottlene

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: > Something that small shouldn't really need optimizing. What is the size > of your data (mb?, gb?) and what does your query look like? If you are > doing a wild card search on a large text field without a full text > index, then tho

  1   2   3   4   >