I'm looking for a way to create a temporary table containing a sub part of the master table... I know that I can use : CREATE TEMPORARY TABLE tbl_name [(create_definition,...)] [select_statement] but i'm working on a script that must create tables with the same "create_definition" that the master table (and the script must be independent from the "create_definition", I cannot Hardcode it in the CREATE TABLE statement)... For now, the only way i finded to do this is to copy the files associated to the master table to another tablename and, after that, i'm deleting all the rows that I don't need from the newly created table : It is not very efficient :-) I'll be glad if someone could tell me a "SQL" way to solve this tricky problem... /<><><><><><><><><><><> Jonathan Pelletier <><><><><><><><><><><><>\ \ / / Matrox Electronic Systems Ltd. \ \ MIS / Département des systèmes -- Groupe Unix / / \ \ 1055 Blv. St-Regis Tel: (514) 822-6000 x.7589 / / Dorval (Quebec) Fax: (514) 822-6262 \ \ H9P 2T4 Email: [EMAIL PROTECTED] / / http://www.matrox.com \ \ / / Home: [EMAIL PROTECTED] \ \<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>/ _ ASCII ribbon campaign ( ) - against HTML email X & vcards / \ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php