MySQL Proxy

Hi friends, Recently I accept an idea of testing a MySQL Proxy to concept an environment that will use two slave servers below it.Ok, the theory is good and I decide to try this, but, when I began to test step-by-step the MySQL Proxy manual I felt that somenthing was wrong. In first time, I start

Query question

I have three tables that work together. "s_product" is a list of farm products with an autoincrementing ID. "s_product_market_prices" is a list of market pricings, obtained from various sources. Each one is dated and refers to exactly one s_product record via its ID. "s_product_harvest" is

Re: Trying to avoid bulk insert table locking

On Sat, Feb 6, 2010 at 12:11 PM, D. Dante Lorenso wrote: > I have a system that imports about 40 million records every 2 days into a > single table in MySQL.  I was having problems with LOAD DATA CONCURRENT > LOCAL INFILE where the table I was importing into would lock until the > import was compl

Re: max() can't work

Why in the world would you think "select * from table_name group by movid having max(movid)" would work? It seems to compile without errors but doesn't give you what you seem to want. This would work: select * from table_name group by movid having movid = (select max(movid) from table_name) alth

Trying to avoid bulk insert table locking

I have a system that imports about 40 million records every 2 days into a single table in MySQL. I was having problems with LOAD DATA CONCURRENT LOCAL INFILE where the table I was importing into would lock until the import was complete. Locks would prevent SELECTs also. I converted the table

Re: max() can't work

hi It is not working, select * from table_name group by movid having max(movid) but it is working fine select * from table_name order by movid desc limit 1 From: Roland Kaber To: armando Cc: tech list ; mysql@lists.mysql.com Sent: Sat, 6 February, 2010 8:

Re: MY SQL Slave Server

*MySQL Install multiple instances.* Create a folder called Conf with Instance.1.ini, Instance.2.ini, and Instance.3.ini. The Port each are listening on should all differ, as well as having a different data directory. I named these C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance1 mysq

Re: MY SQL Slave Server

I tried to install once again mysql at vista? but deducts the previous installation. and it is ask for the modify , repire and remove options You said that we can install any number of setups in a same system. Is there any other way to install? Please help me thank you _

Re: max() can't work

Yes - you must use the subselect. Or, you can set a variable like: select @max := max(movid) from table_name; select * from table_name where movid = @max; On Sat, Feb 6, 2010 at 8:34 AM, tech list wrote: > select * from table_name where movid = max(movid); > > why the sql above can't work? >

Re: max() can't work

The max() function is an aggregate function which can be used in conjunction with GROUP BY in the SELECT or HAVING clause: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html . This code should work: select * from table_name group by movid having max(movid). However, there is a simp

Re: max() can't work

the field "movid" is type integer or varchar ? 2010/2/6 tech list > select * from table_name where movid = max(movid); > > why the sql above can't work? > Shall I use a sub-select instead? > > select * from table_name where movid = (select max(movid) from table_name) > ? > > > Thanks in advance

max() can't work

select * from table_name where movid = max(movid); why the sql above can't work? Shall I use a sub-select instead? select * from table_name where movid = (select max(movid) from table_name) ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: dumping error

I hope you are executing the command from 'D:\', mysqldump has to be executed for the directory bin where you have installed the mysql. eg:D:\mysql\mysql5.0\bin\>mysqldump -u root -pdbadmin murali > "c:\murali.sql" This will help you. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at

Re: dumping error

2010.02.06. 12:00 keltezéssel, MuraliKrishna írta: D:\>mysqldump -u root -pdbadmin murali> murali.sql 'mysqldump' is not recognized as an internal or external command, operable program or batch file. could you stop blogging to the list, please? t -- MySQL General Mailing List For list arch

dumping error

D:\>mysqldump -u root -pdbadmin murali > murali.sql 'mysqldump' is not recognized as an internal or external command, operable program or batch file.

how to get distinct values in the following scenarion

Hi I have table like as following.. Cust_id Visited_date 1 2-1-2010 2 3-1-2010 3 4-1-2010 4 5-1-2010 6 6-1-2010 1 7-1-2010 2 8-1-2010 These visitor ids with visited date. but I want only all the customers with first visited date. Please

Re: hi.. is it possible

Yes you can, but port has to be different. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna < murali_kris...@arthaoptions.com> wrote: > Hi is it possible to have two instances of mysql over single windows xp. > because I want to workout with those as server and

hi.. is it possible

Hi is it possible to have two instances of mysql over single windows xp. because I want to workout with those as server and client. please help me regarding this.

order by-- rollup

Hi how to use "order by" with "with rollup", if it is not possible is there any alternative, in rollup how to name the null. is there chance to do so. please help me with this..