/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 vote249 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote223 views1 answer
Select inside insert query
SQL
0 vote220 views1 answer
Renommer table sql
SQL
0 vote248 views1 answer
Postgresql create table many-to-many
SQL
0 vote221 views1 answer
Phpmyadmin mysql conflict
SQL
14 votes274 views5 answers
Set password for postgres user ubuntu
SQL
1 vote226 views1 answer
What is intersect
SQL
0 vote231 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote221 views1 answer
In mysql workbench contnent not feching
SQL
1 vote246 views1 answer
Spark sql convert string to date
SQL