Re: Query help - Joining adjacent rows?

2005-06-21 Thread comex
> How would you like to see that information GROUPed and what does that > grouping represent (physically). In essence, I am asking you to describe > what information you are determining by the grouping process, what does each > GROUP mean to you? Grouping just means that somebody visited twice in

Re: Query help - Joining adjacent rows?

2005-06-21 Thread comex
> Basically it boils down to the fact that with SQL you have to use some other > way of telling > each group apart other than position (or interposition, as you say in your > example). The fact > that you have entries in your table from user1, user1, user2, user1, user2, > user3, and user1 > doe

Query help - Joining adjacent rows?

2005-06-21 Thread comex
I have a table: create table example(time datetime, username varchar(255)); timeusername 2005-06-21 15:58:02 user1 2005-06-21 14:58:02 user1 2005-06-21 11:57:51 user2 2005-06-21 10:57:51 user1 2005-06-21 09:57:51 user1 The query: select COUNT(*), username, MAX(time) as max

Info

2001-10-21 Thread comex
Hi How I can use transaction with MySQL API ( C and C++) Best Regards Jordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque