/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 vote113 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote114 views1 answer
Oracle list partitions
SQL
0 vote101 views1 answer
Sql pivot without aggregate
SQL
0 vote100 views2 answers
Sqlite
SQL
2 votes116 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote121 views1 answer
Mysql dump specific tables
SQL
1 vote108 views1 answer
Oracle case
SQL
7 votes114 views2 answers
How to create index mysql
SQL
17 votes104 views6 answers
Sql select distinct
SQL
14 votes105 views5 answers
Sql oracle limit
SQL