Excel Image

 In excel, when you you copy the cells, it will save as image in clipboard

How to block or unblock css in website in chrome - How to change agent of chrome

 > Go to chrome developer tools

> Go to Network Tab

> Click on CSS, JS, ALL

> Press CTRL + F5 Key and you will see files. You can block that files.

> And you can change slow 4g or fast 4g or you can change agent in Chrome.

How to record website in chrome

 >Open developer tools

> Click on Recorder

> Click on Create recording

> Click on Start recording.

> Click on website and when you click on buttons and anywhere it will save.

>You can import, export and delete the recordings.

>It will save as JSON file.

>Click on play recording to play.

if statement in MySql - if condition in MYSql - if in MySql

 select IF(0 > 0, 'True', 'False') as message;

if exist drop and create database in MySql

 create DATABASE IF not EXISTS test2;

 drop DATABASE IF not EXISTS test2;

How to create new tab in My Sql

 Click on Create a new Sql Tab.    Below is the screenshot:-

What is called t1 and t2 in join

 Select * from table1 t1 inner join table t2 on t1.id = t2.id 

Here t1 and t2 are called alias.

How to create stored procedure in MySql and how to call stored procedure

 DELIMITER $$

CREATE PROCEDURE new_procedure_procedure_name()

BEGIN

    SELECT * 

    FROM test.new_table t1

    LEFT JOIN test1.table1 t2 ON t1.id = t2.id;

END $$

DELIMITER ;

===============================

CALL new_procedure_procedure_name();

How to create new database in MYSql

 > First open My SQL workbench

>Than click on Database menu and click on Connect to database

> Than in navigator , Select Schemes tabs

> Right click in navigator and click on Create schema 

> and Type name and click on apply and click on apply and click on finish

How to connect MySql and how to install MySql

> First download MySql Workbench

> Than click on Database menu and click on Connect to database.

> Than click on OK button

> Than click on Schemas  tab.

> Than write query 

For Creating database

Create Schema test or Create Database test;