Is it possible to group by an interval?

INTERVAL HOUR +--+ | COUNT(*) | +--+ | 1 | | 3 | +--+ It it's possible, how do i write it? or if it's not possible, what can I do instead? Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL

SV: Is it possible to group by an interval?

| +---+ +--+ | COUNT(*) | +--+ | 2 | - same hour as below but year 2000 | 1 | - same hour as above but year 2001 | 4 | +--+ Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED] Office: +46

SV: inheritance of privileges?

-Ursprungligt meddelande- Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Skickat: den 19 juli 2001 15:36 Till: [EMAIL PROTECTED] Kopia: [EMAIL PROTECTED] Amne: Re: inheritance of privileges? Johan Nilsson writes: Privileges question: I have a user in mysql.user and he

SV: Put together (Merge) two tables in one

See section: 7.21.1 INSERT ... SELECT Syntax Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED] Office: +46 457 44184 Cellular: +46 709 798897 -Ursprungligt meddelande- Fran: Martin Cabrera Diaubalick

SV: Anyone knows what's wrong with this INSERT sentence?

INSERT INTO table1 (email) SELECT email FROM table1, table2 WHERE table1.email table2.email; the select is a new query, you have to join table1 and table2... Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED

inheritance of privileges?

with DROP privileges he can run a drop script? why, isn't the privileges from mysql.user inherited when running from the prompt (when running scripts)? Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED] Office: +46 457

SV: DELETING items

in MySql, but will be in 4.0... drop table temp; But this fails. I am not a SQL guru, and would appreciate any help Rob Regards, Johan Nilsson - Before posting, please check: http://www.mysql.com/manual.php (the manual

Delete in one table with information from another table

Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden E-Mail: [EMAIL PROTECTED] Web: http://www.beconmobile.com -Ursprungligt meddelande- Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Skickat: den 27 juni 2001 14:27 Till: [EMAIL PROTECTED] Kopia: [EMAIL

Delete in many tables

from the primary table, but that is one delete query/row? Is there any smart way to do this? Can I user temporary tables when deleting? INSERT...SELECT works but I havn't figured out how to use this temporary table in a DELETE query (I don't think it's possible)? Regards, Johan Nilsson Software