I am about to write a little program to process database dump files created by mysqldump and I would like to make sure that my expectations about the »anatomy« of mysqldump's output are right. So please check the statements below and correct the if they are wrong.
- When dumping text mysqldump uses a single quote (') to wrap the text to insert.*
- Inside these quotes mysqldump escapes single quotes, double quotes and Backslashes (',",\) with a Backslash.*
- »newline« characters are dumped as: \n, \r\n
- the value of each INSERT of a String is only in one line of the dump-file.
*if not specified differently in command-line arguments
In General my problem is that I could not find any documentation or resource about the »anatomy« of the generated output, I know that these are SQL statements, but especially the way String are handled is the part I am interested in, so if there exists any good Stuff read out there dealing with that, please let me know.
Thanks in ahead!