/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

4 votes262 views1 answer
Sql data types
SQL
2 votes267 views1 answer
Sql count having
SQL
0 vote274 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote285 views1 answer
Drop column if exists sql server
SQL
3 votes276 views2 answers
How to modify rows in SQL Server
SQL
0 vote299 views1 answer
Show specific events on mysql
SQL
0 vote306 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote281 views1 answer
Mysql grouping functions
SQL
0 vote284 views1 answer
Enable sql server full text indexing
SQL
0 vote294 views1 answer
Sql injection payload list github
SQL