The answer would appear to be: use SELECT statements to query the database and see if it contains what you expect it to (but perhaps I'm missing part of your requirements). You can issue these SELECTs the same way you issue your INSERTS (e.g. through a web front end) or else you can use a command line tool. If you don't have access to MySQL's native command line tool, you can try dbish, in the DBI::Shell distribution which provides a generic command line tool for all DBI accessible databases and can be installed by a non-root user in any directory.

In reply to Re: Database access on your site, or "Where the hell is mysql?" by jZed
in thread Database access on your site, or "Where the hell is mysql?" by SkipHuffman

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.