CREATE TABLE `stu_info`
(
    s_id INT,
    s_name VARCHAR (100),
    s_add VARCHAR (100),
    s_contact VARCHAR (100),
    s_email VARCHAR (100)
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '01',
    'Shahnewaz',
    'Tejgaon',
    '01517054064',
    'shahnewaztamim@gmail.com'
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '05',
    'Sami',
    'Dhaka',
    '01911542154',
    'samipagla@gmail.com'
);
SELECT * FROM `stu_info`;

*****************************************

DROP TABLE `stu_info`;

*****************************************

ALTER TABLE `stu_info` ADD PRIMARY KEY(`s_id`);

****************************************

ALTER TABLE `bitm_php` ADD PRIMARY KEY(`bitm_id`);

****************************************

ALTER TABLE `bitm_php` CHANGE `bitm_id` `bitm_id` INT(11) NOT NULL AUTO_INCREMENT;

****************************************

INSERT INTO `bitm_php`
(
    `bitm_id`,
    `bitm_name`,
    `bitm_address`,
    `bitm_contact`,
    `bitm_email`
)
 VALUES
 (
     '',
     'Hasan',
     'Adabor',
     '01517054689',
     'tomal@gmail.com'
 );


****************************************

SELECT * FROM bitm_php WHERE bitm_id=2

****************************************

CREATE TABLE `stu_info`
(
    s_id INT,
    s_name VARCHAR (100),
    s_add VARCHAR (100),
    s_contact VARCHAR (100),
    s_email VARCHAR (100)
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '01',
    'Shahnewaz',
    'Tejgaon',
    '01517054064',
    'shahnewaztamim@gmail.com'
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '05',
    'Sami',
    'Dhaka',
    '01911542154',
    'samipagla@gmail.com'
);
SELECT * FROM `stu_info`;

*****************************************

DROP TABLE `stu_info`;

*****************************************

ALTER TABLE `stu_info` ADD PRIMARY KEY(`s_id`);

****************************************

ALTER TABLE `bitm_php` ADD PRIMARY KEY(`bitm_id`);

****************************************

ALTER TABLE `bitm_php` CHANGE `bitm_id` `bitm_id` INT(11) NOT NULL AUTO_INCREMENT;

****************************************

INSERT INTO `bitm_php`
(
    `bitm_id`,
    `bitm_name`,
    `bitm_address`,
    `bitm_contact`,
    `bitm_email`
)
 VALUES
 (
     '',
     'Hasan',
     'Adabor',
     '01517054689',
     'tomal@gmail.com'
 );

****************************************

SELECT * FROM bitm_php WHERE bitm_id=2

****************************************

SELECT * FROM `bitm_php` WHERE `bitm_address`='ctg'

****************************************

CREATE TABLE `stu_info`
(
    s_id INT,
    s_name VARCHAR (100),
    s_add VARCHAR (100),
    s_contact VARCHAR (100),
    s_email VARCHAR (100)
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '01',
    'Shahnewaz',
    'Tejgaon',
    '01517054064',
    'shahnewaztamim@gmail.com'
);

*****************************************

INSERT INTO `stu_info`
(
    `s_id`,
    `s_name`,
    `s_add`,
    `s_contact`,
    `s_email`)
VALUES
(
    '05',
    'Sami',
    'Dhaka',
    '01911542154',
    'samipagla@gmail.com'
);
SELECT * FROM `stu_info`;

*****************************************

DROP TABLE `stu_info`;

*****************************************

ALTER TABLE `stu_info` ADD PRIMARY KEY(`s_id`);

****************************************

ALTER TABLE `bitm_php` ADD PRIMARY KEY(`bitm_id`);

****************************************

ALTER TABLE `bitm_php` CHANGE `bitm_id` `bitm_id` INT(11) NOT NULL AUTO_INCREMENT;

****************************************

INSERT INTO `bitm_php`
(
    `bitm_id`,
    `bitm_name`,
    `bitm_address`,
    `bitm_contact`,
    `bitm_email`
)
 VALUES
 (
     '',
     'Hasan',
     'Adabor',
     '01517054689',
     'tomal@gmail.com'
 );

****************************************

SELECT * FROM bitm_php WHERE bitm_id=2

****************************************

SELECT * FROM `bitm_php` WHERE `bitm_address`='ctg'

****************************************

SELECT * FROM `bitm_php` WHERE `bitm_id` = 1 AND `bitm_name` = 'shahnewaz'


****************************************

SELECT * FROM `bitm_php` WHERE `bitm_id` = 2 OR `bitm_name` = 'shahnewaz'


****************************************

SELECT * FROM `bitm_php` WHERE `bitm_id` = 1 AND (`bitm_name` = 'shahnewaz' OR `bitm_name` = 'Newaz')

****************************************