Could someone please change this database taken from My SQL to C++ for me please?
This is a database I was using but I no longer want to use C++ and have no idea about how to change it myself. Thanks.
CREATE TABLE person (
ID int(10) unsigned NOT NULL AUTO_INCREMENT,
First_Name VARCHAR(50),
Last_Name VARCHAR(50),
Address1 VARCHAR(50),
Address2 VARCHAR(50),
City VARCHAR(50),
State VARCHAR(50),
Zip_Code VARCHAR(20),
Home_Phone VARCHAR(20),
Cell_Phone VARCHAR(20),
Work_Phone VARCHAR(20),
Email1 VARCHAR(100),
Email2 VARCHAR(100),
FK_Company INT(10),
PRIMARY KEY (ID),
KEY `FK_Company` (`company`),
)
CREATE TABLE IF NOT EXISTS `company` (
ID int(10) unsigned NOT NULL AUTO_INCREMENT,
Company_Name VARCHAR(200),
Address1 VARCHAR(50),
Address2 VARCHAR(50),
City VARCHAR(50),
State VARCHAR(50),
Zip_Code VARCHAR(20),
PRIMARY KEY (ID)
)
-- 1. Add a new person to the data base
INSERT INTO person (First_Name, Last_Name, Address1, Address2, City,State, Zip_Code, Home_Phone, Cell_Phone, Work_Phone, Email1, Email2, FK_Company) VALUES (
'First Name', 'Last Name', 'Address 1', 'Address 2',' City', 'State', '00000', '00 000 0000', '11 111 1111', '22 222 2222', 'name@home.com', 'name@work.com',1)
-- 2. Modify the data about a person
UPDATE person SET (
First_Name='First Name',
Last_Name='Last Name',
Address1='Address 1',
Address2='Address 2',
City='City',
State='State',
Zip_Code='00000',
Home_Phone='11 111 1111',
Cell_Phone='22 222 2222',
Work_Phone='33 222 2222',
Email1='name@home.com',
Email2='name@work.com',
FK_Company=2
)
-- 3. Delete a person from the database
DELETE FROM person WHERE ID=1
-- 4. Search the database for a matching name, or match a phone number or a part of a phone number, by city or state, and by part of an email address.
SELECT * FROM person WHERE Last_Name='Last Name'
SELECT * FROM person WHERE Home_Phone='11 111 1111'
SELECT * FROM person WHERE Home_Phone LIKE '11 111%'
SELECT * FROM person WHERE City='City'
SELECT * FROM person WHERE State='State'
SELECT * FROM person WHERE Email2 LIKE '%@work.com'
SELECT * FROM person WHERE FK_Company=1|||I don't understand the question...C++ is not a database management system (it's a programming language) so you could not convert a MySQL database to C++ to begin with.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment