Tag Archives: Database

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…

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…