3 articles SQL

How to download or copy large mysql databases with the help of putty?

This is one of the best examples I came across when I got tired in trying to download approax 1 GB of mysql database through phpmyadmin (export). Download large size database(s) using putty ssh access: 1. Download and login to putty Note: – You need to download putty software. Google to get it. – Your…

SQL Server all type of queries

Create table query CREATE TABLE sale ( datetime datetime, PROD_ID INT PRIMARY KEY, PROD_NAME VARCHAR(50), PROD_TYPE VARCHAR(25), UNITPRICE BIGINT, QUANTITY BIGINT, AMOUNT MONEY, ) SELECT * FROM sale truncate table sale drop table sale Insert values in a sales table INSERT SALE VALUES(’01-01-2008′,’100′,’SOAP’,’HOUSEHOLD’,’10’,’100′,’27000′) INSERT SALE VALUES(’01-02-2008′,’101′,’OIL’,’HOUSEHOLD’,’11’,’75’,’26000′) INSERT SALE VALUES(’01-05-2008′,’102′,’TOWEL’,’HOUSEHOLD’,’12’,’110′,’25000′) INSERT SALE VALUES(’01-25-2008′,’103′,’SHAMPOO’,’HOUSEHOLD’,’15’,’125′,’11000′) INSERT SALE VALUES(’01-26-2008′,’104′,’BRUSH’,’HOUSEHOLD’,’120′,’115′,’15000′)…

PHP Glossary

What is the minimum size of the file that can be uploaded using PHP and how can we change this: Be default Maximum size is 2MB and we can change the following set up at php.ini file. Set upload_max_filesize=2M How can we increase the execution time of a PHP script? By changing the following setup…