VARIOUS TYPES OF TABLES

1)

mysql> create database student1;

mysql> use student1;

mysql> create table student(name varchar(30),regno int,address varchar(30),mail_id varchar(30),ph_no int)type=Innodb;

mysql> create table student1(name varchar(30),regno int,address varchar(30),mail_idvarchar(30),ph_noint)type=Isam;

mysql> create table student2(name varchar(30),regno int not null primary key,address varchar(30),mail_id varchar(30),ph_no int)type=heap max_rows=100;

mysql> create table student3(name varchar(30),regno int not null auto_increment primary key,address varchar(30),mail_id varchar(30),ph_noint)type=heapmax_rows=100;

mysql> create table student4(name varchar(30),regno int auto_increment primary key,address varchar(30),mail_id varchar(30),ph_noint)type=mergeunion=(student1,student2)insert_method=last;

2)

mysql> insert into student values('pream',15,'gandhi street','pream_2008@gmail.com',2436879);

mysql> insert into student values('pandi',12,'richi street','pandi_2008@gmail.com',24814228);

mysql> insert into student values('raji',21,'ram street','raji_2008@gmail.com',24822398);

mysql> insert into student values('rathi',20,'rose garden','rathi_2008@gmail.com',2468729);

mysql> insert into student values('dinesh raj',20,'angel garden','dinesh_2008@gmail.com',22232901);

mysql> insert into student1 values('priya raj',20,'angel garden','priya_2008@gmail.com',22232901);

mysql> insert into student1 values('preetha raj',20,'angel garden','preetha_2008@gmail.com',22232901);

mysql> insert into student1 values('praveen raj',20,'angel garden','praveen_2008@gmail.com',22232901);

mysql> insert into student1 values('rajini',20,'angel garden','rajini_2008@gmail.com',22232901);

mysql> insert into student1 values('ranjitha',20,'angel garden','ranjitha_2008@gmail.com',22232901);

mysql> insert into student2 values('ramraj',22,'rose garden','ramraj_2008@gmail.com',2246721);

mysql> insert into student2 values('rajeshwari',23,'rose garden','raji_2008@gmail.com',2246721);

mysql> insert into student2 values('santha',24,'rose garden','santha_2008@gmail.com',2246721);

mysql> insert into student2 values('rajathi',25,'rose garden','rajathi_2008@gmail.com',2246721);

Query OK, 1 row affected (0.00 sec)

mysql> insert into student2 values('renu',26,'rose garden','renu_2008@gmail.com',2246721);

mysql> insert into student3 values('fari',20,'green garden','fari_2008@gmail.com',2862430);

mysql> insert into student3 values('viji',21,'green garden','viji_2008@gmail.com',2862430);

mysql> insert into student3 values('paru',22,'green garden','paru_2008@gmail.com',2862430);

mysql> insert into student3 values('suji',23,'green garden','suji_2008@gmail.com',2862430);

mysql> insert into student3 values('dinu',24,'green garden','dinu_2008@gmail.com',2862430);

3)

mysql> select * from student;

mysql> select * from student1;

mysql> select * from student2;

mysql> select * from student3;

4)

mysql> select * from student where name regexp'^pre';

5)

 mysql> select * from student1 where name regexp'tha$';

6)

mysql> select * from student where name regexp'^pre|tha$';

7)

mysql> select * from student1 where name like '%raj';

8)

mysql> select * from student1 where name regexp'raj';

9)

mysql> create table class1(logid int auto_increment primary key,logts datetime,entry varchar(30));

mysql> create table class2(logid int auto_increment primary key,logts datetime,entry varchar(30));

mysql> create table log(logid int auto_increment primary key,logts datetime,entry varchar(30))type=m

erge union=class1,class2)insert_method=last;