Archive for the ‘mysql’ Category

Now with added Slicehost

This website is now hosted on Slicehost (along with section99.net). It’s a little early to know how it will turn out, but so far I’m loving having not only a shell, but root access.
Signing up was completely painless and the the VPS was provisioned within minutes with several different operating system options (though [...]

Posted by Matthew on January 26th, 2008

Filed under linux, mysql, php, website | No Comments »

Very Simple (Pretend) SQL Paramaters

<?php

/*

    Some hacked up code for Very Simple (Pretend) SQL Paramaters
    — For when you don’t have PDO, or just can’t be bothered

    Examples:

        >>> SQL("SELECT * FROM users WHERE id=? AND name LIKE ?", 123, ‘"123\"’);
        SELECT * FROM users WHERE id=123 AND name LIKE [...]

Posted by Matthew on December 10th, 2007

Filed under mysql, php, programming | No Comments »

qpsmon v0.1

This is a simple script that will print the average qps (using a specidied peri0d) for one or more MySQL databases. If doesn’t have many practical uses, but it’s fun to watch when running large imports or exports.
Screenshot

<?php
/*

    qpsmon.php  v0.1

    This is an (extremely) simple script that will get the average
    [...]

Posted by Matthew on October 8th, 2007

Filed under mysql, php, programming | No Comments »

MySql: Always learning something new

mysql>  SELECT "50" > 100, 50 > "100", "100" > 50, 100 > "50", "100" > "50", "50" > "100";
+————+————+————+————+————–+————–+
| "50" > 100 | 50 > "100" | "100" > 50 | 100 > "50" | "100" > "50" | "50" > "100" |
+————+————+————+————+————–+————–+
|          0 |          0 [...]

Posted by Matthew on July 24th, 2007

Filed under mysql, php, programming | No Comments »

Working with MySQL

matthewd@carbonara:~$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2792799
Server version: 5.0.38-log Gentoo Linux mysql-5.0.38

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use b3
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with [...]

Posted by Matthew on July 2nd, 2007

Filed under mysql | 2 Comments »