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.
"privilege" comes from the Latin words for "private" and "law" (legal) and dates to feudal times. To "claim privilege" meant that you were above the laws that applied to the common people.
posted 5 months 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)