/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 vote252 views1 answer
View to table
SQL
5 votes208 views1 answer
Oracle get nls settings
SQL
0 vote272 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote393 views1 answer
Multiple row join
SQL
-1 vote192 views1 answer
Mysql case when multiple conditions
SQL
0 vote215 views3 answers
Duplicate row mysql
SQL
9 votes219 views3 answers
Import DB through mysql console
SQL
1 vote208 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote197 views1 answer
Sql count null as 0
SQL
3 votes197 views2 answers
Sql server current date without time
SQL