/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 vote175 views1 answer
Creating sqeuence in oracle database
SQL
1 vote134 views2 answers
Snowflake alter column data type
SQL
0 vote128 views1 answer
Postgres jsonb array push new element
SQL
-2 votes152 views1 answer
Mysql not empty
SQL
0 vote126 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote132 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote242 views1 answer
Sql server query all database objects
SQL
3 votes141 views1 answer
Oracle revoke
SQL
0 vote141 views2 answers
Uninstall postgresql mac
SQL
1 vote133 views1 answer
Mysql select if empty result
SQL