Talk:Troubleshooting - SQL Patches

Formatting of the documentation from sqlpatch.php is not good; still learning wiki syntax :) --Grayson 07:07, 24 February 2006 (EST)

If you need help with formatting or syntax, feel free to ask. ;-) I see that you've written that the SQL patches tool need SQL in upper-case, but are you sure that's right? I think it automatically transforms input to upper-case where it needs to. Do you have example syntax that fails? Dwno 07:59, 24 February 2006 (EST)

Heh, I see now that the note about upper case input is from the documentation in the sqlpatch.php, but I still think it's wrong actually. Dwno 08:03, 24 February 2006 (EST)

No, I don't, and Paul (paulm) has successfully run queries through the tool that don't meet the stated all-caps requirement, so perhaps the tool *doesn't* require it....but it says it does. I'll edit to remove my comment about all-caps, but leave the helptext as is (as that comes directly from the tool itself). Also: is my comment accurate about the function of the NEXT_X_ROWS command? Grayson 08:06, 24 February 2006 (EST)

I have no idea about the NEXT_X_ROWS_AS_ONE_COMMAND thing. I looked at the examples given in sqlpatch.php, but I can't make sense of it. I was under the impression you can't run more than one command at once anyway with mysql_query(), and set variables should last for the rest of the connection, so I can't see why this ZC feature exists or how this is supposed to work. Dwno 08:17, 24 February 2006 (EST)