/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 vote228 views1 answer
Joins vs includes
SQL
0 vote266 views1 answer
Get role postgres
SQL
0 vote239 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote251 views1 answer
Mysql select all and rename one
SQL
2 votes238 views1 answer
Copy all values of a column to another column in sql in same table
SQL
3 votes260 views1 answer
Oracle function return
SQL
0 vote243 views1 answer
Mariadb disable foreign key checks
SQL
6 votes241 views2 answers
If not exists insert sql
SQL
0 vote248 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote242 views1 answer
Provide hardcoded value in the mysql query
SQL