-Inne Zapytanie do bazy sql

[Boski0]

Witam poszukuje zapytania do bazy sql dotycz?cy achievements poniewa? wy?wietla mi si? taki oto b??d w konsoli "mysql_real_query(): INSERT INTO `player_achievements` (`player_id`, `id`, `name`, `points`, `date`) VALUES (7, 1, 'Witaj na ots', 2, 1484487755); - MYSQL ERROR: Table 'ots.player_achievements' doesn't exist (1146)
"

 

[buchaLL]

Odp: Zapytanie do bazy sql

[SQL]CREATE TABLE `player_achievements`
(
`player_id` INT NOT NULL DEFAULT 0,
`id` INT NOT NULL DEFAULT 0,
`name` INT NOT NULL DEFAULT 0,
`points` INT NOT NULL DEFAULT 0,
`date` INT NOT NULL DEFAULT 0,
KEY (`player_id`), UNIQUE (`player_id`, `id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;[/SQL]

 

[Boski0]

Odp: Zapytanie do bazy sql

Podzia?a?o, dzi?ki wielkie