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.
Taskrabbit Clone Script - Buy2TaskySponsored
Amazon Clone Script - Buy2AmazonSponsored
Micro Jobs Theme - Setup a website like Fiverr today *New 2022*Sponsored
Auction Theme: Start your own auction website today. (New 2022) - Download Now!Sponsored
Cloudflare Ongoing Management & Monitoring (Monthly)
Monthly Cloudflare management including policy changes, monitoring, tuning and issue response.
Management of Shared Storage Using AWS EFS
Setting up and managing a shared disk/folder using AWS EFS so multiple servers can access the same data at the same time
Help/Fix on AWS Kubernetes Service(EKS) (1 Hour)
One hour of help or fixes for Kubernetes clusters running on AWS EKS.
Monitoring Spot Instance Prices and Migrating Instances to Optimal Types/Regions
Automatically monitoring AWS Spot instance prices and moving servers to better instance types or regions for maximum sav
