Hello, i have been trying to find some information all over the internet about connecting programmaticly to my MySQL Database Server. I want to see if someone could show me some examples
1) Create a database qry "CREATE DATABASE mynewdb;"
2) Get from the database "SELECT u_phone, u_address FROM mynewdb WHERE u_id = 'john';", and get that data.
3) How to get a specfic field from a select query performed above,
4) How to add, update and delete records from a table.
Thanks for your help in advanced.
PS: I want to use ADO.NET but i don't want to use any 3rd party drivers except mysql odbc.