Generating random names in MySQL

I’ve improved my earlier random string generation procedures to better suit my needs. So I created a Random Name Generator for MySQL.

I’ve created two new procedures. They pick from the 100 most popular first names (well actually the 50 most popular male and 50 most popular female first names for the US) and the 100 most popular surnames (for the US).

Using these two procedures generate_fname() and generate_lname() you can create realistic random names and email addresses for your tests.

You can download the SQL here.

19 thoughts on “Generating random names in MySQL”

  1. I’m truly enjoying the design and layout of your website. It’s a very easy on the eyes which makes it
    much more enjoyable for me to come here and visit more often.
    Did you hire out a designer to create your theme? Fantastic work!

  2. I think the admin of this web site is genuinely working hard in favor of his web page,
    for the reason that here every material is quality based material.

  3. Hi there! I simply wish to give an enormous thumbs up for the
    great data you have got here on this post. I might be coming again to your weblog for extra soon.

  4. Customers are met with prompt, relevant & engaging response generating higher satisfaction and greater loyalty.
    All these due to the fact that online services are prompt, easy to fetch, most
    varied options at just one click and more over it has an approach all over the globe which is most amazing
    benefit to be online. In addition to these applications,
    analysis software is also important for planning and management
    in all businesses.

  5. I’ve been browsing online more than 2 hours today, yet I never found any interesting article like yours. It’s pretty
    worth enough for me. In my view, if all web owners and bloggers made
    good content as you did, the web will be much more useful than ever before.

  6. Hello! I know this is kinda off topic but I’d figured I’d ask.
    Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa?
    My site addresses a lot of the same subjects as yours and I think we could greatly benefit from each other.
    If you might be interested feel free to send me an email.

    I look forward to hearing from you! Great blog by the
    way!

  7. If some one wishes to be updated with hottest technologies afterward he
    must be pay a quick visit this web page and be up to date
    everyday.

  8. hi!,I like your writing so much! percentage we keep in touch
    extra about your post on AOL? I need a specialist in this house to resolve my problem.
    May be that’s you! Taking a look forward to look you.

  9. Hi there, just became alert to your blog through Google,
    and found that it is truly informative. I am going to watch out for brussels.
    I will be grateful if you continue this in future. Numerous
    people will be benefited from your writing. Cheers!

  10. I think this is among the most important information for
    me. And i am glad reading your article. But wanna remark on
    few general things, The web site style is great, the articles is really nice : D.
    Good job, cheers

  11. Heya i’m for the first time here. I found this board and I to find It really useful & it helped me out much. I’m hoping to
    offer something back and aid others like you helped
    me.

  12. Hello, thanks for this file- this saved my day!
    By the way – in Your file the last line should be:

    select generate_fname() as FirstName, generate_lname() as LastName;

Leave a Reply

Your email address will not be published. Required fields are marked *