Assuming reorder is required, the following 3 results were found.
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...
important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong());...
allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable...