585 Views
When you website or product have lots of important data then you might be always worry about database backup. But taking the database backup daily is a time-taking job. Here we are providing solution for automatic MySql database backup on Monthly / Hourly / Weekly / Daily or Hourly basis. To ...
Sheetal Kumar
Feb 15, 2019
640 Views
When you install MySql server on ubuntu then it is not assessable from any client tool like MySql Workbench or Datagrip. To allow access in mysql to access from anywhere you need to change some configuration in MySql Server. First of all let me tell you how to install MySql Server on Ubuntu. Step ...
Sheetal Kumar
Feb 04, 2019
384 Views
Set Operations Set operations is used to merge query results by combining two or more queries into a particular single result.  SQL support three set operators which have the proper pattern.  <query 1> <set operators> <query 2> Union  The UNION command is ...
Anamika Gupta
Aug 14, 2018
1634 Views
Rules for SQL commands 1. SQL  commands can be written on multiple line. 2. Clauses are generally used to separate lines to build accuracy through it is not necessary. 3. Tabulation (Index) can be used. 4. Command words cannot divide over the lines. 5. SQL ...
Anamika Gupta
Aug 09, 2018
418 Views
There are four types of SQL (structure query language) operator which is used to operate with all the data types. In the SQL if the attributes or data are used in the list they must be embedded in a single quote ( ' ' ). Operator Description BETWEEN....AND.....  It ...
Anamika Gupta
Aug 07, 2018
439 Views
What is SQL? SQL is a structure Query language which is used to manage relational database and perform various operations .It is a standardized programming language working on a  various queries such as INSERT,SEARCH, UPDATE, DELETE  database record. It is pronounced as ...
Anamika Gupta
May 24, 2018
2379 Views
PostgreSQL is the open source relational database system. PostgreSQL has some advanced features of database like  User-defined types Table inheritance Sophisticated locking mechanism Foreign key referential integrity Views, rules, subquery Nested transactions (savepoints) Multi-version ...
Sheetal Kumar
Feb 13, 2018
Page 1 of 1 Pages       Total Records 7
  • First
  • Prev
  • 1
  • Next
  • Last