/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 vote191 views2 answers
Execute stored procedure without db set
SQL
0 vote131 views2 answers
Impala rename column name
SQL
0 vote111 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote116 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote128 views1 answer
Retrieve meaning
SQL
-3 votes107 views1 answer
Remove spaces sql 2008
SQL
0 vote108 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
-1 vote112 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote124 views2 answers
Plsql function that return a table
SQL
12 votes118 views4 answers
Import mysql database command line linux
SQL