Updating multiple fields mysql
If you think there should be, feel free to put together a proposal for how we would do that (either as a pull request or even just in writing if you're not sure how to start).
In the case where the application server and database server are on different hosts, the round-trip will involve network latency as well.But it's hard to tell from what has been explicitly given in your question.CREATE ALGORITHM=MERGE VIEW products_with_packaging_info AS SELECT p.*, pt.width as packaging_width, pt.height as packaging_height, pt.weight as packaging_weight, pt.case_count AS packaging_case_count FROM PRODUCTS p JOIN PACK_TYPES pt ON = p.packaging_type; queries against this view work exactly the same as queries against either table individually, as long as every product has a pack type.Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I have the need for updating multiple fields in a record.