/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

0 vote137 views1 answer
Mysql date + 1 day
SQL
1 vote178 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote132 views1 answer
Postgres delete where id in
SQL
11 votes255 views5 answers
Update table from another table mysql
SQL
0 vote172 views1 answer
Drop column from local database postgres pgadmin
SQL
2 votes216 views1 answer
Select a certain number of entries from select mysql
SQL
3 votes163 views1 answer
Créer une table sql
SQL
4 votes168 views2 answers
How to count items with same name in sql
SQL
0 vote156 views1 answer
Java spring boot connect to sql server
SQL
0 vote164 views1 answer
Opensuse status MySQL
SQL