Select a Category

How to add directory into Windows Environment

Problem

When you type a command on Windows XP command prompt, Windows refuses to run it because its executable file is not in the current directory.

Solution

You can change to executable file’s directory and run it. Or you can add the executable file’s directory into Windows Environment, the Windows’ Path.

Access Windows Control Panel […]

Synchronizing Computer Time with Internet Time

Problem

You have multiple computers in your plant. All of them show different time. Same event on different computer was logged at different time. It is very hard to trouble shot a problem with log files from different computer.

Solution

You can synchronize Windows XP computer’s time to a time server.

Click on the clock […]

How to Contruct Multi-Line MySQL Script

Problem

You want to run multiple MySQL commands in sequence constantly. You can type them in one by one, which is time consuming and subjected to errors. Or you can encapsulate them in a script.

Solution

Here is one example of a Multi-Line MySQL script:

mysql –user=’username’ –password=’userpassword’ <<sqlscript use sample_database UPDATE comments […]