Mysql Introduction

Mysql is a RDMBS ie Relational Database Management System.

It is the most popular RDMS used with php.

Mysql uses various storage engine .Some of them are
MyISAM,MEMORY,HEAP,MERGE,InnoDB etc .The defalut storage engine is MyISAM.

Below are the some operations which are frequently used .

Insert

Syntax : insert into tablename(column1,columan2…..) values (values1,values2…….).

alternate  syntax

insert into tablename values (values1,values2…….).

Eg :  Insert into user (name,age,sex) values (‘Manish’,’23′,’Male’)

Here table name is user, the order of column name and their values should be same and their numbers also. Here , value for name column is ‘manish’  for age its ’23′ and for sex its Male .there are 3 columns and 3 values.
Resulting table will be

Name Age Sex
Manish 23 Male

Insert into user (name,age,sex) values (‘Manish’,’23′)  , it will give an error because of column and values count mismatch

 

READ  How to fix an Adobe Edge Html5 animate that restarts the loop

Leave a Reply

Your email address will not be published. Required fields are marked *