/SQL/Create table in mysql mariadb primary key foreign key

Create table in mysql mariadb primary key foreign key

CREATE TABLE IF NOT EXISTS `scores` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  UserId int(11) NOT NULL,
  `NICKNAME` varchar(50) NOT NULL,
  `HIGHSCORE` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  FOREIGN KEY (UserId) REFERENCES USER(Id)
);

Source: stackoverflow.com

Similar codes

1 vote126 views1 answer
Mysql select if empty result
SQL
0 vote276 views1 answer
Get first match in each group mysql query
SQL
0 vote123 views1 answer
Luu ckeditor vao mysql
SQL
0 vote129 views1 answer
H2 auto increment and unique
SQL
0 vote126 views1 answer
Select the date 30 days less that the todays date sql request
SQL
2 votes127 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
9 votes135 views4 answers
Mysql set id auto increment
SQL
1 vote80 views1 answer
Mysql collation
SQL
19 votes137 views6 answers
Mysql if null
SQL
0 vote118 views1 answer
Order by ip address sql
SQL