Wednesday, February 1, 2012

My SQL Database to CPP?

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.

No comments:

Post a Comment