Професионална програма
Loading...
mariazlatevatodorova avatar mariazlatevatodorova 0 Точки

Проблем с решаването на задача 8 от Упражнение 15.01.2019 - Колона Пол

Молба за помощ - проблем със създаване на колона пол - М - Ж

От презентацията не се разбира как точно се изпълнява, а по време на упражнението не остана време :)

 

Problem 8.Create Table People

Using SQL query create table People with columns:

  • Id – unique number for every person there will be no more than 231-1 people. (Auto incremented)

  • Name – full name of the person will be no more than 200 Unicode characters. (Not null)

  • Picture – image with size up to 2 MB. (Allow nulls)

  • Height – In meters. Real number precise up to 2 digits after floating point. (Allow nulls)

  • Weight – In kilograms. Real number precise up to 2 digits after floating point. (Allow nulls)

  • Gender – Possible states are m or f. (Not null)

  • Birthdate – (Not null)

  • Biography – detailed biography of the person it can contain max allowed Unicode characters. (Allow nulls)

    Make Id primary key. Populate the table with only 5 records.

CREATE TABLE People (

Id INT PRIMARY KEY IDENTITY,

Name NVARCHAR (200) NOT NULL,

Picture VARBINARY(MAX),

Height DECIMAL (3,2),

Weight DECIMAL (5,2),

Geneder -

Birthdate DATE NOT NULL,

Biography NVARCHAR (MAX)

 

Благодаря!

 

  

 

Тагове:
0
Database Basics – MySQL
Ordnata avatar Ordnata 7 Точки

CREATE TABLE `people`(
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
    `name` VARCHAR(200) NOT NULL, 
    `picture` VARBINARY(2000) NULL,  
    `height` DECIMAL(2) NULL,  
    `weight` DECIMAL(2) NULL, 
    `gender` VARCHAR(1) CHECK (`gender` IN ('f','m')) NOT NULL,  
    `birthdate` DATE NOT NULL,  
    `biography` LONGTEXT NULL
);

0