Use the data type BOOL which takes a 1 or 0 character or use CHAR and then
you can use Y or N for Yes/No.
Regards,
'Gbamila
- Original Message -
From: "Tony Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 12:26 PM
Subject: True/False
> I am new to MyS
No big deal. You can install MySQL in any directory or drive.
You just have to set path of your installation in the mySQL conf file.
Under MySQL Server Section -- Location, you point the directory to where the
Db is installed.
e.g.
# location
basedir = D:\database\mys
Check out how to get around subselect queries in the manual. But incase
your query is a little complex and cannot be solved as explained in the
manual, use temporary table(s).
When I had this problem I went round it using MySQL Temporary tables.
So in your case, you can do something like:
>CREAT
I did the following to resolve the problem.
1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128). I suppose this was a typo since you already had a
working table.
2. Your main problem comes from the format of your input. Use /N for
ommited column
You need to Install MySQL as a service.
Use the following steps on the DOS command prompt:
1. cd \your-path-to-mysql\bin
2. >mysqld-max-nt --install
You could then start the service from Services in Control panel or use "NET
START mysql" on the command line.
Regards
'Gbamila
- Original
