mysql_connect($host, $user, $pass) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $query = 'INSERT INTO tabell2 (a,b,c) SELECT a,b,c FROM tabell1 LIMIT 10'; $result = mysql_query($query) or die(mysql_error()); echo "Query completed!
\n";