×
How to Use This Page
This page is designed to create an SQL file. Please upload a CSV file with column headers matching those in the SQL table. Ensure the header values are correct before uploading. The "Where" column will show the conditions for updating. Any column selected here will be disabled in the "Set" section, which is used to specify the updated values for these SQL columns.
Follow these steps to generate SQL update queries from a CSV file:
- Select a CSV file by clicking on the "CSV File" input field.
- Enter the table name where the updates will be applied.
- Select the columns to be used in the WHERE clause from the "Where Columns" dropdown. You can select multiple columns by holding the Ctrl (or Command on Mac) key while clicking.
- Select the columns to be updated in the SET clause from the "Set Columns" dropdown. You can select multiple columns by holding the Ctrl (or Command on Mac) key while clicking.
- Provide a name for the generated SQL file.
- Optionally, you can include the MODIFIED_DATE, REVISION_NO, MODEL_ID, MARKETING_MODEL_ID, and MODEL_CODE updates by checking the corresponding checkboxes.This option is not applicable to all users. It is designed specifically for users whose SQL tables contain these columns and who are using them for this purpose.
- Click on the "Generate SQL" button to create the SQL update queries.
- If you want to create an SQL insert script or create a new SQL table, use the buttons provided below the form.