The Cyber-D’s SQL Wizard application was developed to be a small tool that can convert any .CSV document to a SQL query. This is typically useful if you receive an Excel document with data that you need to insert into MySQL.
Download Cyber-D’s SQL Wizard Crack + Serial
1. Export the Excel document as a CSV file (where “;” is used as a separator).
2. Open that file using notepad and copy everything using CTRL+C
3. Run SQL Wizard and paste everything in the “CSV Data to insert” field.
4. Give the columns in the CSV a unique identifier in the “SQL string variables in order of CSV data variables” field. You can use any name you like, as long as it’s between the [square brackets] and seperated by a ;
5. Modify the “SQL Insert Query” field to match your table name and table column names. Use the names you gave to the SQL columns in the query template.
6. Click on “Parse” to generate the SQL Queries. Double check if the query looks good and make modifications as needed. If the query string is too long, then simply copy and paste the generated queries into notepad to see the entire query for inspection.
7. If you are satisfied with the query then simply paste the queries into SQL or save it as a .sql file and load it in MySQL.
This tool can also be used to create any other type of queries if you modify the SQL Insert Query string to your needs.
| File Size: 3.1 MB | Downloads: 6928 |
| Added: Jun 21st 2012 |
User rating: 4.5
918
4.5
|
|
Company: Dario Volaric
-
-
|
Supported Operating System: Win All |
User reviews
October 10, 2018, Rachele think:great job guys. Cyber-D’s SQL Wizard keygen works
August 11, 2018, Giacomo think:muito obrigado pela patch
January 23, 2018, jeferson think:grazie mille per il serial