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..
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.
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
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.
D:\mysqldump -u root -pdbadmin murali murali.sql
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.
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
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
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
the field movid is type integer or varchar ?
2010/2/6 tech list bluetm...@gmail.com
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
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
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 bluetm...@gmail.com wrote:
select * from table_name where movid = max(movid);
why the sql
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
*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
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 roland.ka...@education.lu
To: armando armand...@gmail.com
Cc: tech list
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
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)
On Sat, Feb 6, 2010 at 12:11 PM, D. Dante Lorenso da...@lorenso.com 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
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 a
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
19 matches
Mail list logo