/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

3 votes281 views1 answer
Mysql replace string in table
SQL
0 vote285 views1 answer
Sql contains vs like
SQL
7 votes289 views3 answers
Add primary key to database sql
SQL
0 vote280 views1 answer
Plpgsql if statement
SQL
4 votes322 views3 answers
Sql find second highest salary employee
SQL
-1 vote280 views1 answer
Insert results of a stored procedure into a temporary table
SQL
3 votes294 views1 answer
How to find names includes in sql
SQL
2 votes327 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote295 views1 answer
Group by join columns per table
SQL
0 vote259 views1 answer
Sql random decimal
SQL