mysql returns: "Can't update table 't1' in stored
function/trigger because it is already used by statement which invoked this
stored function/trigger"
Why I cant make a trigger that update the some table that invoke the
trigger???
How can I build it?
Thanks.
Lucas Vendr
t is already used by statement which invoked this
stored function/trigger"
Why I cant make a trigger that update the some table that invoke the trigger???
How can I build it?
Thanks.
Lucas Vendramin
a function that will convert x.x.x.x to an int and
then you just put that int into a field in your database and then use the
INET_ATON function in MySQL to select the ips you want.
SELECT INET_ATON('3.2.0.13') > INET_ATON('3.2.0.2')
That should return TRUE. :)
Hope that
Hi all.
I have a problem:
When I compare two strings in mask (x.x.x.x) the comparation is not true (for
my question :D)... look:
select '3.2.0.13' > '3.2.0.2'-> FALSE
I want this command return TRUE, but it is returning FALSE.
But, if I put a space first into the smaller string the ca