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

7 years, 11 months ago Guillaume Lefranc

Try spawner, it can do exactly what you need:

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

 
7 years, 11 months ago Cyberdome Cyberdome

@guillaumelefranc Thanks!!! This sounds promising. Will give it a try. Just for anyone else, I also found something online. See below.

INSERT INTO yourtable SELECT seq,CONCAT('NAME FROM:',seq), CONCAT('ADR:',seq), CAST(RAND(SEQ)*10000000 AS INT),CONCAT(seq,'@dumymail.xx') FROM seq_1_to_1000000;

Not sure how to create the Structure / Schema to have this data INSERT INTO ???

 
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.