MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM [...]

These are some MySql commands (most run at the command line in linux) that I’ve been collecting since getting a few sites set up on linode. The “#” indicates that it is to be run from the unix shell. When you see “mysql>” the command is to be run from the MySQL command prompt after [...]

What is a Disconnected Recordset? A Disconnected Recordset is A recordset object that exists in an application, but does not have an associated data connection associated with it. Why use a Disconnected Recordset? The ADO Recordset is considered an extremely “rich object model” which means it provides more functionality than say, an array. Also, you can load [...]

This is a simple VBS VBScript that I use to delete all files in a given folder on a machine. It is particularly useful to delete internet cache files or cookies. You can set a scheduled job actually, to perform this task nightly. This script could be easily modified to, say, clear out your temporary [...]

I needed a quick vbscript to terminate a specific windows process that seemed to hang. This is the script that will do it. It uses SQL to lookup the process name from the win32_process list, then uses the terminate function to close it. NOTE: this vbs to terminate a windows process was only tested on [...]

Robar's Pages Halifax Where is the Fairview Overpass? Saint Mary's University (SMU) Switches from WebCT to BlackBoard for Online Course Tools Halifax Nova Scotia Campground With Wireless Internet Access Wi-Fi hp skate vid 7 hp skate vid 6 Halifax Wedding Reception Halifax Everything About Sex Show – A Gong Show hp skate vid 5 hp [...]