moving data in sql

So after searching around the web looking for code to get data from one table intop another I found this example posted on the mysl dev forum mysql> INSERT INTO orders (customer_cust_id, orderdatetime, message, taxrate, shippingprice) -> SELECT ’1′, NOW(), null, taxrate, shippingprice FROM customer -> WHERE cust_id=’1′; Query OK, 1 row affected (0.01 sec)
Continue reading: moving data in sql