MySQL

How to Work with MySQL – Basic Tasks

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]

No Picture
SQL Server

Update Field Based on a Field in Another Table

This article contains 3 examples: – T-SQL; – MS Access; – AS/400.   This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from   UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one […]

SportWebCenter

Sat 08:45-NS + Sun 08:00-NS

2022-10-27 TH Both groups are now trying to start earlier to be kick out by regular 10AM season-scheduled games. By in most cases we still can get one of the turf fields. 2021-09-12 MO Tuesday and Thursday games are slowly dying due to earlier sun sets and lower attendance.  But […]