On 4-Feb-06, at 5:36 PM, Michael Stassen wrote:
René Fournier wrote:
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to co
René Fournier wrote:
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to combine them using a subquery, a la...
SELECT
With a name like Rene Fournier, shouldn't the subject line be "Je don't
think so?" ;-)
Okay, the first thing we need to know to help you is what version of MySQL
you are using. If I am not mistaken, subqueries aren't supported until
Version 4.1; if you are using 4.0 or earlier, your subquery w
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to combine them using a subquery, a la...
SELECT history.* FROM history
Hi, I'm new to the list and not sure whether my question belongs here or
not. I'm looking for an open source program, that runs on JSP, to
generate reports on data in MySQL databases. I've found a few myself but
they run on PHP. Any thoughts or advice would be very appreciated.
-Chuck Craig
-
>I would like to write an application in C# to let someone to manage
>users of a MySQL database. It should be able to create, edit and
>delete users. Can someone point me out to how I can do that? I really
>want to *write* such an application; I don't want to use an existing
>client or somethin
Hi,
I would like to write an application in C# to let someone to manage
users of a MySQL database. It should be able to create, edit and
delete users. Can someone point me out to how I can do that? I really
want to *write* such an application; I don't want to use an existing
client or something.
As my posting before, i still not found a primary key replacement for
auto_increment field.
Since whein inserting on auto_increment value, application will lock
table (LOCK AUTO-INC).
Sometime, i found that many process is waiting for this lock for what? I
don't know since ever thread on my
> Otherwise, you could try to use the binlog. The filesystem sure would be
> easy though...
for mysql < 5.0
show table status
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Hi,
Use this :
ps awux | grep mysqld -i
On 2/4/06, Casey Rhodes <[EMAIL PROTECTED]> wrote:
>
> >Casey,
>
> >in a Terminal window, type
>
> >ps -ef | grep -i mysql
>
> >and see if there is a mysqld process actually running and not a zombie
> >(defunct).
>
> >See if you can connect on the localhost
>Casey,
>in a Terminal window, type
>ps -ef | grep -i mysql
>and see if there is a mysqld process actually running and not a zombie
>(defunct).
>See if you can connect on the localhost.
>See if the socket exists.
>I'd bet that one of those three will find your problem. Please let
>us know i
11 matches
Mail list logo
