Numbering within groups

Hi I have the following problem: I have a database with two fields projectid and partner. Here some data: Projectid / Partner 1 / A1 2 / A2 2 / B2 3 / A3 3 / B3 3 / C3 4 / A1 4 / B4 ... I want to number the partners for every project, e.g. Projectid / Partner / Partnernumber 1 / A1/1 2 / A2

Newbie question: Create table from query or export query

Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger _ ECOPLAN Forschung und Beratung in Wirtschaft und Politik