/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

2 votes239 views3 answers
Row number mssql
SQL
2 votes171 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
2 votes192 views1 answer
Q operator in oracle
SQL
49 votes314 views6 answers
Install mysql ubuntu
SQL
1 vote219 views1 answer
Sql string function update replace
SQL
8 votes176 views3 answers
Postgresql connection string c#
SQL
3 votes189 views3 answers
Raw select laravel
SQL
0 vote177 views1 answer
How to search query in python3 sqlite3
SQL
0 vote187 views1 answer
Postgresql heritage
SQL
8 votes187 views2 answers
Alert table name mysql
SQL