Write a c program to store and edit the records?

for eg.if i give"create table tablename(name,varchar(10),salary,(10,2)... program should parse the given statement and check if the syntax is correct.if it is correct,then a structure should be created with the same tablename with name and salary in it.i am just a beginner so dont go deeply into sql or anything.i need a c program just to parse and check a given statement.only the statement is similar to that in sql.like this i have to do for select,insert,delete and update.

Write a c program to store and edit the records?
Best option would be to use LEX and YACC to parse the ddl statements. Then you could use a flat file (with your predefined formats for your name/salary fields) to populate the objects.





The scope for coding is beyond the means of this group. I guess you have a good starting point though.