Answer the question
In order to leave comments, you need to log in
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
Is the question not entirely clear? Column names cannot be written in Russian in mysql
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
);
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question