FREE AI-Enhanced Online MySQL Compiler - For learning & practice

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `user_id` varchar(45) DEFAULT NULL,
  `role` varchar(45) DEFAULT NULL,
  `UsersID` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;
CREATE TABLE `members` (
  `id_member` int(100) NOT NULL AUTO_INCREMENT,
  `NameMember` varchar(100) DEFAULT NULL,
  `LastName` varchar(100) DEFAULT NULL,
  `ClubName` varchar(100) DEFAULT NULL,
  `SponsorName` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'inactive',
  `UsersID` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_member`),
  KEY `fk_user` (`UsersID`),
  CONSTRAINT `fk_user` FOREIGN KEY (`UsersID`) REFERENCES `users` (`id`));
  
  -- Inserting data into users table
INSERT INTO `users` (`Name`, `email`, `password`, `phone`, `birthday`, `gender`, `user_id`, `role`, `UsersID`) 
VALUES 
('Alice Smith', 'alice.smith@example.com', 'password123', '555-1234', '1990-05-10', 'Female', 'alice123', 'admin', 'alice001'),
('Bob Johnson', 'bob.johnson@example.com', 'password123', '555-5678', '1985-07-15', 'Male', 'bob456', 'user', 'bob002'),
('Charlie Brown', 'charlie.brown@example.com', 'password123', '555-8765', '1992-10-20', 'Male', 'charlie789', 'user', 'charlie003'),
('Dana White', 'dana.white@example.com', 'password123', '555-1122', '1988-12-05', 'Female', 'dana010', 'moderator', 'dana004');
-- Inserting data into members table
INSERT INTO `members` (`NameMember`, `LastName`, `ClubName`, `SponsorName`, `email`, `status`, `UsersID`)
VALUES
('John Doe', 'Doe', 'Example Club', 'Sponsor A', 'john.doe@example.com', 'active', 1),   -- Link to Alice Smith (id=1)
('Jane Smith', 'Smith', 'Fitness Club', 'Sponsor B', 'jane.smith@example.com', 'inactive', 2), -- Link to Bob Johnson (id=2)
('Sam Green', 'Green', 'Tech Club', 'Sponsor C', 'sam.green@example.com', 'active', 3),  -- Link to Charlie Brown (id=3)
('Duplicate', 'White', 'Adventure Club', 'Sponsor D', 'emily.white@example.com', 'inactive', 4), -- Link to Dana White (id=4)
('Emily White', 'White', 'Adventure Club', 'Sponsor D', 'emily.white@example.com', 'inactive', 4); -- Link to Dana White (id=4)

select * from users;
 select * from members;

id	Name	email	password	phone	birthday	gender	user_id	role	UsersID
1	Alice Smith	[email protected]	password123	555-1234	1990-05-10	Female	alice123	admin	alice001
2	Bob Johnson	[email protected]	password123	555-5678	1985-07-15	Male	bob456	user	bob002
3	Charlie Brown	[email protected]	password123	555-8765	1992-10-20	Male	charlie789	user	charlie003
4	Dana White	[email protected]	password123	555-1122	1988-12-05	Female	dana010	moderator	dana004

id_member	NameMember	LastName	ClubName	SponsorName	email	status	UsersID
1	John Doe	Doe	Example Club	Sponsor A	[email protected]	active	1
2	Jane Smith	Smith	Fitness Club	Sponsor B	[email protected]	inactive	2
3	Sam Green	Green	Tech Club	Sponsor C	[email protected]	active	3
4	Duplicate	White	Adventure Club	Sponsor D	[email protected]	inactive	4
5	Emily White	White	Adventure Club	Sponsor D	[email protected]	inactive	4