Tags → Query Select Mysql

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

Database Functions

This class can be used to build and execute MySQL database queries. It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values. The class can also execute the generated queries and retrieve the SELECT query...

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

mysqlForm

This class can be used to create HTML forms for entering values to create new records of a MySQL database table. It identifies the list of fields of a given mysql table. Then it generates HTML for a form that includes inputs to enter values for...

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

Mysql Select Query

This simple script uses the DBI module in order to connect to a Mysql database, retrieves the results from a select query and display the results inside a while statement. There is a live example as a demo.

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Other Free / Open Source License

Celko Visitation Model

This class can be use to manipulate hierarchic trees of records stored in a MySQL database using Joe Celko visitation model. It can perform the following tasks in a very effecient way mostly using one SELECT query statement: - Find out le...

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

generateAfeed dB

generateAfeed dB is a script based tool which generates automatically RSS feeds 2.0 for your website from the information contained in a database. generateAfeed dB is easy to install and contain an HTML webpage to configure the number of feeds you wa...

• Categories
  • ASP.NET →
  • Web Sites
• Platforms
  • Windows
• Licenses
  • Commercial License

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

Cascade Select

This class is meant to generate two HTML form select type inputs making the currently selected value on the first input determine the option values that are made available on the second. It uses JavaScript to update the second input options when...

• Categories
  • PHP →
  • Scripts and Programs →
  • Development Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Sun Solaris
• Licenses
  • Freeware

EMS SQL Query 2005 for MySQL

EMS SQL Query for MySQL is an utility that lets you quickly and simply build SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases,...

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

Stouk DBViewer

View pre-configured tables from MySQL or Oracle data sources; Test multiple select statements and view the results as well as save queries with explanation for future use; Export result of any query into comma-separated or MS Excel formats; Modify...

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