Want to hire a development team?
No Images Added Yet

Simple csv to MySQL tool

Not Rated Yet.
Add to Favorites
Publisher
CREATE, INSERT and UPDATE a database using a CSV file
Product Details

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.

Report this Listing
Price
Free
Licence Type
Free
Views
2,588
Submitted on
15th May 2008
Last Updated
13th February 2009
Licence Type
Freeware
License Price
USD 0
Advertisement The banner below is an advertisement
Quikwit - AI Chatbot Platform

You May Also Like

Cloud Services You May Like

Help/Fix on AWS Kubernetes Service(EKS) (1 Hour)

One hour of help or fixes for Kubernetes clusters running on AWS EKS.

Help/Fix on configuring AWS SES for very low cost SMTP Email Sending (1 Hour)

One hour of help to configure AWS SES for low cost, reliable SMTP email sending.

AWS S3 Glacier Low Cost Deep Archive configurations

Configure S3 Glacier Deep Archive for ultra low-cost long term data storage.

Cost optimization by replacing IPv4 with IPv6 and configuring DNS for it

Plan and configure IPv6 addressing and DNS so you can reduce IPv4 usage and related costs.

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(0 ratings)
Not Rated Yet.
No reviews found.
Not yet reviewed by any member. You can be the first one to write a review for this listing.Click hereto submit your review.