0

Pay attention to mysql/mariadb, sintax changed?

I have a vps with mariadb and one virtual machine with mysql, i use in php code and in terminal. Both does not support sintax like that: SELECT column_list FROM table_name WHERE condition; You must write whit this symbol: ` . Example: SELECT `id`,`email`,`password` from `accounts` WHERE id <= 5; If you don't, you will get an syntax error. All of this course on SoloLearn it is not wrong, it is really good, but pay attention to the syntax.

3rd Mar 2017, 6:34 AM
Neacșu Marius Mihail
Neacșu Marius Mihail - avatar
1 Answer
+ 1
and in sololearn its not mysql or mariadb (which is mysql), its sql which IS different, just similar
4th Mar 2017, 9:59 AM
William La Flamme
William La Flamme - avatar