Posts Tagged ‘ Field ’

Sat *WARREN* 09:00 – – – Sun *BROWN* 09:00

2017/10/17
By
Modified: 2017/10/15
IMG_0037

09:00 2017-10-15 SU Next statistical game – October 28 / 29 2017-09-10 SU Moving Sunday games to Brown 2017-07-30 SU We are back to WARREN both SAT and SUN 2017-07-16 SU We will play Sundays games on Brown 2017-04-23 SU We are moving to Warren 2017-01-29 SU – There will be no statistics till Sunday, January 29. 2017-01-02 MO – New Year holiday Bonus Game (unofficial) 2016-12-30 FR This is how we looked exactly 10 years ago – 2006-12-31 – Newton Brown field (see picture below) 2016-12-26 MO – Christmas Special game 2016-11-27 SU – From now on – only SAT and SUN games at Brown.  Unfortunately lights are out on WED 2016-11-24…

Read more »


How to Work with MySQL – Basic Tasks

2017/09/16
By
Modified: 2017/09/10
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 of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…

Read more »

Update Field Based on a Field in Another Table

2017/06/02
By
Modified: 2017/04/30

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 filed CertMemberLevelID in table UPM_MemberPermissionMask based on field Cert2ID in table zzzCertRegistryUpdate. This next example was generated using MS Access 2007 syntax: UPDATE CRPDTA_F1201 INNER JOIN CatCode7 ON CRPDTA_F1201.FANUMB = CatCode7.XXNUMB SET CRPDTA_F1201.FAFA7 = [CatCode7].[XXFA7] A field FAFA7 in CRPDTA_F1201 is being updated. Table  CatCode7 contains 2 fields: – ID Link field XXNUMB and – Update values field XXFA7 SQL statement JOINs two…

Read more »

How to Get SQL Table Field Structure?

2017/05/15
By
Modified: 2017/04/30
SQL-2008-R2

Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface.

Read more »