SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE members ( id INT, member_id VARCHAR(20), mobile VARCHAR(20), date_of_birth VARCHAR(20), PRIMARY KEY (member_id) ); INSERT INTO members (id, member_id, mobile, date_of_birth) values (1,'member_1','+919432122222', '10-10-1999'), (2,'member_2','+919132122222', '12-11-1979'), (3,'member_4','+919532122222', '20-09-1989'), (4,'member_6','+919732122222', '09-05-1995'); CREATE TABLE txn ( txn_id INT, amount INT, txn_date VARCHAR(20), member_id VARCHAR(20), PRIMARY KEY (txn_id), FOREIGN KEY (member_id) REFERENCES members(member_id) ); select * from members