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.
About Author
Thank you! This is VERY VERY Useful!!!!
Thanks dude, thats a handy lil scrip
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!
These are actually enormous ideas in regarding blogging.
You have touched some good points here. Any way keep up wrinting.
Excellent notable analytical attention designed for detail and
may anticipate difficulties prior to these people happen.
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.
I love to disseminate information that I’ve built up with the calendar year to help enhance team performance.
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.
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.
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.
After exploring a number of the articles on your blog, I seriously like your technique of writing a
blog. I saved it to my bookmark website list and will be checking
back in the near future. Please visit my website as well and let me know
your opinion.
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!
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.
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.
It’s amazing to go to see this web site and reading the views of all colleagues concerning this post, while I am also keen of getting knowledge.
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!
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
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.
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;