Simple csv to MySQL tool
This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There's a download button for pulling in the csv file. A CREATE button will create a simple database using VARCHAR() with all the fields length set to the longest length of any field. The INSERT button will insert the data. The BUILD FIELD LIST button does just that so you can select the field if you're doing an UPDATE operation. Index fields in the database are shown. There are few checks to ensure that an operation will succeed. INSERT into a table that doesn't exist for example will error etc. The code is heavily commented and should be ewasy to follow/amend.
Video Theme: Setup a website like YouTube today (New 2022) - Download Now!Sponsored
Business Directory Theme (New 2022) - Download Now!Sponsored
1 Hour AWS issues/problems review and fix
One hour dedicated session to review and fix a specific AWS issue or problem.
Automating AWS Server Backups and configuring AWS Backup Cycles and AWS Backup rules
Set up automated backups for AWS servers using AWS Backup and clear backup cycles.
Microsoft Azure App Service Deployment & Web Application Configuration
Deploy and configure Azure App Service for hosting web applications with secure access, performance tuning, and environm
Analysing your AWS bill and suggesting ways to reduce costs
Deep analysis of your AWS bill with a detailed list of cost saving recommendations.


