MySQL Forums
Forum List  »  Newbie

generate some tables
Posted by: David Montaño
Date: March 07, 2005 05:07PM

hi i'm a newbie in this forum, and mysql also, the question is this...
how can i create some tables, from a table that contains many fields, i know i didn't explain myself, so here i go...

i have this table:

| id | alarm | description |
| 1 | 025 | screen doesn't work |
| 3 | 023 | printer doesn't work |
| 1 | 023 | printer doesn't work |
| 1 | 035 | power supply doesn't work |
| 4 | 025 | power supply doesn't work |

the table showed contains about 239,951 (hehe) and i want to know if it is possible, to generate the following result:

-------------------------
| id | alarm | description |
| 1 | 025 | screen doesn't work |
| 1 | 023 | printer doesn't work |
| 1 | 035 | power supply doesn't work |
--------------------------------------

-------------------------
| id | alarm | description |
| 3 | 023 | printer doesn't work |
--------------------------------

-------------------------
| id | alarm | description |
| 4 | 025 | power supply doesn't work |
--------------------------------------

if i need to use some php lines, please let me know, i hope i've explained myself

well i think it's all...
...for now

tnx

Options: ReplyQuote


Subject
Written By
Posted
generate some tables
March 07, 2005 05:07PM
March 25, 2005 07:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.