/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 vote128 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote136 views3 answers
Epoch to datetime
SQL
0 vote144 views1 answer
Difference between db.query and db.execute
SQL
2 votes166 views3 answers
Postgres create view
SQL
0 vote125 views1 answer
Oracle grant create job
SQL
2 votes171 views2 answers
Null column to 0 in mysql
SQL
0 vote182 views1 answer
How to compile a function in oracle
SQL
1 vote271 views3 answers
Sql subquery
SQL
0 vote140 views4 answers
Sql rownum
SQL
10 votes132 views2 answers
Tsql merge example
SQL