jeudi 23 avril 2015

How can I create a function in MySQL for add elements in a table?

I would like to add elements in a table like this:

Codigo  Name   Lastname   Date    Sex    Salary
1       name1  lastname1  random  random random
2       name2  lastname2  random  random random
3       name3  lastname3  random  random random
4       name4  lastname4  random  random random

Date is a date random betweem years 2000 - 2015

Sex is random boolean 1 or 0

Salary is a random float between 500.00 and 5000.00

is that possible? How can I do that?

Aucun commentaire:

Enregistrer un commentaire