Hello ALL,

I would like to create and use a view in my C/C++ program. How to create and access the view.

Can I directly use the following statement in my c/c++ program

but how to declare the variable myview in the C/C++ program?

Thanks,

the view is MySQL specific
its SQL not any thirdparty language like C/C++ or whatever
so you need to send it to the server as you woudl any other SQL statements

its a two step process..
first off create the view (can be done in C++, remember to use drop if exists)
then use the view as you would in any valid SQL statement

healdem, thanks.

I am new to MySQL. so I am not very clear about your solution.

When I queried a MySQL database, I had to use the following MySQL C API function
in my C/C++ program. I wonder if there is any MySQL C API function to take
Or, I can directly put the above create statement in my C/C++ program.

Thanks

as siad before its a two stage process
first off you create the view, whetehr tyou do that in C++ or say a query program like MySQL Query browser is up to you.

havign created the view it then becimes avaialble to you, and any other developer.

I'd suggest you create the view in MySQL Query Browser.
you can modify views, by dropping the earlier version and replacing have a look at the doecumentation on views and the drop/create syntax on the MySQL manual

I don't know C++ but as the create syntax is MySQL SQL thesame function that you sue to SELECT data shoudl also work for view creation. Effectively its exactly the same as other DDL sattements that create or modify tables

the solution is
in C/C++ program,
mysql_query(create view myview as select ....)