condensing queries (1 reply)
(MySQL.com) I currently use an application I built to manage orders at work.
There is a table called "Orders" and a table called "parts_on_orders"
Table 1: orders
Table 2: parts_on_orders
Each order gets its own unique line item in the "orders" table,
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 15:38:27
