Generate test data using MariaDB/MySQL

generate_test_data_example_1.sql

with recursive series as (
	select 1 as id union all
	select id + 1 as id
   from series
   where id < 100), 
   		cities as (select 'Santa Clara' city union all 
   		           select 'Los Angeles' union all 
   		           select 'Santa Clarita' union all 
   		           select 'San Bernardino' union all
   		           select 'Alameda' union all
   		           select 'San Mateo' union all 
   		           select 'Santa Barbara'   		           
   		          ),
   		first_names as (select 'John' first_name union all
   				select 'James' first_name union all
   				select 'David' first_name union all
   				select 'Jeremy' first_name union all
   				select 'Ron' first_name union all
   				select 'Katie' first_name union all
   				select 'Nikita' first_name union all
   				select 'Rachel' first_name union all
   			        select 'Tom' first_name	
   		),
   	 	last_names as (select 'Smith' last_name union all
			       select 'Johnson' last_name union all
   			       select 'Williams' last_name union all
   			       select 'Brown' last_name union all
   			       select 'Jones' last_name union all
   		               select 'Miller' last_name union all
   			       select 'Davis' last_name union all
   			       select 'Wilson' last_name union all
   			      select 'West' last_name	
   		)
select id, user_id, first_name, last_name
       dob, city, salary - mod(salary, 100) salary
from (select id, 
       substring(md5(rand()),1,20) user_id,
       (select first_name from first_names order by rand() limit 1) first_name,
       (select last_name from last_names order by rand() limit 1) last_name,
       date(concat_ws('-',(floor(1919+rand()*100)),
                          (floor(1+rand()*12)),
                          (floor(1+rand()*28))
                     )
           ) dob,
       (select city from cities order by rand() limit 1) city,
       floor((rand() * (120000 + 1)) + 35000) salary
from series) as t;