MySQL Forums
Forum List  »  Newbie

Re: Query challengers table
Posted by: Jassim Rahma
Date: June 11, 2022 02:09PM

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_uuid` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`email_address` varchar(255) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `idx_users_email_address` (`email_address`)
) ENGINE=InnoDB AUTO_INCREMENT=1126 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1001, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'Jassim', 'Al Rahma', 'email@domain.com');
INSERT INTO `users` VALUES (1102, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User1', 'Last1', 'email@domain.com');
INSERT INTO `users` VALUES (1103, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User2', 'Last2', 'email@domain.com');
INSERT INTO `users` VALUES (1100, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User3', 'Last3', '@domain.com');
INSERT INTO `users` VALUES (1082, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User4', 'Last4', 'email@domain.com');
INSERT INTO `users` VALUES (1051, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User5', 'Last5', 'email@domain.com');
INSERT INTO `users` VALUES (1049, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User6', 'Last6', 'email@domain.com');
INSERT INTO `users` VALUES (1045, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User7', 'Last7', 'email@domain.com');
INSERT INTO `users` VALUES (1042, '5c9b83c2-d6b2-11eb-b3ce-008cfa12d1e1', 'User8', 'Last8', 'email@domain.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

Options: ReplyQuote


Subject
Written By
Posted
June 10, 2022 01:56PM
Re: Query challengers table
June 11, 2022 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.