R
R
Roma7892022-04-15 21:54:21
MySQL
Roma789, 2022-04-15 21:54:21

Help creating a table?

Hello, I need to create a table:
full name
e-mail
phone (only Russian mobile numbers)
date of birth
age,
date and time of creation of the entry
passport number,
average place in the competition
biography
video presentation

I don’t understand how to make the condition only Russian numbers and what type of data for the video presentation

create table sportsman(
    id INT PRIMARY KEY AUTO_INCREMENT,
    FNP VARCHAR(255),
    email VARCHAR(255),
    phone_number VARCHAR(11),
    birthday date,
    age int(3),
    creating datetime,
    passport_number int(15),   
    middle_place int(11),
    biografhy VARCHAR(255),
    video 
)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander, 2022-04-15
@teranq

Is the question not entirely clear? Column names cannot be written in Russian in mysql

S
Slava Rozhnev, 2022-04-16
@rozhnev

CREATE TABLE sportsmans(
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    full_name VARCHAR(255),
    email VARCHAR(255),
    phone_number VARCHAR(11),
    birthday date,
    passport_number int(15),   
    average_rate int(11),
    biography text,
    video VARCHAR(255),
    created_at datetime
);

Online SQL

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question