/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 vote226 views1 answer
Query to insert image
SQL
0 vote232 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote216 views1 answer
Mysql get first 2 characters of string
SQL
0 vote192 views1 answer
Set column width in sqlplus
SQL
1 vote220 views1 answer
Sql headers delphi
SQL
8 votes234 views1 answer
My sql version
SQL
0 vote207 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote199 views1 answer
Oracle call a function in a insert statement
SQL
19 votes326 views5 answers
Mysql between date range
SQL
1 vote213 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL