/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

3 votes222 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote218 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote218 views1 answer
Sql contains vs like
SQL
1 vote220 views2 answers
Insert sqlite
SQL
2 votes218 views2 answers
Select list is not in group by clause
SQL
0 vote209 views1 answer
Can we rollback deleted data in sql
SQL
0 vote221 views1 answer
Complete date is 1 year or not sql server
SQL
16 votes278 views2 answers
Sql vs nosql
SQL
3 votes237 views2 answers
Update Query in SQL Server
SQL
0 vote236 views2 answers
Check if sql temp table exists
SQL