/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

1 vote314 views1 answer
Sql find column name like
SQL
0 vote325 views1 answer
Ms sql filter all sympbol
SQL
0 vote326 views1 answer
Database db connection string format
SQL
0 vote315 views1 answer
Create table sql generator
SQL
2 votes354 views1 answer
Oracle Column Names of a table
SQL
1 vote314 views1 answer
Show structure of table in sql
SQL
4 votes345 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote311 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote316 views1 answer
Psql autocomplete for mac brew install
SQL
1 vote288 views1 answer
Oracle current sequence value
SQL