Re: How to store a chat in a mysql db

On Tue, 19 Mar 2019 09:59:51 +0100, ^Bart <gabriele1NOSPAM_at_hotmail.com> wrote:

> FOREIGN KEY (`user_id`)
> REFERENCES `chat_users` (`id_chat_user`)
> ON DELETE NO ACTION
> ON UPDATE NO ACTION)
Should be:
 ON UPDATE NO ACTION without the closing parenthesis.

> )
> ENGINE=INNODB;
>
> In the third table I have: ERROR 1064 (42000): You have an error in your
> SQL syntax; check the manual that corresponds to your MariaDB server
> version for the right syntax to use near ')
> ENGINE=INNODB' at line 21
>
> It seems everything is ok... :\

[Quoted] Use the "match brackets" function of your editor to find these kind of errors.

-- 
Regards,
Kees Nuyt