Interpreting Data
Posted by:
Jeff Kapral
Date: September 24, 2017 06:35AM
Hey Everyone, I'm new to this so this should be a pretty easy problem. I'm taking an online class using Codio and I'm told to create a TABLE within a DATABASE, with the following settings:
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+----------+-------+
| user_id | int(7) | NO | | NULL | |
| email_frequency | tinyint(2) unsigned | YES | | 15 | |
| layout | varchar(70) | YES | | vertical | |
| updated_at | datetime | YES | | NULL | |
+-----------------+---------------------+------+-----+----------+-------+
I use this code below and it says Query OK.
CREATE TABLE settings (
user_id INT(7) UNSIGNED NOT NULL auto_increment,
email_frequency TINYINT(2) DEFAULT 15,
layout VARCHAR(70) DEFAULT “vertical”,
updated_at DATETIME DEFAULT NULL,
PRIMARY KEY (user_id)
) AUTO_INCREMENT = 1
But the Codio unit won't let me pass through because of this error:
LAST RUN on 9/23/2017 12:07:42 PM
[Error]: Task 2. Expected: Create a 'settings' table in the 'App' database with the specified features. Try again.
Someone from my class said it could be my auto increment settings? But I don't what I should change it to.
Subject
Written By
Posted
Interpreting Data
September 24, 2017 06:35AM
September 24, 2017 11:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.