Tag Archives: mysql

22Aug/13

How to import large sql files into mysql using phpmyadmin wamp server

Stop all services in wamp. Then make changes to php.ini post_max_size = 750M upload_max_filesize = 750M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M max_allowed_packet = 200M (in mysql  my.ini  file)Read More…

26Jun/13

JSF 2.0 + JDBC integration example

Here’s a guide to show you how to integrate JSF 2.0 with database via JDBC. In this example, we are using MySQL database and Tomcat web container. Directory structure of this exampleRead More…

31May/13

Difference between execute, executeQuery, executeUpdate

executeQuery()—for getting the data from database executeUpdate()—for insert,update,delete execute()—any kind of operations executeQuery() — This is used generally for reading the content of the database. The output will be in the formRead More…