/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 votes205 views2 answers
To_char oracle
SQL
6 votes185 views1 answer
Phpmyadmin reset root password
SQL
0 vote200 views1 answer
Call scalar valued function sql
SQL
4 votes202 views1 answer
Wildcard in sql
SQL
1 vote216 views3 answers
Drop unique key constraint in sql server
SQL
0 vote203 views1 answer
PSQL qith variables
SQL
0 vote203 views1 answer
Mariadb errno 121
SQL
8 votes239 views4 answers
Reset SQL auto increment
SQL
1 vote205 views1 answer
Python clean sql string
SQL
0 vote213 views1 answer
How to combine first and last nae into one columb sql
SQL