Question

-- Create a table with the following columns, named bsg_spaceship
--
-- id - an auto-incrementing integer which is also the primary key
-- name - variable-length string with a max of 255 characters, cannot be null
-- separate_saucer_section - a boolean property which specifies whether or not there is a separate saucer section on the spaceship. This defaults to No.
-- length - integer, cannot be null
--
-- Once you have created the table, run the query "DESCRIBE bsg_spaceship;"

I don't know why my code is not working.

CREATE TABLE bsg_spaceship(

id INT NOT NULL AUTO_INCREMENT,

name VARCHAR (255) NOT NULL,

seperate_saucer_section Boolean DEFAULT 0,

length INT NOT NULL,

PRIMARY KEY (id),
);

DESC bsg_spaceship;

Answer 1

Answer:-

The below is the required code for the given problem

Code:-

bsg_spaceship:

CREATE TABLE `bsg_spaceship` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

'seperate_saucer_section' boolean NOT NULL DEFAULT 0,

'length' int NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

DESCRIBE bsg_spaceship;

If you find difficulty to understand the code, please let me know then I will provide another code or I will do any modification. Hope it will helps. Please give Thumbs Up!! Thank you for posting the question, All the best.