Tags → Sql Insert Select

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

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

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

AITOC BackUp Manager - MS SQL Server Backup Solution

MS SQL server backup/restore application. Very useful if you want to backup only certain selected SQL tables not the entire database. It allows to: 1. Back up selected database tables separately (as .sql script file - insert clause) 2. Restore da...

• Categories
  • Tools and Utilities →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Free Trial