What?
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 ...
... key here to enable inventory tracking
m_CreateBooksItem.put("item_type","inventory");
//
// other less 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());
m_CreateBooksItem.put("initial_stock",v_Quantity.toLong());
m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal());
m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...
... myColumn
-- Reorder a column
ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
MySQL and Oracle PL/SQL
ALTER TABLE myTable
MODIFY myColumn myDataType
Microsoft ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.