/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 vote353 views1 answer
Openquery insert into linked server
SQL
0 vote332 views1 answer
Mysql find db contarint
SQL
3 votes367 views1 answer
Sql print all names that start with a given letter
SQL
1 vote339 views1 answer
Describe table in sql
SQL
0 vote315 views1 answer
Clone table structure mysql
SQL
0 vote384 views1 answer
Stratified sampling sql
SQL
0 vote330 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote355 views3 answers
Remove folders from remote git
SQL
13 votes335 views5 answers
Sql default
SQL
1 vote345 views1 answer
SQL Integer devision
SQL