I wrote this in my terminal from an example. I got homebrew and Mariadb installed and I am using dbeaver. I got this error:
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 'End $$
Delimeter $$ begin select * from Contents where Cname like '% ammonium %' at line 1
Anything that matches "LIKE 'AMMONIUM %'" will also match the other LIKE clauses - and you've duplicated one of them, so that code is doubly redundant.
I do not recommend using capital letters in database table and column names. Different databases interpret them differently. Plus, they can be a real pain bouncing up and down on the SHIFT key when you start doing ad hoc queries.
Being persecuted doesn't in any way prove your righteousness or your beliefs. Many people get persecuted because they are repugnant or annoying. Or just because they can be.
posted 3 weeks ago
Okay thanks I have fixed that now but i still got the error that table mysql.proc doesn't exist. I am using mariadb and installed it via homebrew.
Tim Holloway wrote:Anything that matches "LIKE 'AMMONIUM %'" will also match the other LIKE clauses - and you've duplicated one of them, so that code is doubly redundant.
This could be a Monday-morning thing, so bear with me here.
LIKE 'AMMONIUM %' will only match fields that start with 'AMMONIUM ' 'LIKE '% AMMONIUM %' will match anything that contains AMMONIUM with a space before and after, so the former can't be used as a substitue for the latter...can it?
(Ignoring the duplicated LIKE, of course)