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 [...]

If you are looking for a Cross Browser Compatible CSS Opacity code, you need look no further. The following provides 100% opacity (which is the same as 0% transparency.) 1 2 3 4 5 6 7 8 9 10 Body {   …your body css…   -moz-opacity: 1.0 !important; -webkit-opacity: 1.0!important; -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)" !important; filter: alpha(opacity=100) !important; opacity: [...]

Groove is a component of Microsoft Office enterprize 2007. If you don’t use the groove service, you can uninstall it. Go to “Add-Remove Programs” find your MS office installation in the menu click CHANGE (not remove) Find the Groove item in the list Change the indicator to “Not available” let the process finish reboot. This [...]

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 [...]

Here is a simple credit card expiration date regular expression. I wrote my own regexp for the expiration date since one was not easily found on the net. This one validates for allowing the year 2009 to 2029, but could be easily changed…I built this for an ASP.NET programming project for a course I’m taking. [...]

I needed to edit a recording I made from a TV show with the Windows Media Center, and I assumed at first that the files would be .avi or .wmv or something I was used to. It turns out that they were .DVR-MS format, which is a proprietary MS format that can not be easily [...]

Today, there are a variety of ideagora companies just waiting to fill the R&D need and to solve the problems of today’s corporations, educational institutions, and government agencies. yet2,com is one of the oldest ideagora companies, and has been on the web since the dot com boom. Today, a variety of corporations use yet2 to [...]

Wow. I was embarassingly had by this one yesterday. 2 full years of virus free computing in my home office. I’m still not sure what happened but it was most likely from a site I was browsing. Basically, the stuff on castlecops, and other sites with steps to rid yourself of this virus DO NOT [...]