🛡️
ZenDevX
  • Overview of ZenDevX Design Studio
  • Installation & Setup
    • Prerequisite
  • Getting Started
    • Login Process
    • Homepage
    • Dashboard
    • Project Explorer
  • Project Info.
    • Project Info.
      • Create New Project
      • Edit existing Project
      • Open existing Project
      • Remove Project
      • Close Project
  • Session Variables
  • Generate Code
  • Page Information
    • Page Information
      • Edit Page Info
      • Create New Page
        • Page Design Interface
          • Building Page Layout
      • Remove Page
      • Generate Code
      • Preview Page
  • Web-service
    • Web-service / REST-API
      • Create New Web-Service
      • Open existing Web-service
      • Remove Web-service
      • Generate Code (Web-service)
  • Database Management
    • Database Info.
    • Create Table
    • Modify Table Structure
    • Drop Table
  • Query Builder
    • Query Builder
      • Query Types
        • Insert Query
        • Update Query
        • Delete Query
        • Select Query
          • Join Multiple Tables in Query
          • Condition (Where Clause)
          • Sorting Data
    • Generate Web-service
  • Actions (the Power Within)
    • Action Wizard
      • Definition Group
        • Define Variable
        • Set NULL
        • Set Unique ID
        • Set Value
        • Perform Formula
        • Assign Value
        • Reset Form
        • Read/Write Session Variables
        • Library Functions
      • UI Group
        • Information Dialog
        • Set Focus to Control
        • Open Window/Page
        • Enable/Disable
        • Display/Hide
        • Show/Hide Modal
        • Change Tab
      • Actions Group
        • Data Exchange
        • Upload Image
        • Call UDF
        • Return value from UDF
        • Reload Select List
        • Manual Code
      • Condition & Loop
        • IF...THEN...ELSE
        • Break
        • FOR... Loop
        • Duplicate Check
        • Delete Check
        • User Confirmation
      • Database
        • Execute Query
        • Assign Query Result to
        • Return Value
        • Execute Stored Procedure
        • Generate Document #
        • Return Auto Increment Value
      • Data Table
        • Remove Current Row
        • Get Number of Rows
        • Loop in Table Rows
        • Reload Table Data
        • Fetch Row Value
  • Deploying Web Application
    • Deploying Web Application
Powered by GitBook
On this page

Was this helpful?

  1. Query Builder
  2. Query Builder
  3. Query Types

Update Query

PreviousInsert QueryNextDelete Query

Last updated 3 years ago

Was this helpful?

Use this query type when you need to update data in MySQL database. Here all that one needs to do is select a table in the Left panel and then select all the fields in data will be updated, set condition to update a specific record and click on Save button.

After saving the query you will be prompted, if you want to generate Web-service for this query. Say Yes to generate. If you say No here then it will have to generate necessary Web-service manually.