Yes/No in the table

[esm]

I have several Yes/No fields ( they are truely Yes/No with No being the defaul value ).

What is the correct way to code the value in the table. Yes/No or 1/0?

[dody]

There's no boolean (0 and 1) type in mysql. You can use char(1) type to handle it. It will allow you to write single character in that field.

What is the correct way to code the value in the table. Yes/No or 1/0?

Do you to insert into table?

say you have table structure like this:
table name config
name varchar(50)
value char(1)

Then your query to insert:

INSERT INTO data (name, value) VALUES ('visible',0)