I have a very big table for users as below:
CREATE TABLE `karbar` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(70) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`password` char(41) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`token` char(40) NOT NULL,
`joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`totalspam` tinyint(3) unsigned NOT NULL DEFAULT '0',
`flname` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`activation_link` char(40) NOT NULL,
`role` tinyint(3) unsigned NOT NULL DEFAULT '1',
`gender` char(1) NOT NULL DEFAULT 'u',
`is_shop_active` char(0) DEFAULT '',
`english_name` varchar(30) NOT NULL,
`followings` mediumint(8) unsigned NOT NULL DEFAULT '0' ,
`followers` mediumint(8) unsigned NOT NULL DEFAULT '0' ,
PRIMARY KEY (`uid`),
UNIQUE KEY `email` (`email`),
) ENGINE=InnoDB
I want to fill this table with lots of data. Let's say millions of records. How to do this? I need to produce unique emails. Different data for emails. I know I can use CONCAT
but don't know how to produce random data