Categories
Tags → Sql Insert Into Table

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 fo...
DETAILS

Large Database Backup

This class can be used to backup large MySQL databases into multiple files. It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creati...
DETAILS

SamMySql Database Class

This class wraps common MySQL database table SQL queries. It can: - Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array. - Insert or update rows from a list of fields and v...
DETAILS

vpSQL

vpSQL is a small set of functions (under 13k) that interacts with a flat file database through a subset of sql instructions. vpSQL accepts the the following sql statements: SELECT fields FROM table[WHERE][ORDER BY][lLIMIT] INSERT fields,dat...
DETAILS
©2003-2019 jCay.com