question in mysql

I want the whole set of fields from another table for mysql

 

What? You mean

SELECT * FROM [table] WHERE 1;

Code (markup):

 

You don't need the WHERE 1 either

 

yes but, Beside this code number to extract a table from another table

 

Want the whole table and the transfer of value on another table

 

I'm not sure what you mean. But if you mean you want to move all data from on table into another you could query all of the info put it into an array and insert it into the new table.

 

If thats the case there are much easier ways of doing so
http://www.tech-recipes.com/rx/1487/copy-an-existing-mysql-table-to-a-new-table/