/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

2 votes180 views1 answer
Update with join sql server
SQL
1 vote203 views1 answer
Change table to innodb mysql
SQL
0 vote190 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote203 views1 answer
If null don't update
SQL
0 vote159 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
27 votes196 views4 answers
Get all tables with column name sql
SQL
0 vote214 views1 answer
Mysql get only the field names in a table
SQL
7 votes195 views1 answer
Oracle pagination query offset
SQL
11 votes179 views1 answer
Oracle insert into where
SQL
0 vote190 views1 answer
Oracle current session details
SQL