/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 vote191 views2 answers
Sql server backup table
SQL
3 votes162 views3 answers
Docker create postgresql database
SQL
1 vote179 views1 answer
Find a column in all tables postgres
SQL
0 vote194 views1 answer
Mysql where sum > 0
SQL
11 votes196 views5 answers
Laravel db facade
SQL
0 vote203 views1 answer
Create table like sql
SQL
10 votes194 views2 answers
Mysql remove only_full_group_by permanently
SQL
10 votes180 views4 answers
Fetch first 5 characters of the string in sql
SQL
4 votes177 views4 answers
Date less than in sql
SQL
25 votes187 views6 answers
How to change column name in mysql
SQL