/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

17 votes166 views2 answers
Mysql date to string
SQL
5 votes140 views1 answer
Mysql select greater than yesterday
SQL
0 vote144 views1 answer
Downgrading sql localdb visual studio
SQL
2 votes151 views2 answers
How to rename column name in sql server using query
SQL
0 vote143 views1 answer
18446744073709551615 mariadb left join order by
SQL
8 votes143 views3 answers
Alter user root mysql
SQL
0 vote173 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote156 views1 answer
Java check if something is in mysql table
SQL
0 vote157 views1 answer
Sql values not in another table
SQL
0 vote160 views1 answer
Datagrip execute procedure
SQL