Jess,
You should use an AND () instead of the OR. You result is everything,
correct? When the query is doing the machinename != 'FIND_ME', the
record(s) with machinename = 'OPEN' are being returned. Likewise, when the
machinename != 'OPEN' is being performed, the records(s) with machinename =
Sorry Robert, didn't mean to send to only you.
We're developing a management program that can manage several jobs that a
construction company is working on. We have a separate database for each
job that is installed in the program. This eliminates the need to keep an
extra field in each table
Sharma and Terry,
I believe MySQL only supplies setup.exe files with the versions that have
production status. However, if you download the appropriate .zip file from
the website, then that will contain all the files that you need. Simply
extract it to the default location (C:\mysql in Windows
Hi,
I think what you need is an auto increment (primary key) column. When a
record is inserted, it will automatically generate the next number in the
sequence. Being a primary key, the column must be unique (i.e no two rows
can be the same), so you can identify a specify record in the table.