Hi all,

I am pretty new to MYSQL I am creating a table and have got a few question.

1)How do I set a boolean Value True/False is it case of

DelPresenter bool not null,

2)This is the code for my first table (below) my question is the engine = innodb do I have to have this line for every table I make ??

create table delegate
(DelNo int not null,
DelName varchar() not null,
DelAddress varchar() not null,
DelTelphone varchar(),
DelPresenter bool,
primary key (DelNo))
engine = innodb;

many thanks