doing a while true in a mysql exec statement in php
I was wondering if it was possible to do something like this in php
$sql = "while 1 do update table set field1 = 1 where 1 = 1 end do;"
$res = mysql_query($sql, $conn)
I am asking this because someone seems to have done something very similar to my database. I dont have access to the server logs of the mysql logs either. I was just wondering what the syntax was if i wanted to do this.
I have been unable to get a while statement running from the command line like this
However it's more likely that the loop is done in the calling script...