/SQL/Sql make sure every user is unqiuew

Sql make sure every user is unqiuew

create table user(
    user_id  INT  auto_increment  PRIMARY KEY,
    username varchar(50) not null,
    avator  varchar(50),
    gender  boolean not null,
    phone varchar(20),
    unique(username)
);

create table journey(
    id INT auto_increment PRIMARY KEY,
    start varchar(100) not null,
    dest varchar(100) not null,
    time date not null,
    person INT,
    user_id INT not null,
    foreign key(user_id) references user(user_id)
);

Source: stackoverflow.com

Similar codes

8 votes341 views1 answer
Database backup in mysql server recovery
SQL
0 vote367 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote371 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
5 votes362 views1 answer
Minecraft java port number
SQL
18 votes362 views6 answers
Laravel form validation
SQL
5 votes376 views4 answers
Restart the psql server windows
SQL
2 votes342 views1 answer
Sql server find table name
SQL
14 votes406 views6 answers
Finding duplicate rows mysql
SQL
1 vote303 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
12 votes334 views2 answers
Delete all data in neo4j
SQL