Categories
Tags → Sql 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...
DETAILS

MyDBDB MySQL multi-databases browser

This set of scripts can be used, with minor customization, to access multiple MySQL databases (hence, &"DBDB&"), even at different servers (if they are accessible from the web server where these scripts run), for displaying data in ...
DETAILS

DTM Data Editor

DTM Data Editor is a data viewer and editor for database professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC data source. SQL statements are generated automatically and c...
DETAILS

Ultra Power Board

Ultra Power Board is a fast and secure bulletin board system. Features a SQL powered backend, supporting many popular database providers, MySQL, MSSQL, and PostgreSQL. Unlimited forums, members and groups. Detailed Who''s Online feature. Complet...
DETAILS

IP2Location DB11

This is ASP script to enable lookup of country, region, city, latitude, longitude,zip code and Timezone from IP address by using IP2Location database. Free sample database available at http://www.ip2location.co m. The script supports several d...
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

An Useful Method : RecordSet.Filter

Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
DETAILS

EMS DB Extract 2005 for SQL Server

EMS DB Extract for SQL Server is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract proce...
DETAILS

Basic MySQL Search Engine Class

This class can be used to search for data in MySQL database table text fields. It executes one or more SQL SELECT queries to search for given keywords in different text fields of the same MySQL database table. The class returns an array w...
DETAILS

AutoCRUD for PHP

The AutoCRUD for PHP library is a CRUD library, which handles most of the common tasks when using a database: insert, update, delete, select and get. But this library also provides extra functionality. It is able to automatically handle relatio...
DETAILS

Page:
©2003-2019 jCay.com