/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 vote174 views1 answer
If column value is null then in mysql
SQL
3 votes159 views3 answers
Print in pl sql
SQL
0 vote186 views1 answer
Mysql change innodb to myisam
SQL
17 votes194 views2 answers
Mysql date to string
SQL
-1 vote179 views3 answers
Psql get last rows
SQL
0 vote200 views1 answer
Excel vba import data to sql server
SQL
1 vote182 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote214 views1 answer
Gcloud sql instance list
SQL
9 votes187 views6 answers
Sql add column with default value
SQL
4 votes173 views1 answer
Wildcard in sql
SQL