|
| Home | Accessibility | Courses | Diary | The Mouth | Forum | Resources | Site Map | About Us | Contact |
 Related technical and longer articles MySQL version 5, PHP version 5 and mysqliMySQL and PHP - enquiry tool for ad-hoc requirements MySQL and PHP - enquiry tool for ad-hoc requirements Interfacing applications to a MySQL database engine Tips and short articles on this subject Uploading to a MySQL database through PHP - examples and common questionsDownloading data for use in Excel (from PHP / MySQL) Easy selection of multiple SQL conditions from PHP Using a MySQL database to control mod_rewrite via PHP Viewing images held in a MySQL database via PHP Python to MySQL Using a MySQL database from Perl Well House Consultants
You are on the site of
Well House Consultants
who provide
Open Source Training Courses
and business
hotel accommodation. You are welcome to browse and use
our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java ResourcesWell House Manor Resources Perl Resources Python Resources PHP Resources Object Orientation and General topics MySQL Resources Linux / LAMP / Tomcat Resources Well House Consultants Resources Extras Resources C and C++ Resources Ruby Resources Tcl/Tk Resources Web and Intranet Resources | Interfacing Applications to MySQL Databases - module S156
Structured Query Language is, as its name implies, a programming language. Application programs send commands in SQL to the relational database and also provide the application's user interface. In other words, they provide the glue between the application user and the database. Such programs can be written in a variety of languages including C, PHP, Java and Perl.
This topic is presented on public courses MySQL, Extra Day Examples from our training material
Specialist books Opentalk forum discussions related to this topic Perl and MYSQLConnecting to MySQL over an unreliable network Using ASP with MySQL SQL Injection Attacks Mysql Regex question MySQL Java PreparedStatement Quoting Use of qq to prevent Mysql injection Background information
This module is available under an Open Training Notes License for free download from http://www.training-notes.co.uk.
Topics covered in this module
Interfacing MySQL to Perl.
The Perl program in detail. A Further Example. Interfacing MySQL to PHP. Interfacing MySQL to Java. Interfacing MySQL to Tcl/Tk. Interfacing MySQL to C. When should I choose MySQL?. Brief comparisons. Limitations of MySQL, and work-arounds. subselects. transactions and commit/rollback. Foreign keys and referential Integrity. Stored procedures and triggers. Views. Record level privileges and locking. Why are the limitations not always limitations?. Course links
The following web pages are used as references / examples in this module
[Link] mysqltcl - Tcl Mysql Interface (version 2.50) (at http://www.xdobry.de/mysqltcl) [Link] JDBC Drivers (at http://industry.java.sun.com/products/jdbc/drivers) We check these links from time to time with a spider written in PHP. Latest full check was on Saturday, 12th June 2004. Titles are extracted from the web pages listed. Complete learning
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page. Well House Consultants specialise in training courses in Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us. We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions. |
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho