MySQL Basics -- A Helpful MySQL Tutorial

Introduction

Welcome. This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time.

MySQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. MySQL is frequently used by PHP and Perl scripts. The SQL commands discussed in this tutorial apply to MySQL operating under all operating systems. Only the installation instructions are Windows specific. The focus is on Windows XP Professional and Windows 2000 Professional machines.

We'll be covering the installation of MySQL versions 5.0.51b, 4.1.16 as well as how to configure everything so they'll all be able to run on your system at the same time. Plus, the data directories will be moved to another location in order to make backups easier. If you only want to install one version of MySQL, ignore the instructions relating to the other versions.

If your operating system or versions of MySQL are different, the instructions should still work, but keep an eye out for slight differences, like which working directory you'll need to be in.

Usage:
Commands to type in and items that require appropriate substitutions are displayed like this.
Resulting screen text looks like this.
File names appear in this fashion.

Contents

• Windows 2000 and Windows XP Installation
  • Creating Command Prompt Shortcuts
  • Operating System Privileges for the MySQL Service
  • File System Permissions for the MySQL Directories
• Quick Tips for Other Windows Operating Systems
• Start the Client and Log In
• Tighten Security
• Creating a Simple Database and Displaying its Structure
• Putting Data into a Table
• Adding Fields
• Multi-line Command Entry
• Insert Some More Records into the Table
• Updating Existing Records
• Deleting Records
• Time to Call it Quits
• In Closing

Windows 2000, XP and NT 4.0 Installation

Log in to your computer using an account having Administrator privileges.

If you're not upgrading, just skip down to the next section.

If you are upgrading, there are MANY changes that you HAVE TO be aware of. Carefully read the pages in the MySQL manual that apply to you. If you intend to jump over a release series in your upgrade (e.g.: going straight from 4.0 to 5.0) you are strongly advised NOT to do so. You should do the upgrade process one release series at a time (e.g.: go from 4.0 to 4.1, then to 5.0).

• Upgrading from MySQL 5.0
• Upgrading from MySQL 4.1 to 5.0 (also includes several changes made between 5.0 versions)
• Upgrading from MySQL 4.0 to 4.1

Backup Old Data

Here's a quick rundown of how to save your old MySQL data so it can be used in your new system.

1. Open up a Command Prompt window. If you don't know how to do that, go to Start | Run, then type in cmd and hit ENTER.
2. Switch to the drive which has your present mysql\bin directory. Eg: L:\> C:
3. Move into the MySQL bin directory: cd mysql\bin
4. Dump all of your data: mysqldump -u root -p -A -r C:\secure\myolddata.sql
5. Stop the MySQL service: net stop mysql. If your service has a different name, do this net stop service_name.
6. The ISAM table format has been deprecated in 4.0 and removed from 5.0. If have some tables in that format, you'll need to fix that now. There are several ways to do this. Here are three possibilities:
   1. sed:
      1. ren C:\secure\myolddata.sql C:\secure\myolddataorig.sql
      2. sed 's/^) TYPE=ISAM/) TYPE=MyISAM/' C:\secure\myolddataorig.sql > C:\secure\myolddata.sql
   2. Perl:
      1. ren C:\secure\myolddata.sql C:\secure\myolddataorig.sql
      2. perl -wpe 's;^\) TYPE=ISAM;\) TYPE=MyISAM;i' < C:\secure\myolddataorig.sql > C:\secure\myolddata.sql
   3. Your favorite text editor: open C:\secure\myolddata.sql then do a search and replace on TYPE=ISAM to TYPE=MyISAM.
7. Remove the existing service by typing in mysqld --remove. If your service has a different name, do this mysqld --remove service_name
8. Jump up two directory levels: cd ..\..
9. Rename your old mysql directory as a backup: ren mysql mysqlold

Get and Install a Recent Version

1. Download the "Windows ZIP/Setup.EXE" file for the versions you want: 5.0, and/or 4.1. For now, do NOT pick the "Windows Essentials (x86)" or "Without installer (unzip in C:\)" downloads.
2. Find the downloaded file, unzip it and start the setup program:
   • Via Cygwin:
     1. cd /path/to/file
     2. unzip mysql-version.number-win.zip -d temp
     3. chmod 700 temp/*
     4. explorer temp
     5. Double click on Setup.exe.
   • Via Windows XP:
     1. Open up Windows Explorer. If you don't know how to do that, go to Start | Run, type in explorer and hit ENTER.
     2. Find the downloaded file.
     3. Double click on it.
     4. Windows XP has a built in zip file reader.
     5. In the zip viewer, double click on Setup.exe .
   • Via WinZip or PKZIP for Windows, or other such utilities:
     1. Open up Windows Explorer. If you don't know how to do that, go to Start | Run, type in explorer and hit ENTER.
     2. Find the downloaded file.
     3. Double click on it.
     4. Extract the files.
     5. Flip back to Windows Explorer and double click on Setup.exe .
3. In the Installation Program:
   • MySQL 5.0.x and 4.1.x:
     1. In the "Please select a setup type" step, click the "Custom" radio button, then "Next."

     2. The next step gives you choices of which components to install and where to install it.

        Click the "Change" button at the bottom right of the dialog box and put in C:\program files\mysql50\ then click "OK"

        If you're upgrading, make sure to click on the plus sign next to the "Developer Components" item, then click on "Scripts, Examples" and set it to "This feature will be installed on the local hard drive."

        Adjust the other entries per your desires. Make sure the "MySQL Server" and the "Client Programs" are selected. Once you have everything lined up as you want, click "Next."

     3. Click "Install."
     4. When you get to the "MySQL.com Sign-Up" step, let's cut to the chase... click the "Skip Sign-Up" radio button and go to "Next."
     5. UN-check "Configure the MySQL Server" and click "Finish."
4. Taking a moment to make Command Prompt shortcuts now will save loads of time later:
   1. Open Windows Explorer (Start | Run, explorer, ENTER).
   2. Navigate to C:\Documents and Settings\All Users\Start Menu directory.
   3. Create a new directory (File | New | Folder). That makes a new folder called, "New Folder" (imagine that!) which is now ready for you to type in a new name for. So, type in Databases and hit ENTER.
   4. Now hit ENTER again to get into that folder.
   5. Open another Windows Explorer window.
   6. In the Address Bar, type in %UserProfile% and hit the ENTER key. If the Address Bar isn't visible, in Windows Explorer's menu: View | Toolbars | Address Bar.
   7. Navigate to the Start Menu\Programs\Accessories directory.
   8. Select the Command Prompt file.
   9. Hit CTRL-C
   10. Now come back to the "Databases" folder window and hit CTRL-V. That should have pasted a copy of the Command Prompt shortcut in your new directory.
   11. Select the Command Prompt file.
   12. What you do here depends on whether you're installing 5.0 and/or 4.1.
       • MySQL 5.0.x:
         Use the follow these steps verbatim.
       • MySQL 4.1.x:
         Use these steps, but change 50 to 41.
       • Multiple versions:
         Do the steps for 50, make a copy of MySQL 50 Prompt and then follow steps I and II, but change 50 to 41.
       1. Hit the F2 key and rename the shortcut MySQL 50 Prompt then hit ENTER.
       2. Open it's properties via File | Properties and go to the "Shortcut" tab, then the "Start In" box and type the following in, including the quotes: "C:\program files\mysql50\bin"
       3. Go to the "Options" tab and check the "QuickEdit mode" and "Insert mode" boxes.
       4. Go to the "Layout" tab and go to the "Height" box in the "Screen buffer size" section and put in a larger number, like 2000.
       5. Click OK
   13. Now, you'll be able to quickly get to either of the Command Prompts by going to Start | Databases | MySQL 50 Prompt.
   14. Plus, you'll be able to paste commands into the the Command Prompt! To do that, copy the command from this tutorial (or wherever) then go to the Command Prompt window and hit the following keys:
       1. ALT-SPACE (to open the menu in the upper left corner of the window)
       2. E (the access key for Edit)
       3. P (the access key for Paste)
   15. For the rest of this lesson, we'll be calling this these the "MySQL 50 Shortcut" and "MySQL 41 Shortcut"
5. Time to create the data directories. MySQL's data files should be stored on a drive, or a portion thereof, that contains your other data files. This will simplify finding and backup up your information. The M: drive on my machine is dedicated solely to storing actively used data. That's the location we'll use in this tutorial.
   1. Open up a Command Prompt window. If you don't know how to do that, go to Start | Run, then type in cmd and hit ENTER.
   2. Switch to the drive where the data will be placed: C:\> M:
   3. Make the needed directories:
      • MySQL 5.0.x:

        mkdir mysql50mkdir mysql50\datamkdir mysql50\data\mysqlmkdir mysql50\ibdatamkdir mysql50\iblogs

      • MySQL 4.1.x:

        mkdir mysql41mkdir mysql41\datamkdir mysql41\data\mysqlmkdir mysql41\ibdatamkdir mysql41\iblogs

   4. Copy the default mysql database/privileges to the new location:
      • MySQL 5.0.x:

        copy "C:\program files\mysql50\data\mysql" mysql50\data\mysql

      • MySQL 4.1.x:

        copy "C:\program files\mysql41\data\mysql" mysql41\data\mysql

6. I suggest putting empty my.cnf files in place in order to keep your MySQL servers from being subverted. While this step isn't strictly necessary, it's better to be safe than sorry. We'll do this via the Command Prompt window we were using above.

   Be aware that Windows considers .cnf files to be a "SpeedDial" configuration file and automaticlaly hides the file extension. You can make the extension visible via Windows Explorer's "hide file extensions" option (Tools | Folder Options | View). Also note that Windows Server 2003 hides the extension even if this option is turned off.

   • Just MySQL 5.0.x:
     1. notepad mysql50\data\my.cnf
     2. In notepad, type in [mysqld] , save the file and exit.

     3. copy mysql50\data\my.cnf "C:\program files\mysql50\data"

   • Just MySQL 4.1.x:
     1. notepad mysql41\data\my.cnf
     2. In notepad, type in [mysqld] , save the file and exit.

     3. copy mysql41\data\my.cnf "C:\program files\mysql41\data"

   • All of the above
     1. notepad mysql50\data\my.cnf
     2. In notepad, type in [mysqld] , save the file and exit.

     3. copy mysql50\data\my.cnf "C:\program files\mysql50\data"copy mysql50\data\my.cnf mysql41\datacopy mysql50\data\my.cnf "C:\program files\mysql41\data"

7. The my.cnf configuration files need to be put in place. First, we'll put blank files in the default locations in order to prevent the server from potential subversion. Do this via the Command Prompt window we were using above.
   1. notepad C:\my.cnf

   2. In notepad, paste in the following, then adjust the the port numbers and drive letters and paths as needed.

      NOTE: This sample file puts 5.0.x on the default port (3306) and 4.1.x on 3341. These port numbers will be used throughout the rest of the tutorial. So, if you change anything in your my.cnf file, you will need to adjust all of our commands accordingly. On the command line, MySQL uses the -P flag to tell the client which port to connect to, for example -P 3341.

      # This config file contains settings for MySQL versions# 5.0.x and 4.1.x.  Be aware that only one server# instance can be on a given port.  This sample puts# version 5.0.x on MySQL's default port, 3306.  Adjust# the port numbers to suit your situation.[mysql]# Displaying the version number in the prompt# helps when running multiple instances.prompt = mysql\\_\v>\\_[mysqld-5.0]port = 3306basedir = C:/Program Files/mysql50/datadir = M:/mysql50/data/innodb_data_home_dir = M:/mysql50/ibdata/innodb_log_group_home_dir = M:/mysql50/iblogs/innodb_data_file_path = ibdata1:10M:autoextend# Make table names case sensitive.# Ensures portability when moving applications to other os's.set-variable = lower_case_table_names=0# Roll back entire transactions that time out,# OPTION AVAILABLE SINCE 5.0.32.innodb_rollback_on_timeout = 1[mysqld-4.1]port = 3341basedir = C:/Program Files/mysql41/datadir = M:/mysql41/data/innodb_data_home_dir = M:/mysql41/ibdata/innodb_log_group_home_dir = M:/mysql41/iblogs/innodb_data_file_path = ibdata1:10M:autoextend# Make table names case sensitive.# Ensures portability when moving applications to other os's.set-variable = lower_case_table_names=0

   3. Save the file and exit.
8. Next, we need to "install" the appropriate MySQL services.
   • MySQL 5.0: Open the MySQL 50 Shortcut, pick one of the following and type its command into the Command Prompt:
     1. NT/2000/XP. Named pipes.
        mysqld-nt --install mysql50
     2. Transactions.
        mysqld --install mysql50
     3. Support for debugging MySQL crashes.
        mysqld-debug --install mysql50
   • MySQL 4.1: Open the MySQL 41 Shortcut, pick one of the following and type its command into the Command Prompt:
     1. NT/2000/XP. Named pipes.
        mysqld-nt --install mysql41
     2. Transactions.
        mysqld --install mysql41
     3. Support for debugging MySQL crashes.
        mysqld-debug --install mysql50
9. Good security procedures call for running services as a non-privileged user. So, let's create such a user and configure the MySQL services to use it:
   1. net user mysql * /add /passwordreq:yes /passwordchg:no /comment:"runs MySQL services"
   2. You'll be prompted for the password.
   3. Perform the following steps for each mysql server instance, substituting your version numbers for the underscores (__):
      1. Start up the services manager by typing in services.msc and hitting ENTER.
      2. Locate the "mysql__" service in the right hand pane and double click it.
      3. Go to the "Log On" tab
      4. Click the "This account" radio button
      5. Type mysql into the box.
      6. Enter the password into the "Password" and "Confirm password" inputs.
      7. Hit OK

10. Let's lock down the file permissions on the directories we created by entering the following commands into a Command Prompt:
    cacls C:\my.cnf /g administrators:f system:r "authenticated users":r

    If you may get the following error message: The cacls command can only be run on disk drives that use the NTFS file system. Don't worry about it (for now). Skip all the cacls commands in the rest of our tutorial.

    Enter each line below separately because some of them require user confirmation.

    • MySQL 5.0.x:

      cacls M:\mysql50 /t /g administrators:f system:f mysql:ccacls M:\mysql50\data\my.cnf /t /g administrators:f system:rcacls "C:\program files\mysql50" /t /g administrators:f system:f mysql:r "authenticated users":rcacls "C:\program files\mysql50\data" /t /g administrators:f

    • MySQL 4.1.x:

      cacls M:\mysql41 /t /g administrators:f system:f mysql:ccacls M:\mysql41\data\my.cnf /t /g administrators:f system:rcacls "C:\program files\mysql41" /t /g administrators:f system:f mysql:r "authenticated users":rcacls "C:\program files\mysql41\data" /t /g administrators:f

11. Start the services:
    • MySQL 5.0.x: net start mysql50
    • MySQL 4.1.x: net start mysql41

    If System error 1069 has occurred comes up, your passwords didn't match. You can create a new password by typing net user mysql * into the Command Prompt. Then put that new password into the MySQL services' properties' "Log On" tab.

    Getting a System error 5 has occurred indicates problems getting to the directory containing the MySQL executables (for example, insufficient permissions).

    If you get an error saying System error 1067 has occurred it means a configuration directive in C:\my.cnf couldn't be processed. That can be due to a typographical error in the name or value of a setting. Similarly, the path referred to by the setting's value could be inaccessible due to insufficient permissions.

    To help narrow down what's going on, check out the Event Viewer: Start | Run, then type in eventvwr.msc and hit ENTER. Click the "Application" item in the left pane. Now examine the top of the right hand pane for recent MySQL errors. Double click the first item and look at the message in the "Description" box.

    Either of the following mean there's a boo-boo in the path value assigned to the datadir setting in C:\my.cnf:
    Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    or
    Warning: Can't create test file
    In this situation, make sure the actual path is a case-sensitive match to the path in the configuration file and that the directories in question have the permissions they need to be accessed by the MySQL daemon. Then try the net start command again.

    Along the same lines, error logs showing Can't find messagefile 'C:\Program Files\mysql\share\english\errmsg.sys'
    points to a mismatch between the basedir value and the actual path to the MySQL executables.

    An unknown variable notice is clear enough, no?

    If there are no MySQL related error messages in the Event Log's Application section, you have a major typo in the C:\my.cnf. Perhaps one of the [mysql...] section headings are wrong.

12. If you're upgrading and followed our instructions at the top of this tutorial, now it's time to import your old data. These steps assume upgrading from 4.1 to 5.0.
    1. C:\Program Files\mysql50\bin> mysql -u root < C:\secure\myolddata.sql
    2. C:\Program Files\mysql50\bin> mysql -u root -f mysql < ..\share\mysql_fix_privilege_tables.sql

       This SQL file was in the scripts directory prior to version 5.0.38.

       You can ignore all of the query error messages (for example Unknown column, Duplicate column name, etc).

    3. Log into the server using the permissions from your old MySQL installation:
       C:\Program Files\mysql50\bin> mysql -u root -p mysql
    4. The upgrade script gives some privilges that you probably don't want most users having. Let's change them back (adjusting the "otherimportantusers..." below as needed for your system):
       mysql 5.0.51b-community-nt> UPDATE user SET Create_tmp_table_priv='N' WHERE user NOT IN ('root', 'otherimportantusers...');
    5. Exit the client and restart the server:
       mysql 5.0.51b-community-nt> exit
       C:\Program Files\mysql50\bin> net stop mysql50
       C:\Program Files\mysql50\bin> net start mysql50
    6. If you've never done this tutorial's "Tighten MySQL's Security" steps, below, check them out now. If you've already done them, you can jump down to the Start the Client section.
13. Tighten MySQL's Security

    MySQL has good security controls, but the default installation is wide open. So, if you're doing a new installation, let's close things up before we go any further.

    In the following commands, don't forget that if you changed the ports in the my.cnf file, you'll have to adjust the port numbers here.

    • MySQL 5.0.x:

      Activate the "MySQL 50 Shortcut" we created earlier then type in:
      mysql -u root mysql

    • MySQL 4.1.x:

      Activate the "MySQL 41 Shortcut" we created earlier then type in:
      mysql -u root -P 3341 mysql

    (If you get the following error message:
    ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
    That means the servers didn't stay started. The most likely reason is the my.cnf file has errors in it. Go back to the Start the services step and carefully read the section about checking the Event Viewer logs.)

    Once you are logged in, copy the following queries to Notepad and change NewPw to something unique. Now copy that and paste it into the command prompt window(s) you just opened.

    delete from user where Host <> 'localhost' and User <> 'root';delete from db;update user set Password=password('NewPw') where User='root';flush privileges;exit

14. Tada!

Quick Tips for Other Windows Operating Systems

If you're using Windows 95, 98 or ME do not run mysqld --install. These operating systems don't have the ability to host a "service." So, you need to run MySQL as a standalone application by executing the command mysqld --standalone.

I haven't run MySQL on these systems myself, so, for more information, check out the Starting MySQL on Windows 95, 98 or Me and Running MySQL on Windows sections of the manual or explore the MySQL Win32 Mailing List Archive.

Start the Client and Log In

We'll be using MySQL 5.0.x here. Adjust the shortcut and port as necessary.

Activate the "MySQL 50 Shortcut" we created earlier and type in
mysql -u root -p
then enter your password when prompted. You will then see the following output:

Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1 to server version: 5.0.51bType 'help;' or '\h' for help. Type '\c' to clear the buffer.

If your root account doesn't have a password on it, the above command won't work for you. You really need to get on top of security. Log in without the password:

mysql -u root mysql

Then set a password (changing "NewPw", of course):

update user set Password=password('NewPw') where User='root';flush privileges;

If you get an error saying Client does not support authentication protocol requested by server; consider upgrading SQL client when trying to connect, that means your client is from before version 4.1 while the server you are connecting to is using version 4.1 or later. The best solution is to install a current version of the MySQL client.

Creating a Simple Database and Displaying its Structure

Instruct MySQL to setup a new database

Database "database01" created.

All that really does is create a new subdirectory in your M:\mysql50\data directory.

Open the database

Database changed

Create a table

Query OK, 0 rows affected (0.00 sec)

Enclose entire list of field names between one pair of parentheses.
Commas are used between each field.
A space may be used after the comma between fields.
A comma is not used after last field.
This, and all SQL statements, are concluded by a semicolon ";".

List the tables

+----------------------+| Tables in database01 |+----------------------+| table01              || table02              |+----------------------+

List the fields in a table

+---------+----------+------+-----+---------+-------+| Field   | Type     | Null | Key | Default | Extra |+---------+----------+------+-----+---------+-------+| field01 | int(11)  | YES  |     |         |       || field02 | char(10) | YES  |     |         |       |+---------+----------+------+-----+---------+-------+

Congratulations! Pretty straightforward, eh?

Putting Data into a Table

Insert a record

Query OK, 1 row affected (0.00 sec)

Enclose entire list of field names between one pair of parentheses.
Enclose the values to be inserted between another pair of parentheses.
Commas are used between each field and between each value.
A space may be used after the comma between fields.

List all the records in a table

+---------+---------+| field01 | field02 |+---------+---------+|       1 | first   |+---------+---------+

Excellent!

Adding Fields

...one field at a time

Query OK, 1 row affected (0.04 sec)Records: 1  Duplicates: 0  Warnings: 0

...more than one at a time

Query OK, 1 row affected (0.04 sec)Records: 1  Duplicates: 0  Warnings: 0

The "add column" must be restated for each column.
Commas are used between each add column statement.
A space may be used after these commas.

The MySQL Manual fully explains each possible column data type.

Did it work?

+---------+---------+---------+---------+---------+| field01 | field02 | field03 | field04 | field05 |+---------+---------+---------+---------+---------+|       1 | first   | NULL    | NULL    | NULL    |+---------+---------+---------+---------+---------+

Multi-line Command Entry

The MySQL command line interface allows you to put a statement on one line or spread it across multiple lines. There's no difference in syntax between the two. Using multiple lines allows you to break down the SQL statement into steps you may more easily comprehend.

In multiple line mode, the interpreter appends each line to the prior lines. This continues until you enter a semicolon ";" to close out the SQL statement. Once the semicolon is typed in and you hit enter, the statement is executed.

Here's an example of the same exact SQL statement entered both ways:

Don't break up words:

When inserting or updating records, do not spread a field's string across multiple lines, otherwise the line breaks are stored in the record:

+---------+---------------------+| field01 | field02             |+---------+---------------------+|    NULL | Who thought of foo? ||    NULL | Pooh thoughtof foo. |+---------+---------------------+

Insert Some More Records into the Table

Add this record

Query OK, 1 row affected (0.00 sec)

Quotes must go around text values.

Standard date format is "yyyy-mm-dd".
Standard time format is "hh:mm:ss".
Quotes are required around the standard date and time formats, noted above.
Dates may also be entered as "yyyymmdd" and times as "hhmmss". If entered in this format, values don't need to be quoted.

Numeric values do not need to be quoted. This holds true regardless of the data type a column is formatted to contain (e.g. text, date, time, integer).

MySQL has a useful command buffer. The buffer stores the SQL statements you've entered thus far. Using it keeps you from having to retype the same commands over and over. Let's use this next step as an example.

Add another record using the command buffer (and optional date and time formats)

1. Hit the up arrow key twice.
2. Hit the ENTER key.
3. Type in the new values between a pair parentheses and stick a closing semicolon on the end.
   (3, 'a third', 'more foo for you', 19991024, 103004);
4. Hit the ENTER key.

Voilà!

Is it in there?

+---------+-----------+------------------+------------+----------+| field01 | field02   | field03          | field04    | field05  |+---------+-----------+------------------+------------+----------+|       1 | first     | NULL             | NULL       | NULL     ||       2 | second    | another          | 1999-10-23 | 10:30:00 ||       3 | a third   | more foo for you | 1999-10-24 | 10:30:01 |+---------+-----------+------------------+------------+----------+

It's in there!

Now, we're almost done...

Updating Existing Records

Modify one field at a time

Again, be careful with syntax. Quote marks need to go around text but not around numbers.

Query OK, 1 row affected (0.00 sec)

Change multiple fields at once

Remember to put commas between each field you're updating.

Query OK, 1 row affected (0.00 sec)

So, what's up with our data?

+---------+-----------+------------------+------------+----------+| field01 | field02   | field03          | field04    | field05  |+---------+-----------+------------------+------------+----------+|       1 | first     | new info         | 1999-10-22 | 06:22:18 ||       2 | second    | another          | 1999-10-23 | 10:30:00 ||       3 | third one | more foo for you | 1999-10-24 | 10:30:01 |+---------+-----------+------------------+------------+----------+

Update multiple records in one stroke

Query OK, 3 rows affected (0.00 sec)

Survey says...

+---------+-----------+------------------+------------+----------+| field01 | field02   | field03          | field04    | field05  |+---------+-----------+------------------+------------+----------+|       1 | first     | new info         | 1999-10-22 | 15:29:01 ||       2 | second    | another          | 1999-10-23 | 15:29:01 ||       3 | third one | more foo for you | 1999-10-24 | 15:29:01 |+---------+-----------+------------------+------------+----------+

Wee haw!

Deleting Records

The delete command

Query OK, 1 row affected (0.01 sec)

+---------+---------+----------+------------+----------+| field01 | field02 | field03  | field04    | field05  |+---------+---------+----------+------------+----------+|       1 | first   | new info | 1999-10-22 | 15:29:01 ||       2 | second  | another  | 1999-10-23 | 15:29:01 |+---------+---------+----------+------------+----------+

Time to Call it Quits

Bye

In Closing

Now you know some rudimentary commands for running a database in MySQL. Since MySQL is operated by executing SQL calls, you have a broad array of very powerful tools at your disposal. For instance, you're able to display data from several tables at once by joining related fields.

Similarly, SQL permits complex displays, updates or deletions of multiple records which fit specific criteria. So, your next step toward mastery is learning all about SQL.

James Hoffman has put a tutorial page up on the web entitled Introduction to Structured Query Language.

Another thing to note is MySQL offers good security features you'll need to use when operating on networks.

To learn more about MySQL and how to use it, the manual should be your first stop. Also, Paul DuBois' book, MySQL, comes highly recommended. In addition, the archives of the main list and the Win32 list are tremendous resources. The NYPHP user group has started a MySQL interest group you may find helpful.

If you're curious about database portability, you may find the Building Truly Portable Database Applications in PHP presentation interesting.

If you'll be developing hypertext interfaces to your databases using PHP, check out our SQL Solution™. It's a powerful, user friendly, platform independent API that will make your job a snap! Similarly, you might want to examine PEAR DB, a popular open source database abstraction layer (of which I'm the lead developer).

Also, if your scripts accept user input, the Form Solution™ is a handy tool for cleaning user input, generating HTML / XHTML compliant date/time form elements, validating and formatting date/time inputs and holding all variables submitted by a form. The result is improved security and data quality.

Top 10 Windows Mobile Applications

Top 10 Cell Phones

Need a break from your laptop? These productivity phones offer a lot more than the ability to make calls. Here are the 10 best smartphones available today.

Edited by Ginny Mies, PC World

	1. Motorola Droid Keyboard: Yes Bottom Line: The first Android 2.0 phone impresses with a strong suite of Web features and a stunning 3.7-inch display, but some users might have trouble with the shallow keyboard.
	2. Apple 32GB iPhone 3GS Keyboard: No Bottom Line: Performance enhancements distinguish the otherwise evolutionary step-up iPhone 3GS from its previous iterations.	$799.00 - $878.87 Check Prices
	3. Google Nexus One Keyboard: No Bottom Line: The Google Nexus One impresses with a stunning AMOLED display, speedy performance, and cool tweaks to the Android OS; but some network issues prevent it from being a superphone.
	4. Motorola Cliq Keyboard: Yes Bottom Line: The beautifully designed Motorola Cliq is a social butterfly's dream phone, but others may find the MotoBlur user interface overwhelming.
	5. Research in Motion BlackBerry Bold 9700 Keyboard: Yes Bottom Line: The best BlackBerry available, the Bold 9700 packs a multitude of features into a sophisticated, slimmed-down design.	$0.01 Check Prices
	6. T-Mobile myTouch 3G Keyboard: No Bottom Line: The T-Mobile myTouch 3G is a big improvement from its predecessor, but the physical keyboard is sorely missed.
	7. Palm Pre Plus Keyboard: Yes Bottom Line: With expanded memory and new software capabilities, the Pre Plus is definitely an improvement over its predecessor, but it still has some quirks.
	8. Palm Pre Form Factor: Candy bar Bottom Line: The Pre's webOS software is touch-friendly and fun, but the cramped QWERTY keyboard detracts from the phone's usability.
	9. Samsung Behold II Keyboard: Yes Bottom Line: With a gorgeous AMOLED display and an excellent camera, the pricey Samsung Behold II will appeal to multimedia junkies with deep pockets.
	10. Research in Motion BlackBerry Tour 9630 Keyboard: Yes Bottom Line: The BlackBerry Tour entices with an ergonomic keyboard and gorgeous display, but the omission of Wi-Fi disappoints.

Introduction

1. Top Audio Freeware For Windows Mobile 6.0 And 6.1

2. Best Video Player For WIndows Mobile Devices

3. Best Internet Browsing Application For Windows Mobile 6.0 and 6.1

4. Best PC To Device Sync Option

5. Best Data Management Tool - MoDaCo NoData

6. Best Google Offering For Windows Mobile Operating Systems- Google Maps

7. Best Windows Mobile Search Program - Windows Mobile Live Search

Read more: http://www.brighthub.com/mobile/windows-mobile-platform/articles/6075.aspx#ixzz0i8TM2VTz

8. Best "EASY ACCESS" Contacts Management Application - iContact v0.76

9. Best Instant Messaging Application For Windows Mobile

10. Best Email Application. That Isn't Exchange Server Based

Conclusion

출처 : http://www.brighthub.com/mobile/windows-mobile-platform/articles/6075.aspx

25 Comments »

1. 

   I would not recommend to set datadir to the installation directory/data on Vista or later.
   The file permissions/integrity settings are such that resulting program needs elevation to run properly, even for Administrators (http://bugs.mysql.com/bug.php?id=38373)

   It is safer to copy the datadir somewhere else.

   Comment by wlad — May 19, 2009 @ 11:17 pm | Reply

2. 

   Hi,
   Thanks for putting this together.
   I followed your instructions (I am using VS 2008 C++ full version though). And I get the following run-time error in the console at:
   retval = mysql_library_init(num_elements, server_options, (char **) server_groups);

   “The thread ‘Win32 Thread’ (0×1ba0) has exited with code 1 (0×1).
   The thread ‘Win32 Thread’ (0×90c) has exited with code 1 (0×1).
   The thread ‘Win32 Thread’ (0×264c) has exited with code 1 (0×1).
   The thread ‘Win32 Thread’ (0×25c4) has exited with code 1 (0×1).
   The program ‘[6200] mysql_embedded.exe: Native’ has exited with code 1 (0×1).”

   (My app is called mysql_embedded.exe)

   Do you know why this is happening? Thanks.

   Comment by gmk — June 4, 2009 @ 3:41 am | Reply

3. 

   Is it possible that your data directory is not specified correctly? If I change my datadir path to an invalid path, I get similar errors. Perhaps you can post the following for your project along w/ what you have in that directory:

   static char *server_options[] = { “mysql_test”, “–datadir=C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/data”, “–language=C:/Program Files/MySQL/MySQL Server 5.1/share/english”, NULL };

   I don’t think it’s getting this far, but you might also check for the error log in your data directory to see if there is any info.

   Comment by Lee Stigile — June 4, 2009 @ 3:43 pm | Reply

4. 

   Hi gmk,

   I had the same problem before, and I am using VS 2003 full version. Everything worked after I used “–data” and “–language” instead of “-data” and “-language”. Hope that helps.

   Thanks Lee for a much needed and helpful article! =)

   Kind regards,
   IT

   Comment by IT — June 15, 2009 @ 4:14 am | Reply

5. 

   Sorry, it appears that the double ‘-’ are turned into single dashes…

   Comment by IT — June 15, 2009 @ 4:18 am | Reply

6. 

   Hi Lee and IT,
   Thanks for your feedback but it still does not work. A couple of things:

   1. I have copied the data directory and language to a simpler folder structure (c:\mysql_embedded), but still no luck.
   2. I am using Vista.
   3. your “mysql_test” argument in your server_options array, is that supposed to be a sub directory in the data directory? mine is just called “mysql”.
   4. tried that double dash, but nothing.
   5. there is no err file being generated in the data directory.

   thanks for your help.

   Comment by gmk — June 15, 2009 @ 4:57 am | Reply

7. 

   Regarding #3, the first argument in the server_options array is ignored (http://dev.mysql.com/doc/refman/5.1/en/mysql-library-init.html).

   Perhaps there’s a version mismatch between libmysqld.dll, libmysqld.lib and errmsg.sys? You might search your system for these files and update with the latest 5.1 versions.

   Also, feel free to send the project files directly to me, I’d be glad to run on a couple systems here.

   Comment by Lee Stigile — June 15, 2009 @ 3:35 pm | Reply

8. 

   Hi,
   Thaks for your tutorial,can you give an idea about how to relate with Visual c++ 2005 and mysql.

   Comment by TT — July 13, 2009 @ 9:02 am | Reply

9. 

   Hi,

   Thank you for such a useful post.

   Comment by Saif — August 19, 2009 @ 12:52 pm | Reply

10. 

    Hi,
    That’s a nice tutorial, but since I am completely new in mysql and I am dealing with VC++ from relatively soon, I am encountering errors I don’t have a clue of.
    As I am executing this sample program in debug mode I get some weird “first chance” exception and execution stops at line:
    mysql_real_connect(mysql, NULL,”root”, NULL, “mysql”, 0, NULL, 0);

    I’ve tried putting the password for the root account in the place of the second NULL with no success.
    This is what is residing in the Output tab:

    ’sample.exe’: Loaded ‘C:\Documents and Settings\Pavlin\My Documents\Visual Studio 2008\Projects\sample\Release\sample.exe’, Symbols loaded.
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\ntdll.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\kernel32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\libmysqld.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\wsock32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\ws2_32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\advapi32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\rpcrt4.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\secur32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\msvcrt.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\ws2help.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\user32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\gdi32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.1_x-ww_6f74963e\msvcr90.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\imm32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\mswsock.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\dnsapi.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\winrnr.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\wldap32.dll’
    ’sample.exe’: Loaded ‘C:\WINDOWS\system32\rasadhlp.dll’
    First-chance exception at 0×10018bc1 in sample.exe: 0xC0000005: Access violation writing location 0×0000035c.
    Unhandled exception at 0×10018bc1 in sample.exe: 0xC0000005: Access violation writing location 0×0000035c.
    The program ‘[2484] sample.exe: Native’ has exited with code 0 (0×0).

    Do you have an idea what could be wrong?

    Comment by Pavlin — August 24, 2009 @ 1:25 pm | Reply

11. 

    Is there anything in the error log ( *.err file in the data directory) ? Is there any chance that the port is already in use?

    Comment by Lee Stigile — August 24, 2009 @ 9:03 pm | Reply

12. 

    On every program run the .err file gets:
    “InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    090825 10:21:26 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files…
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer…”
    at the end. And it is located exactly at “C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/data/”
    And after few tests and running step by step, I noticed, that it actually throws the exception right after executing:
    mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
    and then the green arrow points to the next line.

    If I understand right, the port is set – 0.
    mysql_real_connect(mysql, NULL,”root”, NULL, “mysql”, 0, NULL, 0)
    So I don’t know what the chance is that it is used. But I am not sure if it matters, if it breaks before executing that line.

    Comment by Pavlin — August 25, 2009 @ 7:28 am | Reply

13. 

    Sorry I bothered you. There was mistake in MY code causing mysql to be NULL at execution of mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
    Thats what the problem was. Sorry one more time and thanks for the nice howto.

    Comment by Pavlin — August 25, 2009 @ 7:43 am | Reply

14. 

    Yes, using libmysqld.dll is easy and convinient.

    But do you know that you do NOT have a right to redistribute libmysqld.dll with your app unless you either:
    1. open your app source code to the whole world (GPL license)
    or
    2. buy commercial license from MySQL (now SUN) – it is not clear how much it costs
    Does anybody wants to comment this?

    Comment by careful_guy — August 26, 2009 @ 5:30 am | Reply

15. 

    First, thanks for this set of instructions.

    If you copy the code into Visual Studio, you’ll run into problems:

    1. All the double quote marks have to be replaced with ordinary quote marks.
    2. The minus sign in the following line of code became a dash, confusing the compiler, which gave a bogus error, confusing two programmers. It needs to be replaced:

    int num_elements = sizeof(server_options)/ sizeof(char *) – 1;

    Comment by Steve Miller — August 27, 2009 @ 5:25 pm | Reply

16. 

    Cool site, love the info.

    Comment by Bill Bartmann — September 3, 2009 @ 9:55 pm | Reply

17. 

    why can’t I use an InnoDB database? with libmysqld can you only read MyISAM tables? (like all tables mysql are)

    Comment by EvIl_DeViL — September 8, 2009 @ 1:58 pm | Reply

    • 

      Hello — You should be able to access the innodb database. You might want to check your error log for specific error information.

      Comment by Lee Stigile — September 8, 2009 @ 7:24 pm | Reply

      • 

        with the same code i can access to MyISAM tables… if I change the table type to Inno I can’t access them. here’s my InnoDB log… I copied it from Data directory and pasted to my project dir.

        ————————————InnoDB LogFile————————————
        090909 1:08:58 [Note] Plugin ‘FEDERATED’ is disabled.
        090909 1:08:58 InnoDB: Started; log sequence number 0 172027
        090909 1:08:58 [Note] Event Scheduler: Loaded 0 events
        090909 1:08:58 [Note] C:\Programmi\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
        Version: ‘5.1.36-community’ socket: ” port: 3306 MySQL Community Server (GPL)
        InnoDB: Error: log file d:\Program\Program\database\ib_logfile0 is of different size 0 25165824 bytes
        InnoDB: than specified in the .cnf file 0 5242880 bytes!
        ————————————InnoDB LogFile————————————

        the error is 1286: unknow table engine ‘InnoDB’
        i didn’t use skip-innodb and in “my.ini” is commented. (i don’t think my.ini influence that because it’s an embedded version but my db was created with navicat so… (and with MyISAM works!))

        Comment by EvIl_DeViL — September 8, 2009 @ 11:39 pm

      • 

        I recommend removing (renaming or deleting) the ib_logfile0 and ib_logfile1 (if exists) and try the app again. There may have been an old file from a previous install or a full server install. If the log files don’t match your config, it won’t start.

        Comment by Lee Stigile — September 9, 2009 @ 2:29 am

      • 

        wow! you’re right!!! I deleted the two log files and it worked!!! many many many thanks!!!

        Comment by EvIl_DeViL — September 9, 2009 @ 8:00 am

18. 

    hi, i tried it out, and i’m getting an error on statement
    “mysql = mysql_init(NULL);”. Can someone help ?

    Comment by Hitesh — October 4, 2009 @ 6:07 pm | Reply

19. 

    also the return value in the statement
    “retval = mysql_library_init(num_elements, server_options, (char **) server_groups);” is 1. why is that so ?

    Comment by Hitesh — October 4, 2009 @ 6:25 pm | Reply

    • 

      Hi — please take a look at comment #4 above from IT. He had similar errors and noted that –data and –language need two dashes, instead of one. Could this be the case for you?

      Comment by Lee Stigile — October 5, 2009 @ 8:47 pm | Reply

20. 

    I have the same problem and I have verified it is double dash (e.g. –datadir=…).
    Still mysql_library_init returns 1.
    I use VC++ express and Mysql 5.1 and libmysqld as it comes with install package.
    err file is created in the project_dir/data regardless of datadir parameter. I think this is because something is wrong in the parameters and init does not do its job.
    The code is really minimal, see below.
    Pls someone upload a working example including solution file and libmysqld.dll so I can try it and see the dif.
    Thanks a lot!

    // ———————— Code ————————
    #include “stdafx.h”
    #include
    #include
    #include
    #include
    #include
    #include

    MYSQL *mysql;
    MYSQL_RES *results;
    MYSQL_ROW record;

    static char *server_options[] = {“mysql_test”,
    “-–datadir=./data”,
    “-–language=C:/Program Files/MySQL/MySQL Server 5.1/share/english”,
    NULL
    };
    int num_elements = (sizeof(server_options)/ sizeof(char *)) – 1;
    static char *server_groups[] = { “libmysqld_server”, NULL };

    void test()
    {
    int retval;
    retval = mysql_library_init(num_elements, server_options, (char **)server_groups);

    Comment by Din — November 21, 2009 @ 4:15 pm

---- 지나온 날짜 계산 ----

<script language="JavaScript">
<!--
var now = new Date();
var then = new Date("march 4,2005");
var gap = now.getTime() - then.getTime();
gap = Math.floor(gap / (1000 * 60 * 60 * 24));
d0cument.write("blog 시작한지 " + gap + "일");
// -->
</script>

--- 남은 날짜 (D-day) 계산 ---

<script language="JavaScript">
<!--
var now = new Date();
var then = new Date("december 25,2005"); // 크리스마스
var gap = then.getTime() - now.getTime();
gap = Math.floor(gap / (1000 * 60 * 60 * 24));
d0cument.write("크리스마스 : " + gap + " day left");
// -->
</script><br/>

PMBok 버전3에서 버전4로의 변화내용

1267272322_PMBOK_4th_Edition_Changes_To_3rd_Edition_082308.pdf

PMP 자격증 시험 관련 요약서

1267271949_PDC_PMPHandbook.pdf

2009년 정보시스템감리사 기출문제

1267267422_2009감리사시험문제(공지).hwp

정보화시대가 진전되면서 정보시스템은 기업이나 기관의 가장 중요한 자산이 되어가고 있다. 기업의 영업 비밀, 인사 기록, 고객 자료 등 각종 중요 정보가 모두 정보시스템 안에 저장되어 있다. 이런 정보시스템은 매우 편리하지만 보안에 취약성이 있기 때문에 사고가 발생할 경우 큰 손실을 가져온다. 이런 손실을 막기 위해서 정보시스템감리가 필요하다. 실제 정보시스템 구축과 운용에서 만나는 많은 위험 요인을 통제하고 시스템에 맞는 설정과 운영에 대한 적절한 방법론을 확립해야 하며, 이를 적용하는 정보시스템 감리 요원이 필요한 것이다.

정보시스템감리는 정보화 추진 방향을 설정하는 기본 설계부터, 정보시스템개발 및 운영상의 효율성, 자료의 신뢰성 및 안전성 등을 종합적으로 검토해 정보시스템 구축과 운영에서 나타날 수 있는 문제점을 사전에 예방하는 작업이다. 정보화시대를 맞이하여 정보자산의 가치가 기업과 기관에서 차지하는 중요성이 커지면서 정보시스템감리의 필요성도 함께 커지고 있다.

정보시스템감리사는 한국전산원이나 민간 감리법인에서 근무한다. 민간 감리법인은 감리 전문 법인으로 존재하기도 하지만 SI업체나 컨설팅 업체에서 감리 업무를 수행하는 경우도 많다. 꽤 많은 감리사들이 SI 업체나 컨설팅 업체의 직원으로 일하면서 컨설팅과 감리 업무를 수행한다.
일반적으로 국내 정보시스템에 대한 주요 공공 프로젝트에 대해서는 한국전산원에서 국가정보화 감리업무를 수행하고 있다. 기업의 경우에는 최근 정보시스템의 감리를 전문적으로 수행하는 민간법인들이 활동을 하고 있다. 2002년에는 20~30개 사이의 감리법인이 활동했으나 이 수는 점차 증가하고 있다.

특히 국가 정보화사업의 원활한 수행과 부실방지를 위해 일정 규모 이상의 주요 공급 프로젝트에 대한 감리실시가 의무화되면서 정보시스템의 감리 시장은 큰 폭으로 성장하고 있다. 따라서 앞으로 정보시스템감리사의 수요는 계속 증가할 전망이다.

감리 업무는 정보시스템의 기획 개발 운영 및 유지 보수 단계 별로 구분하여 수행한다. 정보시스템감리사는 정보시스템 감리 요청이 들어오면 관련 자료를 제출받아 감리를 실시하고 감리보고서를 작성하여 감리 의뢰인에게 통보한다. 이 과정에서 시스템의 분석, 설계, 개발이 제대로 이루어지고 있는지, 시스템의 설계 원칙과 사양에 준거하여 정보시스템이 구축 이행되는지, 정보 자산을 보호하기 위한 요건을 충족하는지를 평가 확인한다. 물론 이 과정에서 미비한 부분은 지속적으로 수정해 시스템의 완전성을 높여나가도록 유도한다.

정보시스템감리사는 40대, 50대 활동 비중이 더욱 많으며 최고의 보수를 받는 직종이다.

정보시스템감리사 관련자격증으로는 한국산업인력공단에서 시행하는 정보관리기술사, 정보처리기사, 정보처리산업기사, 전자계산조직응용기술사, 전자계산기조직응용기사, 전자계산기조직응용산업기사, 정보기술산업기사 등이 있다. 그러나 이 자격증은 기초적인 자격증으로 이 자격증을 취득한다고 해서 정보시스템감리사가 되는 것은 아니다.

해외에서 발행하는 국제자격증으로는 정보시스템감사통제협회(ISACA :Information Systems Audit and Control Association)에서 시행하는 국제공인정보시스템감사사(CISA :Certified Information Systems Auditor) 자격증이 있다. 이 자격증은 세계적으로 널리 인정되는 자격증으로 희소성이 높지만 취득하기 매우 어려운 자격증이다. CISA를 취득한 사람은 국내에서도 소수에 불과해 개인의 능력 향상에 큰 도움이 되며, CISA를 취득한다면 고액 연봉을 받는 정보시스템감리사로 활동할 수 있다.

그외 한국전산원에서 수여하는 국가공인 정보시스템감리사 자격증이 있는데 아무나 취득할 수 있는 것이 아니다. 정보통신 분야에서 일정 수준 이상의 자격을 갖춘 지원자를 선발하여 교육을 실시한 후에, 정보시스템 감리 관련 전문가로 구성된 정보시스템감리사 평가위원회의 심사를 거쳐 수여한다. 따라서 현장에서 꽤 오랜 기간 근무한 사람이 취득할 수 있는 자격증이다.

정보시스템감리사는 정보 시스템의 모든 것을 감리해야 하므로 상당한 수준의 기술력이 필요하다. 시스템 분석, 설계, 개발, 운영, 보수, 유지에 필요한 모든 지식을 갖추어야만 감리가 가능하기 때문이다. 이 때문에 정보시스템의 감리 활동을 할 수 있으려면 특급 기술자 수준 이상이 되어야 한다.

감리사로 활동하기 배워야 할 내용은 다양하다. 정보시스템의 감사업무 프로세스, 정보시스템의 관리, 계획, 조직, 기술 하부구조, 운영실무, 정보자산의 보호, 재해복구, 응용시스템 개발, 구입, 구현, 유지 보수, 업무 프로세스평가, 위험관리, 프로젝트 관리, 감리보고서 작성법 등을 배우는데 시스템에 대한 전반적인 내용을 배운다고 보면 된다.

요구하는 능력이 크고 매우 중요하고 전문적인 일인 관계로 다른 IT 직종에 비해 보수는 매우 높다. 종사자 평균이 월 345만원으로 IT 직종에서는 매우 높은 보수를 받고 있는 직종이다. 더구나 감리 의무화로 일감은 증가하는 반면 인력은 부족해 정보시스템감리사의 보수는 계속 상승하고 있다.

정보시스템감리사는 고졸 이하가 0%, 전문대졸 이하가 2%로 저학력층이 거의 없는 반면 대학원졸 이상이 34%나 되는 고학력 직종이다. 전공은 컴퓨터/통신이 41%, 경영/경제가 29%를 차지한다. 기본적으로 정보시스템감리사로 활동하기 위해서는 4년제 이상의 대학에서 전산계통관련 전공을 하거나, 관련 자격을 취득하는 것이 기본이다. 하지만 무엇보다 현장에서의 다양한 실무경험이 뒷받침되어야 한다. 다양한 현장 경험이 없다면 감리 활동을 수행하기 어렵다.

다양한 현장경험이 필요하다는 것을 증명하는 것은 연령층 비율이다. 일반적으로 지금까지 소개한 대부분의 IT 직종은 20대와 30대 비율이 거의 100%에 달하고 40대 이상은 거의 없는 반면 정보시스템 감리 직종은 거꾸로 40대 비율이 36%로 가장 높고, 50세 이상 고연령자도 31%나 된다. 반면 20대는 10%에 불과하고 30대도 23%에 불과하다. 즉 정보시스템감리사는 많은 경험이 필요한 분야라는 뜻이다. 이 때문에 개발자, 프로그래머, IT컨설턴트 등의 다양한 직종으로 취업했던 IT 종사자의 상당수가 정보시스템감리사를 목표로 경력을 쌓고 있다.

현재 정보시스템감리사로 종사하는 사람이 대부분은 남자다. 이는 정보시스템감리사라는 직종이 비교적 최근에 개척된 직종인 반면 감리사가 되기 위해서는 오랜 경력이 필요한 분야이기 때문이다. 웹디자인이나 프로그래머처럼 학원에서 몇 달 배우면 취업할 수 있는 분야가 아니라 현업에서 10년 이상 개발자나 엔지니어로 근무했던 사람이 감리사로 전환하는 경우가 많기 때문에 여성 인력의 진출이 거의 없는 것이다. 하지만 정보시스템감리사의 업무는 여성에게도 적합하다. 고학력 여성들이 진출하기에 적합한 분야이므로 현재 현업에서 활동하는 IT 종사자라면 정보시스템감리사라는 직종에 목표를 두고 개인 능력을 개발하는 것이 좋다.