mysql - Creating SQL Table with Binary and Integer values

Question

I would like to create a table in SQL and wanted to confirm if I am creating the values properly. I need to create an integer column and a binary column. The Binary column will only have 0 for False and 1 for True. Here is my MS SQL code:

CREATE TABLE ENTRY(
`number` INT NOT NULL,
`bin_variable` BINARY NOT NULL);
INSERT INTO ENTRY (number, bin_variable)
VALUES 
(5, 0),
(10, 1);

question from:https://stackoverflow.com/questions/65600062/creating-sql-table-with-binary-and-integer-values

Answer 1

Yes, your query is correct. The table will have 2 rows with values (5,0) and (10,1)