An example of code colorizing MySQL table creation.
This example shows creation of a simple contact list, or client list.
1
2
3
4
5
6
7
8
9
CREATE TABLE IF NOT EXISTS `clients` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`email_address` VARCHAR(72) character SET ASCII NOT NULL,
`firstname` VARCHAR(16) character SET utf8 NOT NULL,
`lastname` VARCHAR(20) character SET utf8 NOT NULL,
`date_added` DATETIME NOT […]
For those of you that were still wondering if cloud computing would really catch on: Oracle and Amazon have just announced that several Oracle products can now be licensed to run on Amazon’s EC2, while backups can be made on Amazon’s S3 web service through the Oracle Secure Backup Cloud module.
One of the big advantages […]
If you are migrating a database with business logic inside (typically SQL Server and Sybase) to Oracle, it can happen that translation process to freeze during converting a particular stored procedure or trigger.
The problem come up when finding lots of IF… ELSE loops inside the stored procedure and this will be solved in the next […]
I finally got around to reading this update from Red Hat about Spacewalk, the open source version of Red Hat Network Satellite, launched in June.
Other than the progress in attracting participants and patches, the interesting news is that PostgreSQL support is being added after being demanded by the community. The roadmap confirms that work on […]
If you use Firefox, you’re in for a treat. If not, please download it and resume reading about Ubiquity and how you can use it to query the Oracle database documentation library and do other neat stuff using simple commands.
Jake was struggling to define it, but basically, Ubiquity is a Firefox extension, a powerful one. […]
A simple page for testing the connection to a MySQL database. The PHP script will test the server address, username and password. If the database field is left empty, it will return a list of available databases. Testing a specific database is optional, but if a database name is supplied, it will […]
I have packaged and released version 0.2.3 of gerald. This is mainly a tidy up and bug fix release, with numerous additional unit tests. You can find all of the details in the CHANGELOG.txt file that comes with the source distribution (or view it here) but in a nutshell the changes from the last release […]
The scenario: I am given a huge CSV File dumped thru FTP from some big JDE-ish system everyday. The CSV File is about 15MB or so. The file has around 60,000 lines in it.
What I needed to do is to update a “main” transaction table. Which means I have to lookup each line […]
If you have a datawarehouse and the data are getting to big for a full duplicate or tablespace transport, if you want to experience more about Streams or simply if you are in San Francisco and wants some distraction on Thursday after at 1pm, do not miss Chen session Oracle Streams - Live Demo
Oracle OpenWorld […]
I’ve waited far too long for VertrigoServ developers to come up with a stable Windows Vista version of their popular web server software. It is because their current version as of this writing (version 2.21) causes random blue screen of the death on my Windows Vista system, and after doing some search online, this […]