Is there a way to test a mySQL query before I run it? I have a really big insert, and I don't want it to get half way then mess up over something.
I'd like to do a dry run.
-Antun
Test it in phpMyAdmin. If it works, then delete it
Thanks,
That's OK if I have phpMyAdmin installed (I happen to in this case, but not always).
However the query I'm running will add about 3500 rows.
Does mysql really not have a dry-run mechanism?
Not that I know of. You could always copy the table structure to another table and try it there. phpMyAdmin seems to just be convenient. You really don't need to do it there. You can also execute it through the command line or whatever your choice of connection is.
The namual is your friend http://www.mysql.com/documentation/maxdb/5e/eba66d440a11d3a98200a0c9449261/content.htm
Originally posted by drawmack The namual is your friend http://www.mysql.com/documentation/maxdb/5e/eba66d440a11d3a98200a0c9449261/content.htm
What exactly is a namual? 😃
Originally posted by LordShryku What exactly is a namual? 😃
if you don't quit discriminating against dyslexics I'm going to sue you.
Yes, well I'm offended by your avatar, so I'll counter-sue :p
you can sue the counter all you'd like since I am the chair it will not bother me what you do to the counter
