MySQL II : Ruby

Using MySQL With Ruby To get the Ruby API connector go to http://dev.mysql.com/downloads/. See “Using the Ruby MySQL Module” by Paul DuBois at http://www.kitebird.com/articles/ruby-mysql.html.

MySQL II : Java

Using MySQL With Java To get the Java API connector go to http://dev.mysql.com/downloads/. See “Writing JDBC Applications with MySQL” by Paul DuBois at http://www.kitebird.com/articles/jdbc.html.

MySQL II : Procedures, Views & Triggers

MySQL 5: Using MySQL With Python Using Stored Procedures, Views and Triggers   Initial Exercises Go to this page: http://www.kitebird.com/articles/pydbapi.html Perform the tests at the top of the page to confirm your installation. Then work your way through writing and running the animal.py script.   Advanced Exercises Sign Up With LinuxMagazine.com . For the first …

MySQL II : Python

Setting Up MySQL With Python Get Python 1. Go to http://www.sourcekeg.co.uk/www.python.org/2.4.2/rpms.html and get python24-2.4.2-2.i386.rpm. Install this by issuing the command: rpm -i python24-2.4.2-2.i386.rpm (Historical note: you can get a tarball and install it like this: Go to http://python.org/2.4.2/ and get Python 2.4.2 (http://python.org/ftp/python/2.4.2/Python-2.4.2.tgz or http://python.org/ftp/python/2.4.2/Python-2.4.2.tar.bz2 – the bz2 is smaller). Copy or move it to …

MySQL II : PHP

Using MySQL With PHP If necessary, get the PHP API connector at http://dev.mysql.com/downloads/.   PHP Basics Creating Scripts Open and close scripts like this: <?php $var = “Hello world!”; print $var; ?>   Variables PHP variables (like many Perl and Bash variables) begin with $ . Use a single = sign to assign a value: …

MySQL II : GUI Tools

GUI Tools MySQL AB’s GUI Tools ¬†http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL AB also offers their own GUI tools, available (as usual) under their dual-license model. See http://www.mysql.com/products/tools/. MySQL Administrator Administrator is similar to phpMyAdmin, and is under rapid development. Try it: Download and install the Administrator. Download the RPM file and use the GUI interface to install it. …