/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

0 vote195 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote237 views1 answer
Copy row from db to db mysql
SQL
0 vote176 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote202 views1 answer
Mysql root localhost run
SQL
1 vote215 views1 answer
Oracle plan hash value
SQL
0 vote252 views3 answers
Select top 10 rows in sql
SQL
1 vote220 views1 answer
Round one decimal place mysql
SQL
13 votes199 views2 answers
Sql join 3 tables
SQL
0 vote179 views1 answer
Date datatype in livesql
SQL
0 vote132 views1 answer
Sql query with date
SQL