Using MS Query Tutorial

Use MS Query to Treat Excel As a Relational Data Source, Page 1

Transactions in MySQL

Here is a reference to MySQL support for transaction processing. In
multi-user working systems this is the way it should be done, to make
sure the DBMS can preserve the integrity of the data even if crashes
and transaction failures occur.
MySQL :: MySQL 5.0 Reference Manual :: 12.4 MySQL Transactional and Locking Statements
Note the START TRANSACTION and END [...]

xampplite on a Z: drive

It is possible to install xampplite on your Z: drive. This may be the preferred way to do it if you are a student, since you can then get in on any lab machine.  Hope this makes it easier to play along in class.
Simply unzip the distribution file for xampplite into Z:
Or copy your flashdrive [...]

Fixed links

I fixed the links to the sample database files here.
I also added example data for chapter 5. You can simply import the sql file after creating a database to hold it. Remember the database names have to be all one word, no dots or other special characters, except you can use _ for a [...]

Command Line and mysql (2)

Now that you know how to get to mysql thru the command line, (see this for details), what can you do when you get there?  A lot, anything that you can do at the phpmyadmin web interface.  Here are a few simple things.  What you type in is in bold, and what the computer says [...]

Command Line and mysql

Some notes about the command line processor and mysql.
First you need to know how to open a command line window.
On windows, click Start, Run, and select cmd from the dropdown list. A command line window should open on your screen.
You might want to create a shortcut on your desktop since we will use this [...]

xampp on lab machines

Greg Crum of IT prepared some instructions for setting up xampplite on a flash drive to run in our computer lab. At least one student has successfully implemented it!!
To do it you need to do the following:

Change the ‘ports’ used by your webserver apache for normal and secure serving of http. There is a [...]

A php tutorial

PHP: A simple tutorial – Manual

Hello, students!

This is the student blog for MGT335 Advanced Information Systems at Cal Maritime. Here students will log their experiences working with the software they use in the course, and register their successes and failures with notes.
See the pages in the tabs for information.