/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 vote142 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
25 votes203 views4 answers
Metadata
SQL
2 votes213 views2 answers
Sql query to list all tables in a database sql server
SQL
11 votes206 views1 answer
Ddl view
SQL
0 vote196 views1 answer
How to get nth number in sql
SQL
0 vote201 views1 answer
Insert value in identity
SQL
1 vote188 views1 answer
Oracle nvl2
SQL
0 vote187 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote172 views1 answer
Oracle current timestamp
SQL
0 vote132 views1 answer
How to get last client id sql
SQL