/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 vote197 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
-2 votes202 views1 answer
No module named '_sqlite3
SQL
0 vote199 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote198 views1 answer
C# check if mysql query modified rows
SQL
0 vote226 views5 answers
How to make trigger in phpmyadmin
SQL
3 votes223 views4 answers
Truncate syntax in sql
SQL
0 vote158 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote226 views1 answer
Bigrock database connection string
SQL
0 vote180 views1 answer
Python mysql query where
SQL
0 vote160 views1 answer
Mysql sleep connections
SQL