One question

Hello all!!!

 

 

 

I have a question I am working on a project that require do some access to a
MySql database one of those queries that is very simple something like this
:

 

SELECT * FROM pat WHERE pat = "BEEK"

 

Since I am a complete newbie on this subject how can I make with the data
turn it into a new table in mySql?

 

Oh ! I almost forgot in perl how can I empty a table?

 

 

Thank you