I was just browsing through the searchable online MySQL manual, trying to
find a list of the aggregate functions (as I don't trust the list in the
O'Reilly book, considering the number of typos and missing information in
other sections), and couldn't find anything.. Is there a list in the
manual?
I have a very simple query that used to work and then recently stopped. It
goes something like:
SELECT name FROM Items WHERE category RLIKE '^\* new cat \*';
Now, I'm pretty familiar with how regex works, and I was pretty sure that
when I put a \ in front of the * it would interpret it as a * i
> Two things you might want to try... first download and install the newest
> Msql-Mysql DBD drivers.. check what the documentation says in there.. and
> second, keep changing what variable you are trying to access and maybe you
> will find one works that isnt documented.
My problem with this is
> Woops sorry about that last message.
> Try using the following:
> my $id = $sth->{insertid};
> That is what I had to change it to, to get it working.. despite what the
> documentation says.
Actually, I can't use that. The script dies, it's not like it just warns me
that it doesn't work, but it
My ISP recently updated one of their servers to 3.23.38, and all of a sudden
a BUNCH of my code stopped working. I use a number of insert queries (new
items, new search caches, etc), where I insert a blank record, and then take
notes of its id (usually "int unsigned auto_increment primary key"),
> SELECT RTRIM(CONCAT(parents, ' ')) AS parents, name FROM Categories ORDER BY
> parents, name;
>
> Note:
>
> SELECT RTRIM(parents) AS parents, name FROM Categories ORDER BY parents,
> name;
>
> works SOMETIMES, but not in every case.
Ammending this, as I did a little more testing.. U
