/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

8 votes147 views1 answer
Script to add datafile to tablespace
SQL
0 vote123 views1 answer
Sql trim whitespace
SQL
0 vote141 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote138 views1 answer
Sql query for getting data with join and count
SQL
0 vote135 views1 answer
Dbms_output sql developer
SQL
1 vote137 views1 answer
Psql lst trigger
SQL
0 vote145 views1 answer
How to run mysql on terminal mac
SQL
32 votes147 views6 answers
Insert into values select
SQL
3 votes137 views1 answer
Mysql insert on dupèlicate
SQL
2 votes133 views3 answers
Write sql query to find the second highest salary of employee
SQL