Tags → Sql Insert Update

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

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows
• Licenses
  • Freeware

Class: Easy MySQL class

This class is a simple wrapper to access MySQL databases. It can establish connections to a given MySQL server and execute SQL queries in a single call. The query result resource handle, columns names, number of returned rows and last ins...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows
• Licenses
  • Freeware

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

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows
• Licenses
  • Other Free / Open Source License

BuilderEditor

BuilderEditor is a powerful and easy to use ASP.NET RAD component for maintaining a datasource (e.g. SQL database, dataset). It allows you to add, edit, delete and display data from a data source. It generates the data entry forms used to insert and ...

• Categories
  • ASP.NET →
  • Scripts and Controls →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Commercial License,
  • Free for non-commercial use

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

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD
• Licenses
  • GPL

VB.NET 2005 Tutorials: Access and Manipulate SQL Server data

VB.NET 2005 Tutorials: Access and Manipulate SQL Server data - Using Ad Hoc Queries - In this tutorial you will learn about Consuming and Manipulating Data Viz. Access and Manipulate SQL Server data - Using Ad Hoc Queries; Running Queries, The SELECT...

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Linux
• Licenses
  • Freeware

PHP MySQL Database Class

A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement phase. Currently connects to a database, execute external files containing ...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • GPL

Simple SQL

DESCRIPTION: Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs. ADVAN...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

SQLiteManager

SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4 and work fine with PHP5. Work just as well on a platform Linux as on Windows or Mac OsX. This project is in course of developpement...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

dbf Converter

dbfConverter is a PHP script that reads data from dbase files (dbf,dbt,fpt) and convert them into the mysql or postgres tables. Initially, it create sql tables && insert data, and then updates old data. It does not support index files convert...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware