/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

5 votes172 views1 answer
How to get all table names in sql query
SQL
0 vote149 views1 answer
Populate db from command line postgres
SQL
1 vote149 views1 answer
Update foreign key value in mysql
SQL
0 vote200 views1 answer
Drop view sql
SQL
1 vote147 views3 answers
Mysql Server Start
SQL
0 vote144 views1 answer
Oracle SQL join three tables and group by column
SQL
3 votes160 views1 answer
Oracle cannot access v$session
SQL
0 vote176 views1 answer
C# sql transaction multiple connections
SQL
0 vote288 views1 answer
Install mysql on bash
SQL
0 vote98 views1 answer
Update row in sqlite python
SQL