Explore the Links

Access

MS Access - JDBC-ODBC Bridge Driver

This article provides tutorial notes on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database.

 

 

Read More
SQL Server

SQL Server Tutorials - Getting Started with Transact-SQL Statements

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements. Read More
MySQL

MySQL FAQs - Command-Line End User Interface mysql

A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats. Read More
Databases & SQL

Oracle DBA FAQ - Understanding SQL SELECT Query Statements

A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries Read More
Access

Database Solutions & Downloads Microsoft Access

databasedev.co.uk

Read More
MySQL

MySQL Cheat Sheet

The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size MySQL cheat sheet.

Read More
MySQL

phpMyAdmin & phpMyAdmin themes

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.

Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 48 languages. Read More

MySQL

MySQL Migration Suite

MySQL introduced a new visual tool: A new beta of the visual, GUI-based MySQL Migration Suite is freely available from the company’s Web site under the GPL open source license. It currently supports Oracle and Microsoft Access, with Microsoft SQL Server, Sybase, DB2, and Informix databases to be supported in the future.

Read More