Skip to main content

Posts

Showing posts from 2016

SQL Help

History of MySql: It was created and supported by MySql AB, a company based in Sweden.This company is now a subsidiary of Sun Microsystem. On April 20th 2009 Oracle corp . announced a deal to acquire Sun Microsystems. MySql was invented by Michael Widenius. MySql has been named after Monty’s daughter My. The logo of MySql, the dolphins, is named as “Sakila”. Server: It is a machine which listen clients request and respond according to it and return content from database which is required by client. Client: They are the machine send queries to database in pre-defined format. Data: Raw facts are known as data that doesn’t conclude result. Database : Collection of data in the form of tables. Tables: Collection of Record. Records: Collection of columns. Cardinality: No. of Records in a table. Degree: No. of Columns in a table. Keys: They are the fields or columns. Primary key: It is used to uniquely identify a record in a table. It must be not null,it mu...