Monthly Archive:: June 2016
30 Jun 2016
Free and Open Source Invoicing System
Many of us don’t know about there are good invoicing and billing software avaliable for Free which is open osurce and you can install it on your own server without paying single bucks. These Free invocing and billing software will help Freelancer, self-employed and small to medium sized companies which need a reliable
29 Jun 2016
How to Sell on Flipkart
Do you want to sell on Flipkart? Dont worry it’s not a tough job. Selling on Flipkart.com is easy and absolutely free. As you know Flipkart marketplace is India’s one of the largest platform for selling online. If you are looking to sell online on Flipkart then it’s good decession because your
28 Jun 2016
MySQL Commands For Database Administration
In this article we’ve compiled some very useful ‘mysqladmin’ commands that are used by system/database administrators in their day-to-day work. You must have MySQL server installed on your system to perform these tasks. How to change MySQL root password: If you want to change MySQL password, then you need to type the
25 Jun 2016
MySQL Database Commands
Today i am going to show you MySQL commands for performing database opertaions. There are few points which we need to keep in mind: All MySQL commands end with a semicolon ; if the phrase does not end with a semicolon, the command will not execute. Also, although it is not required,
24 Jun 2016
MySQL Storage Engines
Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE TABLE statement in MySQL 5.7 creates InnoDB tables by default.) Each storage engine has its
23 Jun 2016
MySQL Interview Questions Part 2
After writing interview questions for beginers, i am going to write some interview questions for experienced guys. Here i am picking up some questions which generally asked in interviews: 1- What is REPLCAE statement, and how do I use it? The REPLACE statement is the same as using an INSERT INTO command.
20 Jun 2016
How to Take Backup and Restore a MySQL Database
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard before upgrading a MySQL installation, and they can
19 Jun 2016
20 MySql Interview Questions for Beginers
MYSQL database is the one of the popular open source database used mainly with PHP and other online web aplications. I am going to give you some MySQL questions with answers which will help you in interview as well as brushup your MySQL sills with fast review of these questions. 1-What are
16 Jun 2016
How to create and extract tar, tar.gz and tar.bz2 files in Linux using command line
Data compression techniques has been extremely useful to us over the years. Whether its a zip file containing images to be sent in a mail or a compressed data backup stored on a server, we use data compression to save valuable hard drive space or to make the downloading of files easier.
15 Jun 2016
10 Basic and Important Linux Commands
If you are new Linux user then you must know these basic linux commands as a beginers. There are lots of other commands, more sophisticated commands – which you will learn one day. But here i am going to start with some basic commands. 1- ls - List all directory and files
- 1
- 2