The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

how to create fake DATA inside MariaDB SQL database???

Hello World,

I am trying to create some TEST DATA, meaning fake date for playing around with MariaDB tables and databases.

I need to create some fake random data using SQL RDBMS. So, why not use Mockaroo.com , but on that website I can only do 1000 rows at one time. Which is extremely time consuming.

How can I create random fake data. Tons of it. For example, Let us say I want 2 millions rows of random data with ID, NAME, ADDRESS, PHONE, EMAIL.

I hope I am making sense. Any help is greatly appreciated!!!!!

Thanks ____ ____ Linux Newbie - Information is Power! Download Linux @ http://www.fedora.redhat.com/ May the Linux force be with you! Fedora 23 - MariaDB 10.1

Answer Answered by Guillaume Lefranc in this comment.

Try spawner, it can do exactly what you need:

https://sourceforge.net/projects/spawner/

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.