mysql

Question

sir my intension is i want to 1.excute basic sql commnds 2.i want create update table by using java program using jdbc odbc driver plese give clarity about what can i download?how to instal ?and i downloaded mysql .it asks .net framework 4.0.but i dont need this.what can i do? plese tell me sir?

Nilesh Jadav · Answer

Some how it is necessary but either way you can do it without database : http://stackoverflow.com/questions/27964340/executing-a-mysql-query-without-selecting-database-in-java http://www.ibm.com/developerworks/library/j-jtp05315/

mounika ch · Answer

ok.but is nessasary for java aplication connecting throgh databs?

Nilesh Jadav · Answer

Check which Visual studio you are using if it is visual studio 2008 then it is having 3.5 framework and if you are using vs10 then it having framework4.0 so just check out vs framework  my sql will run on framework 4.0 if it is not with you then download from here : https://www.microsoft.com/en-gb/download/details.aspx?id=17718 Other then this if you are using mysql than that of SQl server then you need to first connect your vs to mysql via this link : http://www.c-sharpcorner.com/UploadFile/65fc13/working-with-mysql-to-visual-studio-2010/ http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-making-a-connection.html http://www.itcsolutions.eu/2010/09/09/how-to-connect-to-mysql-database-from-visual-studio-vs2010-problems-with-net-connectors/ After that you just embed your code in.cs file for basic sql queries: Just make a table in mysql : and call the connection string in .cs file then you can write your code in whatever event you want to. http://www.codejava.net/java-se/jdbc/jdbc-tutorial-sql-insert-select-update-and-delete-examples http://www.vogella.com/tutorials/MySQLJava/article.html

Manoj Bhoir · Answer

Hi Please check these links : http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html http://www.java-samples.com/showtutorial.php?tutorialid=9